I must profusely apologize. I have led you down a totally incorrect path. In your initial post you actually had this very close.
I was under the impression that the LINKTO…() functions returned a fully qualified URL. They do not. And because they are formatted to be used within the AppSheet environment, the results of these functions cannot just simply be concatenated onto the proper URL string.
For example, When I used LINKTOVIEW() the text returned in the email was like this
and cannot be used in the URL as is.
To Get a Clickable Link
So, trashing the idea of the LINKTO…() function I went back to the core URL. i was able to get a clickable link in my email by using this expression:
<<HYPERLINK(“https://www.appsheet.com/start/ea11df8a-9df1-4f29-afea-d6300774751b#appName=ServiceInsightBase-526414&view=Work+Dashboard”, “Go to View Here”)>>
Notice the placement of the “appName” variable and the “view” variable.
For whatever reason, the clickable text did not appear and I wonder if HYPERLINK() is actually of any use at all. What I received in the email body was like that below but the link did work.
I am not aware of any other functions that help with the creation of these links. I do know that we can manually insert the URL’s and concatenate in column variables to make the URL dynamic, e.g. to go to a Detail View for a specific row.
I hope this helps you more than I have so far!
Clickable Link in Email