Message to multiple whatsapp numbers

AppSheet AppSheet Q&A
,
1

Each month, I need to send a whatsapp message to multiple contacts in my database. I have a slice that limits the contacts to what I need. The list can change each month, but the message stays the same.

I have the following in an action (user opens the contact and selects the icon to send):

Concatenate(
“https://api.whatsapp.com/send?phone=”, ENCODEURL(CONCATENATE(“+57”,[Phone])),
“&text=”,ENCODEURL(“Message Here”))

But, there could be 20-30 contacts to whom the user will need to send the message.

Is there a method to grab all the phone numbers in my slice, and send the message one time to all the contacts in the slice?

1 Like