How to display actual URL in the google spreadsheet instead of Edit link hyperlink?

  • lbsenergyadmin
    Asked on June 26, 2018 at 3:23 AM

    When integrating with Google Sheet is it possible to change the Edit Link hyperlink to the actual URL?

  • Ashwin JotForm Support
    Replied on June 26, 2018 at 5:00 AM

    Please note that "Edit Link" is generated automatically and added in integrated google spreadsheet. With a little workaround it is possible to achieve your requirement. Here are the steps you need to follow:

    #1. Add a short text entry field in form and hide it.

    #2. Set the default value of the short text entry field as "https://www.jotform.com/edit/{id}"

    Please check the screenshot below:

    1530003428generateEditLink Screenshot 10

    When the form is submitted, this field will display the URL which can be used as edit link. Please check the screenshot below:

    1530003549editURL Screenshot 21

    The same edit URL will be displayed in the column of integrated google spreadsheet as well.

    Hope this helps.

    Do get back to us if you have any questions.

  • lbsenergyadmin
    Replied on June 26, 2018 at 5:22 AM

    Hi Ashwin,


    Thanks for your help. However I was after changing the Edit Link hyperlink that gets automatically sent to google sheets onto just a plain url.


    Is there anyway to bypass or hack the google sheet integration?

  • Ashwin JotForm Support
    Replied on June 26, 2018 at 8:21 AM

    Unfortunately there is no built in function in google spreadsheet to extract the URL from the hyperlink cell.

    I will check and get back to you if I am able to find any option to achieve your requirement.

  • Ashwin JotForm Support
    Replied on July 18, 2018 at 10:14 AM

    I am not sure if I have understood your requirement correctly. Do you mean to say that you want option to change the hyperlink text of edit link in google spreadsheet integration?

    Do let us know and we will escalate it to our backend team.

    We will wait for your response.

  • lbsenergyadmin
    Replied on July 20, 2018 at 7:26 AM

    What I require is to remove the "Edit Submission" hyperlink text and have the url link instead or be able to customize it (specifically - link to a field)

  • Ashwin JotForm Support
    Replied on July 20, 2018 at 9:28 AM

    Okay I understand that you do not want to display the "Edit Submission" text but show the edit link URL itself. 

    I would suggest you to please explain a bit more in detail on how you want to customize it when you say "(specifically - link to a field)".

    Please explain your requirement a bit more in detail so that we can pass it on to our backend team.

    We will wait for your response.

  • lbsenergyadmin
    Replied on July 20, 2018 at 9:59 AM

    Thanks for your prompt response.

    Effectively my only requirement is NOT to display the "Edit submission" hyperlink text but just show the link URL. I already have a workaround to achieve my requirement.

    I was thinking if I can use the "short text" field (and there is a way that the hyperlink text to edit submission is customizable) - I can link it to that. 

    The other alternative I am imagining is to have a parameter for the "Edit Submission" link to have a customizable text.

  • David JotForm Support
    Replied on July 20, 2018 at 11:28 AM

    We have had a few feature requests for this in the past but so far each one has been has been given a very low priority.  This is somewhat possible using excel functions since the submission ID is included.  Something similar to what is described in this thread:

    https://www.jotform.com/answers/422325-Google-Spreadsheet-Formula-for-generating-edit-link

    Except the current edit URL would be much more simple:

    https://www.jotform.com/edit/{submissionID}

    All that would be needed is to add a formula to combine https://www.jotform.com/edit/ with the contents of the submission ID cell.

  • lbsenergyadmin
    Replied on July 20, 2018 at 9:27 PM

    Thank you this is most helpful... I got exactly what I needed.

  • AgilityAssoc.Canada
    Replied on July 21, 2018 at 11:15 AM

    Hi,

    I had a very simular request. It required a formula on the sheet to accomplish the task.

    I use the Unique ID number and combined it with the submission number to get a simple name for the edit link. Here is my formula. The submission number is in S2:S column and the Unique ID number in C2:C . The result is this; Edit-1 and so on up the most current submission which is 815 so the link is Edit-815  I hope this is of some help.

    Robert

    =ArrayFormula(HYPERLINK("https://jotformpro.com/edit/"&S2:S, "Edit-"&C2:C))