LinkedIn
Twitter
I appreciate your assistance in resolving this issue. Currently, I have a button that successfully redirects information from my record to WhatsApp, allowing me to select the contacts to whom the message will be sent. I would like to replicate the same functionality for Google Chat. Is this possible? I have searched for such an option without success.
I currenlty I have the expression for whatsapp like this:
"https://wa.me/?" & "&text=" & "*Tarea:* "&[Ticket Number] & "%0A" & "*Sitio:* "&[Site Name] & "%0A" & "*Nota:* "&[Note] & "%0A" & "*Fecha|Hora:* " & TEXT([Timestamp], "dd/mm/yyyy | hh:mm") & "%0A" &
& "%0A" &
IFS(
ISNOTBLANK([Tiny_Url]),
CONCATENATE("*File:*", " ",[Tiny_Url])
)
Have you taken a look at the article below. I tested per the article and one can send message from AppSheet app to the Google Chat space.
Use Apps Script to send an interactive chat message - AppSheet Help
Below is the message added in a record in the AppSheet App
The webhook sends the message to the Google chat as shown below
Have been following this. I also can now send a message but I want to include result from a Data Field. I am using this code:
const GOOGLE_CHAT_WEBHOOK_LINK = "Hidden Information";
function sendMessage() {
var timeZone = Session.getScriptTimeZone();
var Data = {
Id: Id}
const payload = JSON.stringify({ text: "Site Manager - DMS Services - Please Re-Synchronise - TEST POST - "+ Data + " "+Utilities.formatDate(new Date(), timeZone, "dd-MM-yyyy | HH:mm:ss")});
const options = {
method: 'POST',
contentType: 'application/json',
payload: payload,
};
UrlFetchApp.fetch(GOOGLE_CHAT_WEBHOOK_LINK, options);
}
How can I include the item of data called [Id]?
