Sending Whatsapp Messages

I have two tables:
1- Students
2- Messages

In the table Message, I have a column called “Status”
it contains either “Ready” or “Archive”

I want to send messages to specific students only when the message “Status” is Ready

to do so i creates an action , to go to an external website:
CONCATENATE(“Share on WhatsApp),"&text=",CONCATENATE(Select(Message[details],[CID]=[_THISROW].[ID]),[Name]))…

It works fine… but I don’t know how to check about the Message status, because I need only the messages with Ready status to be sent no any other message

Please any suggestions,

If I understand correctly, today it’s doing what you need but sending all the messages, “Ready” and “Archive” ones?
Have you tried AND()?

Maybe you’re looking for this?

2 Likes

Thank you for the quick reply, yes it helped me a lot in figuring out the solution…
I used the following expression

IF(IN(“Send”,SELECT(Message[Status],[CID]=[_THISROW].[ID])),TRUE,FALSE)

1 Like