Oct 7th, 2011, 10:06 AM
Hi Kevin,
Welcome to the forums!
Interesting question. So you have a totally separate (non-Form Tools) database containing data that you need to interact with? Neat... is it on the same server as your Form Tools installation?
I'm afraid I don't have any easy solutions. To get it to all work within the Form Tools interface (which would be best, of course) you kind of need to write a separate module. I'd tackle it like this: create a module with a template hook to display a "find key" section on the form submissions page which when entered, would send an Ajax request to get back the info. You could then feed that into the form submission, update it, then use the email templates functionality to create a default email template targeted at the appropriate recipient & containing that data.
Sorry, that was pretty high level. But it's non-trivial.
Alternatively...
Do you need to do the lookup right before emailing? Instead, could you grab the data from your second database table when the original form submission is put through? If so, you could create some code in the Submission Pre-Parser module to run on the server and store the appropriate code in the Form Tools table for each submission, right from the start.
But I gotta be honest: this is all pretty complicated and you'll need a developer handy.
Sorry I couldn't be more help...!
- Ben
Welcome to the forums!
Interesting question. So you have a totally separate (non-Form Tools) database containing data that you need to interact with? Neat... is it on the same server as your Form Tools installation?
I'm afraid I don't have any easy solutions. To get it to all work within the Form Tools interface (which would be best, of course) you kind of need to write a separate module. I'd tackle it like this: create a module with a template hook to display a "find key" section on the form submissions page which when entered, would send an Ajax request to get back the info. You could then feed that into the form submission, update it, then use the email templates functionality to create a default email template targeted at the appropriate recipient & containing that data.
Sorry, that was pretty high level. But it's non-trivial.
Alternatively...
Do you need to do the lookup right before emailing? Instead, could you grab the data from your second database table when the original form submission is put through? If so, you could create some code in the Submission Pre-Parser module to run on the server and store the appropriate code in the Form Tools table for each submission, right from the start.
But I gotta be honest: this is all pretty complicated and you'll need a developer handy.
Sorry I couldn't be more help...!
- Ben