Link to record on email

behavior
reports
(Romain Carafray) #1

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 :crossed_fingers:

(Levent Kulacoglu) #2

@Romain
You can use HTML technique in the Email Body property of your workflow rule. Here is an example:

Click <a href='<<CONCATENATE('https://www.appsheet.com/start/{*AppId*}#appName=*YourAppName*&table=*YourTableName*&page=detail&row=',[KEY])>>'><b><u>HERE</u></b></a> to view the record.

(Romain Carafray) #3

@LeventK
Hi and thanks for the answer
I have tried and I receive now a link.
But, when I click on it, I redirected to Appsheet with an error message (see below)
The app is in test mode (not deployed yet), May it cause this trouble?

ERROR

Something has gone wrong!

The URL is: [/start/%7BCARFU-848637%7D]
(https://www.appsheet.com/start/{CARFU-848637})
App Template ‘{CARFU-848637}’ not found.

Here below what I have typed
href=’<<CONCATENATE(‘https://www.appsheet.com/start/{CARFU-848637}#appName=CARFU-848637&table=CARFU&page=detail&row=’,[KEY])>>’>HERE

(Levent Kulacoglu) #4

@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])>>'><b><u>HERE</u></b></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])>>'><b><u>HERE</u></b></a> to view the record.

2 Likes
(Romain Carafray) #5

@LeventK
Whoua !!! Works perfectly.
Thanks so much for your help, I will never found alone !
:clap:

1 Like
(Levent Kulacoglu) #6

You’re welcome @Romain