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

    Data stored in Google sheets allow for editing by original submitter through edit link

    Asked by WardChristman on July 22, 2014 at 11:56 PM
    I would also LOVE to see the data stored in Gsheets allow for editing by original submitter. We can do that now with Gforms into sheets, but it's tricky to capture the real edit link for each unique user. Go Jotform
    Google Spreadsheet Google integration Google
  • Profile Image
    JotForm Support

    Answered by steve on July 23, 2014 at 03:37 AM

    Hello,

    I believe you can do what you're asking. What you want is the {edit_link} option for your thank you page, and/or autoresponder.

    To set it up for Thank you page, click Setup & Embed->Thank you-> Thank you Message. It should bring up this:

    Click on the Edit Link on the right which contains the link the user can use to update their submission. Note that by default in the Thank you interface it's a plain text link, not an active link. You need to add <a target="_blank" href= formatting to make it a hyperlink. See screenshot above.

    - Then when the user clicks the submit button they will see a Thank you page with an active link they can use to update their submission. I verified that it's updated on Google Docs as well.

    The other method is to use the autoresponder. Here's a document on setting that up.

    https://www.jotform.com/help/26-Creating-a-Form-Autoresponder

    On the email template page it has the same Edit Link option. Include it in your email to the user. Note that this one IS an active link so you don't need to format it.

    I set up this simple example form if you'd like to see it working:

    http://support.jotform.com/form/42031716796962

    Please let us know if you have any questions or need anything else.

    Regards

     

  • Profile Image

    Answered by WardChristman on December 31, 2014 at 05:24 PM

    Hi Steve - thanks for this, very promising!

    I got it working same but would love to capture the {edit link} into the google sheet entry, is that possible?

  • Profile Image

    Answered by raul on December 31, 2014 at 07:46 PM

    Unfortunately, that's not possible.
    The integration with Google spreadsheet does not allow to select the fields you want to capture in the sheet. It will always send the information of all the fields in your form.

    If you have further questions, please let us know.
    Thanks.

  • Profile Image

    Answered by WardChristman on January 02, 2015 at 10:36 AM

    Are you saying because the {edit link} is not a field in the form it's not able to be captured? How can the email autoresponder capture it?

    Capturing this would be a huge benefit to customers who lose their email with the edit link or are too lazy to look for it or forget that it exists.

  • Profile Image

    Answered by Ben on January 02, 2015 at 12:36 PM

    Hi,

    Are you saying because the {edit link} is not a field in the form it's not able to be captured?

    In short, yes. The reason why is that edit link is made out of form ID, which we know upfront and the submission ID, which we only get after the submission is created.How can the email autoresponder capture it?That is a good question. These are the steps that are made once the user clicks on submit:1. submit click
    2. verify if all fields are correctly filled out (checks required fields)
    3. send data to jotform servers
    4. data gets accepted and stored into submissions
    5. submissions ID gets created
    6. emails are sent with the submission ID
    7. data is sent to be handled by integrations (such as Google Spreadsheet integration)
    8. response is sent back in regards to the thank you page with the submission ID
    9. thank you page is shown.
    As you can see there are many steps behind that one click and as you can see the emails get sent (6) after the data submitted is saved into submissions data.Capturing this would be a huge benefit to customers who lose their email with the edit link or are too lazy to look for it or forget that it exists.The {edit_link} is created like so:http://submit.DOMAIN_YOUR_FORM_IS_UNDER/form.php?formID=FORM_ID&sid=SUBMITSSION_ID&mode=editDOMAIN_YOUR_FORM_IS_UNDER = jotform.com or jotform.us, etcSo if someone contacts you for the edit link, you can either:1. find the submission by searching for their email through the Submissions Panel and build the link for them to send or
    2. you can set up the emails to send you the edit link as well and then just find the email and copy the built link (which would be the preferred version).Do let us know if you have any further questions, but if you would like to have the edit link shown to you in the Google Spreadsheet for each submission, please go here and open a new thread that we would then use to raise this as a feature request.Best Regards,
    Ben