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.


  • Profile Image

    How to automatically generate Edit Links for submissions within a Spreadsheet

    Asked by BAX 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
    JotForm Support

    Answered by KadeJM 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.