Solved: Link to record on email - Page 2

Romain · 03-20-2019 11:31 AM

Hi everybody,
Is there any solution to have a link on an email report to a specific data on a view.
In my example, I create a report 30 days before the due date to each responsible in order to update the status.
On this email,I would like to have a link directly to the record on Appsheet.
I have tried with these formulas but doesn’t works
<<LINKTOROW([Key], “Viewname”, “App-Name”)>>
<<CONCATENATE(“App-Name#view=Viewname&row=”, ENCODEURL([Key]))>>
The text appears but there is no link
Thanks

LeventK

@Romain
You shall remove the curly brackets wrapped with your app id. I have put them in my example to give you the idea. Your expression shall be:

Click <a href='<<CONCATENATE('https://www.appsheet.com/start/AppId#appName=CARFU-848637&table=CARFU&page=detail&row=',[KEY])>>'>HERE</a> to view the record.

You can get your AppId from User >> Links pane

https://www.appsheet.com/start/Your_AppID_is_this_part in the Browser Link parameter

At the end, your expression will look like this:

Click <a href='<<CONCATENATE('https://www.appsheet.com/start/aa6b68d5-8736-4f29-a936-d5666ec411dc#appName=CARFU-848637&table=CARFU&page=detail&row=',[KEY])>>'>HERE</a> to view the record.

View solution in original post