How to send a message to clients at one time?

[kenda_lokman]

welcome everybody
I have a Customers table with the following fields:
(id, name, phone number)

I want to create a table with the following fields:
(message title, message body, date sent)

What is required is to send this message via WhatsApp to all customers at one time
Is this possible?
If possible, what is the best case scenario?

[kenda_lokman]

Why no one answers ؟

[dbaum]

Questions like this should be posted in the Q&A board, where they're more likely to be seen by someone who can provide an answer and won't confuse anyone reviewing this Tips board for the type of content it's intended for. I suggested to moderators that they move the post.

Also, expecting a response within a couple hours of posting is typically too optimistic.

[RedVox]

This is showing in the Q&A board for me.  

[dbaum]

---

@dbaum wrote:

I suggested to moderators that they move the post.

---

[RedVox]

This template provides a demonstration of integrating with WhatsApp.  However, the template only demonstrates how to start a chat with a single customer.  For starting a chat with multiple customers, you might be able to make some tweaks to this template.  However, if hoping to start multiple one-to-one chats with each customer, I think you'll find that requires much more significant work.  Looping in AppSheet requires a rather large workaround.   Good luck!

[dbaum]

That's a great sample, @RedVox. Thanks for sharing with the community.

What is the source of the several 206-555-10xx phone numbers? I see that most of them are actually associated with WhatsApp accounts. Are those generic phone numbers available for testing? I don't find any web documentation about them.

[RedVox]

I was only passing on samples that I had found. I can’t take credit for
either of them. Cheers!

[dbaum]

It looks like the WhatsApp Message Launcher app is from @MultiTech's portfolio.

So, I'll ask Matt about the source of the phone numbers used in the app:

---

@dbaum wrote:

What is the source of the several 206-555-10xx phone numbers? I see that most of them are actually associated with WhatsApp accounts. Are those generic phone numbers available for testing? I don't find any web documentation about them.

---

[MultiTech]

Just some random numbers to generate something that looks like a phone number from the United States. 💪

[dbaum]

The associated WhatsApp accounts are clearly not random. Some are even named "Test" or "API". One has a profile picture. It's a pretty big coincidence that your randomly chosen series of phone number happen to be set up by someone else (Meta? given the Seattle area code, maybe Microsoft?) seemingly for testing WhatsApp. 💪 indeed!

Number	WhatsApp Account	Name	Profile Picture
+1 206-555-1000	TRUE	[blank]	FALSE
+1 206-555-1001	TRUE	[blank]	FALSE
+1 206-555-1002	TRUE	Test	FALSE
+1 206-555-1003	TRUE	API21 SMB	FALSE
+1 206-555-1004	TRUE	[blank]	FALSE
+1 206-555-1005	TRUE	[blank]	FALSE
+1 206-555-1006	TRUE	[blank]	FALSE
+1 206-555-1007	TRUE	[blank]	FALSE
+1 206-555-1008	TRUE	[blank]	FALSE
+1 206-555-1009	TRUE	Test Business 9	FALSE
+1 206-555-1010	TRUE	API33 SMB	FALSE
+1 206-555-1011	TRUE	API29 SMB	TRUE
+1 206-555-1012	TRUE	[blank]	FALSE
+1 206-555-1013	TRUE	[blank]	FALSE
+1 206-555-1014	TRUE	[blank]	FALSE
+1 206-555-1015	TRUE	[blank]	FALSE
+1 206-555-1016	TRUE	[blank]	FALSE
+1 206-555-1017	FALSE	#N/A	#N/A
+1 206-555-1018	FALSE	#N/A	#N/A
+1 206-555-1019	FALSE	#N/A	#N/A

[dbaum]

FWIW, I did some more web searching for each of the numbers whose WhatsApp account has an explicit name. The one seemingly relevant result I encountered was https://wa.me/testurl/, but it leads to a page not found error. I remain curious about what these numbers are that @MultiTech stumbled across.