What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Is there any way to make it perform a mass update trough an import function?Asked by asccombaillaux on December 05, 2014 at 07:47 AM
Is there any way to make it perform a mass update trough an import function?
Say I want to have register for a sport event, linking my form with google spreadsheet I can update the data with the competitor number and update payed yes/no.
Mass update is easier in Spreadsheet than in JotForm submission edition feature.
These updates would be done massiveley on google spreadhseet then uploaded for update in the original jotfomr. In an ideal world the dubmissionId which is the last column inthe spread sheet could be used when imported as a primary key meaning update data by replacing existing values with the one coming from the spreadsheet.
You can use our Import Data App: http://apps.jotform.com/app/import_data. It's either you will use a new form to import the updated data or import it to the original form. Please try that and let us know if there are problems. So..
a. Mass edit submissions in the Google Spreadsheet
b. Download the spreadsheet in .xls or .csv format
c. Import it to your form using the import data app.
I gave it a try.
Data is loading properly but it is not upodating but adding rows of data. The only way to be able to update would through the use of "submission ID" which is not part of the imports.
To clarify, the Import Data have NO edit/update action. What it does is only Add or Append new rows of data.
So, as suggested by Welvin, you should instead edit/update first the data in a spreadshet (or outside the form) before you Import Data to the form submissions.
The imported data will not have Submission ID# because it is an internal numbering system that is dynamically generated with an actual submissions of a form.
If data were only imported without doing any form submissions action, the submission ID# will not be generated.
Unfortunately, it seems there is no mass updating mechanism available for the existing form's susbmissions. If you wanted to Edit submission, you will have to do it manually and individually using the Edit button in submission view
Hope this help. Please inform us if you need further assistance.
Thnaks for your input, I've sen th eEdit button but I was hping I could do a mass update and it's not the case I'll have to figure out an other way round.
You're welcome, Georges. Glad to see my colleagues was able to provide some clarifications. Anyway, feel free to update us should you have any further questions.
Thank you for using Jotform!