Get edit link URL in Google Sheets

gleninneswaste
Asked on March 23, 2021 at 12:28 AM

Hi can you tell me how to get Google Sheets to capture the edit link URL (not just they hyperlink)?

This is a re-post of a comment on How to Integrate Forms with Google Sheets
Bojan

Jotform Support

Answered on March 23, 2021 at 07:05 AM
Greetings.
Unfortunately, it is not possible to send the text value of the edit link. You can always click on the link and then copy the URL from the Sheet:
You can also use the following formula to extract the text value from the hyperlink:
```
=REGEXEXTRACT(FORMULATEXT(D2),"""(.*)"",")
```
Let us know if you have any additional questions.