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

    Include EDIT Link in Google Spreadsheet and Excel CSV Report.

    Asked by Naatak on May 06, 2013 at 03:24 AM

    Hi,

    two feature requests:

     

    I use both your "report" button to download all my submissions and the google spreadsheet integration to obtain all submissions. However, what is missing in both is the "edit_link". I would request to add that capability to both "report" button and google spreadsheet integration.

     

    Another thing that I would request is auto-refresh of google spreadsheet integration. Currently, new entries can come into the sheet and so can edited entries. But if I do anything else with that sheet (like add/modify certain columns), the integration is broken. currently, I remove that integration and add a new one on a weekly basis. as you can imagine the pain in this approach, I request a auto-refresh capability of the jotform-to-google-spreadsheet that recreates the sheet from scratch.

     

    Thanks,

    siva

    Submissions JotForm refresh thanks
  • Profile Image
    JotForm Support

    Answered by jonathan on May 06, 2013 at 08:34 AM

    Hi Siva,

    Thank you for contacting us.

    First off, I would like to inform you that I will be requesting you to create a separate post/topic for the 2nd mentioned feature request. You can do so here http://www.jotform.com/contact

    We have to do this because we want to make each post/topic as individual as possible and focus on the exact requirements or question the post is all about.

    ---

    I will make this post about the 1st feature request (as mentioned, create new for the 2nd).

    There is already an edit_link capability on the form. The edit is done on per submission data. Meaning, everytime you want to edit the form's submission data, there is an assigned edit id# for that submission id#. When you edit submissions, you can generate the reports again, and the updated/edited submission will reflect on the newly created report or integrated google spreadsheet.

    Could it be what you wanted to do instead is to be able to edit submission and it should reflect on all the reporst or google spreadsheet without re-generating the reports anymore?

    Simply put, to my understanding, you wanted that, when you edit submissions, the reports will also automatically updates. 

    Thanks.

     

  • Profile Image

    Answered by Naatak on May 06, 2013 at 10:09 AM

    Jonathan,

    Thanks for the response. But I understand that the reports and google spreadsheet get the updates when edits are performed. What I want is a another column in the report/spreadsheet with the edit_link for each entry/submission. 

    For example: Before:

    SubmissionId | Name | Amount 

    ------------------------------------

    1                  | Siva    | 10.50

     

    For example: After:

    SubmissionId | Name | Amount | Edit_Link

    -------------------------------------------------

    1                  | Siva    | 10.50    | jotform.us/edit/sessionId=xyz

     

    This way, when I download the reports/google-spreadsheet I can just click on that link to edit some submission.

     

    - Siva

     

  • Profile Image
    JotForm Support

    Answered by Welvin on May 06, 2013 at 12:00 PM

     

    Hi,

    I've change the title of this thread to more suitable one. Just one thing is that, you cannot create two Google Spreadsheet integrations. If you tend to share the Spreadsheet result, you may expose the edit link to anyone. Note that anyone can modify the submissions if they can have the Edit Link.

    On the other hand, you can create as many Excel or CSV Report - if this feature will be implemented, you have the option to include or not to include the edit link.

    Well, I have this thread added to our Feature Request List. We'll let you know for updates or any development made into this.

    Thanks

     

  • Profile Image
    JotForm Support

    Answered by NeilVicente on November 11, 2013 at 11:58 AM

    This can easily be achieved using Excel functions.

    Take the following edit link, for example:

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

    The numbers in blue is your form's ID, which you can get from your form's URL.

    The numbers in red is the submission ID, which is explicitly provided on Excel files generated by JotForm.

    Using Excel functions, simply concatenate those strings and voila, your spreadsheet will have edit links for each submission.

  • Profile Image

    Answered by studentuniontest on August 29, 2014 at 04:04 AM

    can you give the formula for the above please

  • Profile Image

    Answered by aowejotform on August 29, 2014 at 04:41 AM

    You should be able to use this

    =A2&" "&B2

    it wil make CELLA2 "space" CELL B2

    Or use this but i dont know if that really works because of the many &&&

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

     

    Therefore maybe put "http://www.jotform.co/form.php?formID=32843181418858&sid=" and "&mode=edit"  in a cell and use this 

    =E2&A2&D2

    (E= http://.. A=submission D=&mode..)

  • Profile Image

    Answered by studentuniontest on August 29, 2014 at 10:08 AM

    sorry not really sure I understand that - is there an example I can see on a  spreadsheet?
  • Profile Image

    Answered by sb10ct on September 04, 2014 at 06:27 PM

    Hi,

    I am also interested in doing what Siva originally asked, which is have the edit link shown in the downloaded data (Excel, CSV, etc.).  My use for it is for when someone fills out my registration form and then wants to use a pre-filled form to register for another event (same form, now wants to register for a different sport, or another season, etc.).  I already have the auto responder and notifier emails set to show the edit link for this use, but I envision registrants deleting/losing their email with the link over a period of time and asking me for it.  It would be nice to have it in my "database" (downloaded Excel/CSV) instead of having to search my notifier emails.  

    I was unable to find the submission ID in the downloaded Excel spreadsheet report to do the recommended Excel formula (which is a great idea and easy enough).  Am I missing something?  The option to select the submission ID is not shown.  

    Thanks!

    Sarah

  • Profile Image
    JotForm Support

    Answered by jonathan on September 04, 2014 at 07:33 PM

    @Sarah

    Hi,

    I am sorry but the request ticket to have Edit Link in Google Spreadsheet and Excel,CSV report had already been disapproved. It seems this functionality did not have enough merit to be implemented on the form.

    As for the 2nd question I had created a separate thread for it here http://www.jotform.com/answers/424766

    We will respond to it as soon as we can.

    Thanks.

     

     

     

  • Profile Image

    Answered by sandiegosledhockey on September 06, 2014 at 11:12 AM

    Thanks Jonathan!

  • Profile Image

    Answered by towhidurmahadi on July 15, 2016 at 03:08 AM

    Can I remove edit link option from Google sheet? I removed it manually but somehow it comes again.
  • Profile Image
    JotForm Support

    Answered by Chriistian on July 15, 2016 at 05:22 AM

    Hi @towhidurmahadi. This seems to be an older thread. To better assist you, I have moved your concern to a new thread. Please follow this link to view that thread: https://www.jotform.com/answers/883281. We shall assist you with your concern there. Cheers.