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

  • WardChristman
    Asked 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
  • Steve VP of Sales Operations
    Replied on July 23, 2014 at 3: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:

    Data stored in Google sheets allow for editing by original submitter through edit link Image 1 Screenshot 20

    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 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

     

  • WardChristman
    Replied on December 31, 2014 at 5: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?

  • raul
    Replied on December 31, 2014 at 7: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.

    Data stored in Google sheets allow for editing by original submitter through edit link Image 1 Screenshot 30

    Data stored in Google sheets allow for editing by original submitter through edit link Image 2 Screenshot 41

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

  • WardChristman
    Replied on January 2, 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.

  • Ben
    Replied on January 2, 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