I have built a workflow rule. In this rule i want the user to get my latlong and/or address in the email/text. I want the user to be able to click on that latlong or address and take them to google maps. I tried doing this through the UX - Format Rules. But i have not been able to accomplish it yet.
My format Rule - i choose the correct table and column. I then choose โTinyโ - for the โWorkflow Template Formatโ - image format. it did not do anything.
I am only seeing text - not a clickable to a map.
This is my expression:
Tiger driver, <<[Driver]>>, will be arriving in 30 minutes at <<[ship address]>>
Where we are right now:
Current Location: <<[Current LatLong]>>
I want to also say - i am not seeing an image either. Which i thought was suppose to show.
Solved! Go to Solution.
A minor typo from me. ENCODEURL not ENDCODEURL
If you want to force them to Google Maps from a text/email, youโll need to craft a Google Map URL with your destination prefilled. Otherwise, its out of AppSheetโs hands and up to the userโs default settings for everything else. For example, on my phone all address pop up with a link to Google Maps no matter where the address is populated from. But I do not have my computer setup to do the same. So checking the same email wonโt give me a link.
ok. I read in an article: https://help.appsheet.com/en/articles/2965802-template-address-latlong-and-xy-display
that you could have them see the map.
So i cannot do this?
Hmm, I see what it says. How does it look in an email/text?
well. That is the funny thing. Text only. I cannot get an image at all.
I must have something wrong. Also, i cannot get it to send an email.
While having text only is ok, i want to be able to show exactly where the driver is (image). This would add a very cool feature to my emails.
Ooooo, you want the Google map to show up as an image? That definitely isnโt going to be supported directly through AppSheet.
If AppSheet does anything by default, it would be to automatically make latlongs and addresses into a clickable google maps link. I donโt mess with texts and emails so I donโt know what AppSheet normally would do. If itโs not already doing that, it would be easy to force yourself, by using HYPERLINK(), a Google Map URL, and the address or latlong.
To capture a picture of the map to embed in an email/text, that would require some other external service I think. Unless SNAPSHOT() can do it.
Ok. Well a clickable would be even better. But it is not doing that either. I will try SNAPSHOT(). Thanks
HYPERLINK(CONCATENATE("https://www.google.com/maps/search/?api=1&query=",ENCODEURL([LocationColumn])), "Text or [Column] To Display")
Thank you.
I tried it but it did not work:
<<[Driver from GeoTab]>>, from Tiger will be arriving in 30 minutes at <<[ship address]>>
Where we are right now:
Current LatLong: HYPERLINK(CONCATENATE(โhttps://www.google.com/maps/search/?api=1&query=โ,ENDCODEURL([Current LatLong])), โCurrent Locationโ)
It did not hyperlink and it shows what the expression says. Meaning - it shows the expression.
How did you put that in your template?
Scratch that, just send a picture of your template.
You got to wrap anything that isnโt plain text in the << >>
OH! Thanks
now it says this error:?
A minor typo from me. ENCODEURL not ENDCODEURL
You did it! Thanks!
Sorry - one more question. How can i bold something in this workflow rule?
In order to do that, youโll have to create an external template (the spot that say โBody Templateโ). In those templates, you format the text how you want it to appear (color, size, bold, italics, etc).
Now, granted, I donโt believe you can use those kinds of formats within a text message. You would need a fancier MMS message to do formatting. And that would require your own external Twilio account.
ok. I gotcha. I am still having trouble making it email using the SAME workflow rule. So i went to textingโฆ
I guess i am not putting <<>> in the right places?
As an example, if you copy and pasted this into a template file, the driver name and ship address would both be bold.
As far as getting the email to fire, what issue are you having with it? Just no email? An error?
no email at all. Its weird. Nothing in logs- like it never tries to email.
Hmm, weird. Not a lot to go on.
Yeah - so now i put that expression as my template (.txt file) and got an error:
NM - i pick old expression - spelled wrong!
You body template needs to be a Google Doc or a Word file.
Thanks for all your help!
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |