-
ArtieAsked on March 2, 2018 at 4:37 PM
I am using Google Sheets with my form. All the fields are being pushed to my Google Sheet properly except I want the actual URL link to appear in the Edit Link column instead of a hyperlink.
Example:
I want this https://www.jotform.com/edit/3958303186233249286
Not This: Edit Submission
How can I achieve this?
Thanks!
-
MarvihReplied on March 2, 2018 at 6:50 PM
I believe capturing the {edit_submission} Original URL on Google Spreadsheet cannot be done on Jotform's side.
Not unless, the developers will change the way integration works and automatically send the naked URL/hyperlink.
However, I am positive that this can be done by creating a Formula on your Google Spreadsheet that will convert/remove the Hyperlink and just show the original edit URL.
I will need to do some test on this first. I will make sure to get back to you if I get the solution.
Thank you.
-
MarvihReplied on March 2, 2018 at 7:09 PM
Hello Artie,
I was able to find a solution provided by my colleague years ago.
To do this:
1. open the spreadsheet and
2. click on Tools -> Script Editor.
3. Now select the script for Google Spreadsheet (Google Sheets Add-On)
4. remove all code from Code.gs that is shown to you
5. copy all the code from here: https://pastebin.com/yMCyRyq0
6. paste it into empty Code.gs file that was just opened7. run this new script by clicking on Run -> onOpen
8. Make sure to authorize the script if asked for this
9. select the column in your spreadsheet with the hyperlink functions
10. click on Extract -> Replace formulas with Text strings (this is a new menu that will be shown in the toolbar)I tested it on my Google Spreadsheet integration and it worked like charm.
Please let us know if you are having trouble with this so we can assist you. -
ArtieReplied on March 5, 2018 at 11:42 AM
Wow, Thanks for your help. I ran the script. It works great, however, I want the script to run in real-time so that as an new entry is submitted in Jotform, the URL will auto populate on my spreed sheet. Otherwise, I have to run the script with each new entry.
-
ArtieReplied on March 5, 2018 at 12:43 PMWow, Thanks for your help. I ran the script. It works great, however, I want the script to run in real-time so that as an new entry is submitted in Jotform, the URL will auto populate on my spread sheet. Otherwise, I have to run the script with each new entry.
[AH]
[Social-Wood_0002_Layer-1_0000_Layer-4] [Social-Wood_0002_Layer-1_0001_Layer-1] [Social-Wood_0000_Layer-3] [Social-Wood_0002_Layer-1_0002_Layer-0] [Social-Wood_0001_Layer-2]
... -
John_BensonReplied on March 5, 2018 at 1:59 PM
Unfortunately, there's no option or tool to do this on the JotForm side. The workaround my colleague provided needs to run with each entry.
Let us know if you need further assistance.