Am a newbie and would like some help with the following:
1)frontlineSMS retrieves patients with an appointment from mysql database
2)sends messages to everyone that has an appointment in form of a questionnaire some like: you have an appointment at clinic A today, will you come?
3)the patient should be able to reply with a yes or no option, if no then they should be able to select a reason from a drop down list or a radio list etc
4)the answer is sent back to the database via frontlineSMS
What I want to achieve is, the system should be able to communicate with our existing database and sending the messages should be automatic for people having an appointment that day.
anyone with an idea of how to go about it? or is there any other way of achieving the same goal?