Send URL not Hyper Link

  • Profile Image
    Artie
    Asked on March 02, 2018 at 04: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!


  • Profile Image
    Marvih
    Answered on March 02, 2018 at 06: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.

    15200345361358.png

    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.

  • Profile Image
    Marvih
    Answered on March 02, 2018 at 07: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.

  • Profile Image
    Artie
    Answered on March 05, 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.

  • Profile Image
    Artie
    Answered on March 05, 2018 at 12:43 PM
    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 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]
    ...
  • Profile Image
    John_Benson
    Answered on March 05, 2018 at 01: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.