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

AppSheet AppSheet Q&A
1

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

2

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.


2X_7_78d27131197319bd131ec16bbe55ab5019faccae.png


2X_9_9cdefb7c0ab1335dc90621650fc9f5fba9f6ce03.png

3

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

1 Like
4

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"
)
2 Likes
5

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

2 Likes
6

You’re welcome.