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
@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.
@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
Romain:
Here below what I have typed> href=’<
@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.
4 Likes
@LeventK
Whoua !!! Works perfectly.
Thanks so much for your help, I will never found alone !
1 Like
You’re welcome @Romain