Accepting and Processing an Inbound Email to fill in a form.
I have been knocking up a little demo and would like to have the ability to intraspect an email and extract information from it to add a record to a database. I'm thinking something event based like: have some ability in ZohoMail that sends an event (or calls a webservice or ZohoCreator API service) to my application in ZohoCreator when an email is received by ZohoMail that has some criteria/condition like " Email.Subject='ZohoRocks!' " . Then I want to have a function in ZohoCreator that extracts info from the email, say subject, sender, recipient, body using your various string functions etc and insert a record into a db using one of the predefined forms that I have set up. In this way I can have a user use the webUI or email (perhaps in the future to receive an sms) to add records to a table.
I guess an alternative, but not as scalable would be to have ZohoCreator poll a ZohoMail (or other email account) etc, to check if any new emails have arrived that matches some specific criteria. This would only be as real-time as the poll interval but this may be easier to implement perhaps.
Are either of these types of features available? If not, could you suggest a workaround or an alternative approach to address this type of requirement that I want?
:?: