I'm in the process of determining which forms builder extension to use while i'm planning a Joomla based website. Many of the free or paid plugins or extensions can seem to gather the data I need. My question is, once I've gathered the data, what options are there to manipulate the data?
What I want to do is once the data for a form is entered, analyze the data for particular choices and then kick off an email with a subset of that data contained in the email. The form should then be marked as "completed" or some sort of status indicating completion. I want this to be all automatic, obviously, running without human intervention.
I have programming experience, but none in php.
Any advice?