top of page
  • Writer's pictureMatt

How To Create A Clickable Link To A Specific Record (for an AppSheet app)

Updated: Mar 16, 2023

AppSheet, External Links, Texts, Push Notifications, Emails

 

UPDATED: 3/16/23


If you're like me, eventually you'll want the ability to send someone a notification of some kind:

- An email

- A text

- A push notification itself


And you'll want an easy way for the recipient of that notification to get into the specific record you're dealing with. (Sometimes in a specific view too)
 

The Formula


HyperLink(

CONCATENATE(

"https://www.appsheet.com/start/YOUR_APP_ID_HERE”,

LINKTOROW(

[ROW_ID_HERE],

"VIEW_NAME_HERE"

)

),

“VISIBLE_TEXT_HERE”

)


All in one row for easy copying:


HyperLink(CONCATENATE("https://www.appsheet.com/start/YOUR_APP_ID_HERE”, LINKTOROW([ROW_ID_HERE], "VIEW_NAME_HERE")), “VISIBLE_TEXT_HERE”)

 

First: you'll want to replace all the placeholders with your actual bits; Then: when you're ready to use the formula, it's best to remove all the line breaks & spaces as well - smoosh it all together when you're actually gonna use it


  • But I find it helpful to leave things spread out like that while working on the formula; - it helps me see the various different elements that I need to work with to get things right

  • After I've got the formula working, then I'll go back through and remove all the spaces and stuff for when I actually want to use the formula wherever - (like in a text notification or email template)

  • FYI: This isn't necessary though, you can leave it spread out like this if you wish


 

The first parameter of that formula:

  • "YOUR_APP_ID_HERE"

You can find this in the URL of your App editor, or the webapp.



 

The second parameter of that formula:

  • [ROW_ID_HERE]

This is the name of the KEY column for your table

  • This value needs to be the exact string used for the KEY column of the table

Pro Tip: It's best to just copy the value - This way you get all special characters; less chance of mistakes - You wouldn't believe how much time is wasted because I typed in the text and made a typo


 

The third parameter of that formula:

  • "VIEW_NAME_HERE"

This is the name of the VIEW in which you want to see the record

  • Again, it's best to just copy the name of the view



PRO TIP: for system views, there's a space towards the bottom, in the 'Behavior' section, where you can easily copy the name of the view all in one shot


 


The fifth parameter of that formula:

  • "VISIBLE_TEXT_HERE"

is the actual HYPERILNK TEXT you want visible




 

All together, they concatenate the actual URL needed to get someone to a specific record inside a specific view

  • When someone clicks on the link, they'll be taken directly to the record, inside the app if they're on a device with the AppSheet app installed, into whatever view you specified

  • This works for both the new Desktop UX experience, as well as legacy.

 

 

For more information about how you can apply further parameters to the URL (such as sorting & grouping [for tables and such], applying default values, and more) check out the post below


1,408 views0 comments

Kommentare


bottom of page