I have a workflow that in the email body I want to include a Link another App.
I want to autopopulate the destination app with the employee nameโฆboth apps have a field named โemployee nameโ
What would the syntax be?
HYPERLINK(
CONCATENATE(โhttps://www.appsheet.com/start/f7708211-b23b-4e30-b3c0-923c10899c98#view=New%20Formโ,LINKTOFORM(โNew Formโ, โEmployee Nameโ, โEmployee Nameโ)
))
Solved! Go to Solution.
<<LINKTOFORM(โNew Formโ, โEmployee Nameโ, [Employee Name], "f7708211-b23b-4e30-b3c0-923c10899c98โ)>>
the above code in the template results in this line in the email:(not clickable)
f7708211-b23b-4e30-b3c0-923c10899c98#control=New%20Form&defaults=%7B%22Employee%20Name%22%3A%22Test%20Person%22%7D
if I add https://www.appsheet.com/start/ to the start of that and copy and paste it into a address bar it worksโฆ
I just need the https://www.appsheet.com/start to be added and it to be a link.
https://www.appsheet.com/start/f7708211-b23b-4e30-b3c0-923c10899c98#control=New%20Form&defaults=%7B%22Employee%20Name%22%3A%22Test%20Person%22%7D
Most, if not all, of the LINKTOโฆ() functions have an optional app-id parameter:
LINKTOFORM( view-name [ , column-name , column-value ]โฆ[ , app-id ] )
I have not tried this but I would think all you need is this:
HYPERLINK(
LINKTOFORM(โNew Formโ, โEmployee Nameโ, [Employee Name], "desired app id")
)
it is not recognizing it as a โlinkโ in the email everything from Hyperlink on is unclickable textโฆ
does Hyperlink need something to let the system know it is a system function?
In the same email I have Supervisor Name: <<[Supervisor Name]>>
and it is workingโฆ
Is the HYPERLINK() expression in the email template enclosed in <<
and >>
?
<<HYPERLINK(LINKTOFORM(โNew Formโ, โEmployee Nameโ, [Employee Name], "desired app id"))>>
<<HYPERLINK(LINKTOFORM(โNew Formโ, โEmployee Nameโ, [Employee Name], โf7708211-b23b-4e30-b3c0-923c10899c98โ))>>
When I put the above code in my templateโฆit doesnโt sent the email at all. If I take it out it sends, but then I donโt have the link.
In the past I have seen that indicates there is an error with the code.
Does the syntax look right?
The fields are right and the app id is rightโฆ
Just to test, remove HYPERLINK(), leaving only LINKTOFORM().
<<LINKTOFORM(โNew Formโ, โEmployee Nameโ, [Employee Name], "f7708211-b23b-4e30-b3c0-923c10899c98โ)>>
the above code in the template results in this line in the email:(not clickable)
f7708211-b23b-4e30-b3c0-923c10899c98#control=New%20Form&defaults=%7B%22Employee%20Name%22%3A%22Test%20Person%22%7D
if I add https://www.appsheet.com/start/ to the start of that and copy and paste it into a address bar it worksโฆ
I just need the https://www.appsheet.com/start to be added and it to be a link.
https://www.appsheet.com/start/f7708211-b23b-4e30-b3c0-923c10899c98#control=New%20Form&defaults=%7B%22Employee%20Name%22%3A%22Test%20Person%22%7D
The proper formation of HYPERLINK() is this:
HYPERLINK( target-url , clickable-text )
It expects a second text parameter to insert as the text. So I image the function written as is was failing in the Workflow preventing the email from being sent.
I can not find the actual syntax for putting the links in the email template or the body of the email.
I am using the template.
I really would like to go to a form in another appโฆcan not get the code to work.
I tried thisโฆjust to see if I could get something to work, and it doesnโt work either. It is a syntax error because if I have it in, the email does not send at all, if I take it out it works.
Do you see anything wrong with this?
<<LINKTOAPP(GSuiteOffboarding-1247271)>>
Try placing the app-id in quotes.
I just tried inserting this into the Body of an email and received the following error message:
Because of the hyphen it thinks its an arithmetic operation.
By the way, going back and looking at the other posts, it looks like you had been using the UUID of the app and not the app-id. So I would try again but use the app-id - the value (or similar value if another app) you included in this latest post.
Laurie,
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
ServiceInsightBase-526414#control=Work%20Dashboard
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-52641...โ, โ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
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |