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,
Solved! Go to Solution.
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?
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)
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |