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
Solved! Go to Solution.
@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.
@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?
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
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.
@LeventK
Whoua !!! Works perfectly.
Thanks so much for your help, I will never found alone !
Youโre welcome @Romain
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |