Mass Update on Form Data

  • Profile Image
    inetregister
    Asked on November 11, 2021 at 01:17 PM

    Hello!

    1. Is there a way to update a bunch of rows populated by End Users directly into Jotform?
    2. Is it possible to convert a Text Field into a dropdown AFTER a few users have already populated a few forms?

    Thank you.

    Pranav


  • Profile Image
    Michal_S
    Answered on November 11, 2021 at 01:57 PM

    Hello!

    Yes, it's possible to update the rows, but you'll have to do it one by one:

    1636657010_618d6772a4a2d_submissions cha

    Your second inquiry is also possible, with the usage of the above functionality.

    You can download the form data for later reference, remove the Text Field (this will also remove the submission data associated with it - be careful), add the Dropdown, and set the Dropdown's value for the existing submissions based on the previous answer in the Tables.

    How to Download Form Submissions as Excel/CSV/PDF

    How to Edit Submissions Made on Your Forms

    Unfortunately, it is not yet possible to edit multiple submissions at once, so you have to do them one by one manually.

    Let us know if you require any further assistance,

    Thank you!

  • Profile Image
    inetregister
    Answered on November 11, 2021 at 02:28 PM

    Hello!

    Thank you for the info. This brings me to my next question on similar line since it looks like my data will require several manual edits.

    Question is - can I download all JotForms data in Excel, clean my data in Excel, and then import all this data into the same or a brand new form? In other words, can I start from reverse. Have the data, load it into Jotform, and then the new form becomes entry point for upcoming data fills?

    Thank you.


  • Profile Image
    parker
    Answered on November 11, 2021 at 03:39 PM

    Hello,

    You can import submission data from sheets. They do all count as new submissions though so if you have any worry about hitting a submission limit keep that in mind.

    https://www.jotform.com/help/308-import-app-easily-import-your-excel-or-csv-data-into-jotform/