I need a Web application (or mobile) where I can create (or upload from XLS) a database with few fields. One will be date type and another phone number and depending on date field, to send SMS on that date (time of SMS will be setted in the app - ex: 10 in the morning) to the phone number with a message that use variables from the database (ex: Hello "name", today is your birthday and you are "age" years old). I need to send SMS messages via an Android phone that can be 24/24 on, with Internet and with unlimited SMS subscription in all networks. The phone will not be used for anything other than SMS.
Will be only one user of the app, the ADMIN. From admin panel will be 3 options: create a new database, update an existing database and manage SMS templates.
- Create a new DB: setting the fields of that DB (ex: DB name, person name, phone nr, email, City, etc) and after the fields are setted, Upload an XLS file with info for that DB
- Update an existing DB: select an existing DB, view the existing info and could edit the fields or Upload an XLS file with the fields from THAT DB and update the existing DB.
- Manage SMS templates: create templates using variables from the DB or edit existing templates
The MAIN IDEEA of the app is to send SMS on a specific date (the date from the DB on every record) using a specific template (the template assigned to that person from DB) and using a Android Phone with internet and free SMS subscription.