Build cycle for sending message and image with whatsapp to multiple mobile numbers

AppSheet AppSheet Q&A
,
1

I have 3 tables.

  1. CUSTOMERS: [Customer ID], […], [Mobile Number]

  2. MESSAGE: [Message Id], [Message Text], [Image Field]

  3. MESSAGE ROWS: [Message Row Id], [Message Id], [Customer Id], [Selection (yes / no)]

With a click I would like to copy all the [Customer Id] and only the active [Message Id] in the MESSAGE LINES table and then check only some customers in [select] to send [Message Text] and [Image Field]

Could you help me understand how to do it.

Ps.
I know how to write the WhatsApp API to open the app which receives a txt string

Thanks

2

Sandro_Ingrao:

With a click

A click where? What would the user click on? Where in your app would the user click it?

Sandro_Ingrao:

I would like to copy all the [Customer Id]

Doable.

Sandro_Ingrao:

and only the active [Message Id] in the MESSAGE LINES table

I assume “MESSAGE LINES” and “MESSAGE ROWS” are the same?

How does the app know what the “active [Message Id]” is?

Sandro_Ingrao:

and then check only some customers in [select]

What does this mean?

3

I solved otherwise. I call WhathsApp in which I have prepared previous groups and manage in this way the sending of the text and files.

Thank you very much for showing interest. I hope I can have your / your support in the future as well. In making apps, developing programs, for my needs, is a child’s dream that comes true and with you it is easier and more stimulating

1 Like