I have tested briefly but it kind odd how it works…
Email body resolve pretty much all columns in the body except the [Key] column.
I would like to send an “appscript/exec?value=”&[Key] link and it works on Desktop but not on mobile devices.
-Mobile device email body end up with “appscript/exec?value”
-[Key] can be anywhere in the body except not next to “appscript/exec?value=”
Security reasons?
You shouldn’t be dereferencing _THISROW at all here, so [_THISROW].[Key] should just be [Key].
You don’t want to display the Key value, you want the name attached to it. Try [Key].[Name] (replacing Name with the name of the column containing the name you want to display).
(I did changed to your suggestion and I got same result.)
Script is executed by [Key] so I doesn’t matter as much.
I have been playing with how it works… and it is confused dot COM.
iPhone could resolve links as expected - default email app
Desktop no problem at all - Outlook
Android - deletes everything after “=” - Gmail app AND Samsung Email
TESTING FORMULA:
“https://script.google.com/macros/s/deleted_after_equal_sign_Android/exec?keyH=”&[_THISROW].[Key]&"
“&”
https://script.google.com/macros/s/deleted_after_equal_sign_IOS_Encode(=)/exec?keyH"&ENCODEURL(“=”)&[_THISROW].[Key]&"
https://script.google.com/macros/s/deleted_after_equal_sign_DESKTOP/exec?keyH="&[_THISROW].[Key]
iPhone
Android
Outlook
You did not do as I suggested, and now you’re greatly complicated the situation with scripts. I won’t be able to help you further.
Apologies. It’s me being lazy with proper response.
Column name hasn’t got anything to do with it 
I did tested as per your suggestion and result is the same. I just did not post it with your suggestion
Possibly I wasn’t clear enough in my post.
For Android device (gmail app) is not returning anything after “=” unless its “%3D”
Appsheet action formula: resolve columns correctly
[Key].[Status_HO] = “Draft”
[Key].[Key] = “7d7ed295”
Outlook
Android
Thanks Steve
*ENCODEURL() *will work only for Android and will break URL for Desktop and iPhone.
… the issue is with the “=” on Android.
I’m very confused. 
