Need Help in Getting Data From Other Forms

I am struggleing. I spent 2 hours already and ask Jotform AI to help, and still I could not get its instructions on how to merge data from from three forms into one table. Three forms has an identifier which is the respondents email address. How to do it?

Hi Jenyltuazon,

Thanks for reaching out to Jotform Support. If you're looking into combining submissions from multiple forms, we can do that using the Combine Submissions tool, then import their 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. But if the method that's shown in this guide is what you'd like to do, can you tell us which specific step are you having challenges with?

After we hear back from you, we’ll know what’s going on and how to help.