Editting Bulk submissions options at once?

  • Profile Image
    funkyfro
    Asked on February 25, 2017 at 01:33 PM

    Hi there, we'd like to edit bulk submissions.  For instance, on our Team Registration form, we have 'Division 5' as a choice, we wanted to list it as 'D5' so we can view it easier in our Excel Spreadsheets.  I know if we change the option in our form, the future submissions will accept the new naming convention, but it doesn't change the existing submissions.  Is there a way to do this?  Thanks very much for your time.

  • Profile Image
    Jim_R
    Answered on February 25, 2017 at 03:46 PM

    You're correct, you can't change the name of the selected checkbox for existing submissions. Since you mentioned Excel, you can get around this by using Find & Replace All.

    e.g.

    Find 'Division 5' then Replace All instances of it to 'D5'

    Related article: Find-or-replace-text-and-numbers-on-a-worksheet

    In case you need more help, don't hesitate to let us know.

  • Profile Image
    funkyfro
    Answered on February 25, 2017 at 04:12 PM

    Hey there.  

    This doesn't accomplish my result as I'm pretty advanced in Excel and easily know how to do that.  I'd like to change every existing result in my submissions, and then match them with my future submissions so I can export the doc or display the form results dynamically on our webpage.

    Is there anyway to import submissions?  So I'd change them in Excel, delete all the existing submissions on Jotform, then import them from Excel into Jotform.

    Thanks.

  • Profile Image
    BDAVID
    Answered on February 25, 2017 at 08:07 PM

    Yes there is a way to import submissions. You can use the import app: https://www.jotform.com/help/308-Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm