How to automatically generate Edit Links for submissions within a Spreadsheet

  • Profile Image
    BAX
    Asked on April 13, 2015 at 01:04 PM

    I would like to get all the edit links for an application that we recently had that has close to 130 submissions? Is there a way to generate a spreadsheet that has all the edit links?

  • Profile Image
    KadeJM
    Answered on April 13, 2015 at 03:04 PM

    If I have understood you correctly you mean that you want to create the "Edit Link" for all 130 of your submissions within a spreadsheet.

    Currently, this is only possible when you view your submissions and edit them or alternatively enable the edit link inside your email notifications via a tag used for {edit_link} to click on and edit for each of the submissions you receive as they arrive one by one if needed. In turn that would be resubmitted and also update as a newly received submission if it has been connected to a spreadsheet.

    Alternatively, you could use something like - 

    http://www.jotform.co/form.php?formID=32843181418858&sid=247382717281912535&mode=edit 

    The numbers in green is your Form ID, which you can get from your form's URL. And the numbers in red is the submission ID, which is explicitly provided on Excel files generated by JotForm.

     

    You could then take those within the spreadsheets formulas such as with Excel's or even Google's Spreadsheets and have it generate an automated link generator.