How can I complete data set using 2 different forms

Hi,

Let's say I am organizing a specific show for which:

- Users will register based on 1 form

- Organiser will update data base using a second form afteer completing some checks let us say we just tick an OK box

How to make all this data visible by user and orgnaiser using one HTML report.

Thanks for your help.

Regards

Hi,

How about if you combine the submissions of the 2 forms on a 3rd form. And then create the HTML Report using the 3rd form data.

1. The JotForm Combine Submissions App will allow you to combine submissions.

link: http://apps.jotform.com/app/combine_submissions

2. Create a 3rd form that have fields/questions similar to the combined submissions data (the CSV file exported from Combine Submission App)

3. Import the submission data (csv file data) to the 3rd form. You can use the JotForm Apps Import Data to import data from CSV flat file to the form submissions.

link: http://apps.jotform.com/app/import_data

4. Now that the 3rd form have data, you can create HTML Report using its data.

User guide: http://www.jotform.com/help/209-How-to-create-an-HTML-Table-Listing-Report

Please tell us if this can work for what you need or not.

Thanks.

Hi,

Thanks, I think that should do it, just one related question if the import is done multiple times how to avoid duplicate lines ?

Is there any possibility to define a unique index to perform updates ?

Regards,

Georges

Hi Georges,

You can probably do the filtering of the existing data outside the form submission page..

You can export/download the submission data to Excel file and then filter.

User guide: http://www.jotform.com/help/73-How-to-Partially-Download-Form-Submissions-as-Excel-CSV-PDF

Please inform us if you need further help.

Thanks.