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.
Include EDIT Link in Google Spreadsheet and Excel CSV Report.Asked by Naatak on May 06, 2013 at 03:24 AM
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.
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 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.
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.
This can easily be achieved using Excel functions.
Take the following edit link, for example:
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.
can you give the formula for the above please
You should be able to use this
Or use this but i dont know if that really works because of the many &&&
Therefore maybe put "http://www.jotform.co/form.php?formID=32843181418858&sid=" and "&mode=edit" in a cell and use this
(E= http://.. A=submission D=&mode..)
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.
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.
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.