Move data from one Table to another

Can you move data from one table to another. I don't see this option as a source field? If not, do you have a suggestion on how we can move data that calculates from one form to another?

Hi kirkkeenan,

Thanks for reaching out to Jotform Support. What you can do is merge the submission from another form. You can use the Combine Submissions tool, then import the data into the same tab in Jotform Tables for easy viewing. First, let me show you how to use the Combine Submissions tool: 

1. Go to Combine Submissions page, click the on the Start Combining button.
2. In the window that pops-up, click on the Allow button.
3. In the list that comes up, select your form, and next to it, choose the fields that you want to merge. To select all fields, click on the Select All box.
4. Then, click on the Generate CSV File button and use the link below it to download the CSV file.

Now, let's import the merged CSV file to the Jotform Tables:

1. On your My Tables page, click on Create Table on the upper-right side of the page.
2. Select Import Data, and click on Upload File and select your file or simply drag and drop your file.
3. Toggle On the Set The First Row As Column Headers option, and click on the Short Text option to change your column types.
4. After setting the column types, click on the Import Data button.

Check out the screencast below to see how it'll look like:

Keep in mind that this merged table won't update automatically, so it only includes past submissions. You'll need to repeat the steps again to refresh it with new data.

Reach out again if you need any other help.