Inserting a link within a text field to a different spreadsheet row in the same form?

[Richard_White]

Hi, is there a way to insert a link (hyperlink or deep link) within the text of a field of a form that would populate the same form with data from a different row in my spreadsheet? Not a button but some type of actual text link

[MultiTech]

You can’t insert it into a text field like you see here (www.appsheet.com); but you can display the deeplink as an app-link.

[Richard_White]

Ok, thanks for the answer. That won’t work for what I’m doing which is basically a list in a field in which each list item would point to that items row in the same form. But again, thank you for your timely response

[MultiTech]

Hmm… the only way I can see something working here would be to create a dropdown that people could select where they wanted to go next - then create a navigation action that runs on the form save that looks at what they selected and uses either LINKTOFORM() or LINKTOROW() formula to open the form.

• LINKTOROW() is what you use if you want to open a previously saved record in a view, you tell the system which view to use (which can be a form view).
• LINKTOFORM() is what you use if you want to create a new record.

An example of what this formula would look like is something like this:

LINKTOROW(
 IFS(
  [Column] = "One", "Row 1",
  [Column] = "Two", "Row 2"
 ), 
"Form_View"
)

[Richard_White]

This might actually work for what I need. Thanks a ton!

[MultiTech]

You’re welcome.