Dear Community,
I've stumbled upon a promising approach to integrate Google Chat directly into AppSheet action buttons, similar to the functionality we have with WhatsApp. However, I seem to be encountering a hiccup and could use some assistance.
Here's the situation: I've successfully integrated both WhatsApp and Google Chat into my client management table within AppSheet. However, while the WhatsApp button seamlessly takes users to a direct message with the intended recipient, the Google Chat button leads to the Google Chat website instead of opening a direct message with that person.
Below is the code I've utilized:
CONCATENATE(
"https://mail.google.com/chat/u/0/#chat/dm/",
[Email],
"?text=",
EncodeURL(concatenate(
"Hi ", [Client Name],
" This is John, Site Manager for your project at", [Project Name],
"I'm reaching out to discuss our ongoing project and any updates or questions you might have for the construction progress.",
" Please let me know when you are available to chat. Thank you!",
))
)
Could anyone kindly point out where I might be mistaken in this code or suggest any alternatives to ensure the Google Chat button directs users to the direct message of the intended recipient?
Your expertise and guidance would be greatly appreciated!
LinkedIn
Twitter
