Hi, I hope you can help me because I cannot advanced with this issue:
I have a Table called Schedule with Name, Phone and Date columns.
I need a schedule that daily at 8 AM does the following:
- Searches in the table, filtering all records where the Date columm is equal to today’s date.
- For all the records found, it sends a WhatsApp message to the phone numbers of the records found in the search.
I already have a functioning system, but what I’m not able to do is set up an automatic schedule for the messages to be sent daily.
Currently, I can schedule a message at the time of booking, but this is a schedule for each record.
What I want is for the schedule or the backend workflow to search the table every day and send out messages according to the records found or to all that were found.
Can someone please help me?
Regarding setting up an automatic schedule to send WhatsApp messages based on your table entries, you might want to explore using automation tools or scripts that can run scheduled tasks. If you’re using a specific platform or service for your database and messaging, they may offer built-in scheduling features or integrations with automation services. Otherwise, you could consider writing a script using a programming language like Python, which can interact with your database and use the WhatsApp API to send messages at scheduled times. Remember to ensure that you comply with WhatsApp’s terms of service and have the necessary permissions to send automated messages. If you need further assistance with the technical implementation, you might want to consult with a developer or a technical forum for more detailed guidance.