Hello I'm trying to figure out the best way to change the SMS response based on the number of times a message is received from a single user.
In other words, suppose a message that meets a specific criteria (has correct keyword) comes in four times from the same phone number, how can I configure the sms-service to reply differently? I've got (finally) the BB log into postgres, so I have a record of the previous messages. Obviously the text variable will not work... how about post-url or file variables? I'm thinking I would need to query the DB if the keyword is correct, run a count of that phone number, and post the message to the sqlbox send_sms table. Feels like the file variable option is best with some type of script, but I'd appreciate some direction, input and thoughts Thanks!! Scott
