Developers, I'm looking for someone to build an iPhone application to assist me and my work. I'm a college football coach and recruit many thousands of athletes. I'd like a way of sending texts directly from my iPhone that will go to very large groups of recruits, merging in some variables (like their first name), have it not come up as a group text, and have it come from my phone number so they can easily reply. Example:
I select a group to send it to, type in "Hey, [first name], how was your game last night? We've still got you on our board as a top [position]." And 348 different recruits think I've sent them a personalized individual text.
I'd like it to use a spreadsheet to pull data from, that way I can quickly edit it. I need the spreadsheet to be something I can easily edit on my PC or Mac (I have both) and transfer over to my iPhone. Excel or whatever free program you think is best.
The spreadsheet only needs 5 columns: First Name, Last Name, Cell Number, Position, and Status. Status will come in handy in a second. The possible entries for Status should be Prospect, Active, Incomplete, Complete, and Accepted.
-I open the app
-There is a "Load" button to select a spreadsheet to pull data from.
-There is a "Clear" button to deselect the spreadsheet.
-There is a little indicator light to show if a spreadsheet successfully is loaded (green) or if there isn't one selected (red).
-I select the spreadsheet file and it loads.
-There is a dropdown box for who I'd like to text. I select from the "Status" options of Prospect, Active, Incomplete, Complete, or Accepted. "All" should also be an option.
-There is a box for me to enter the text.
-There is an easy way of quickly inserting the variables [first name], [last name], and [position] into the text box.
-Each recipient receives a text from my phone, from my phone number, that has the variable spots filled in with data pulled from his row in the spreadsheet, and each text is individual so as to not be a group msg.
Hopefully that's enough information for you to build a quote. Please let me know if there are any questions.