We need to do this:
1. Collect data for first page with embedded Caspio datapage form.
2. When user moves to next page (or, in some cases, the next field on the form), we need authenticate, using the USPS Address Information, the data entered on the page or field just exited (while user is entering the next piece/set of data).
--Check with external web service to authenticate the info (eg, make sure the entered address is a USPS deliverable address and put the address in proper USPS format)
--Edit the Caspio record with the cleaned up data.
Or--if the data doesn't validate (eg, a non-deliverable mail address)--create a "flag" so that when the entry pages are finished, we can go back to this page and get better data.
3. Etc. for each new "page" of data.
So the question is: Is there a way to build a "trigger" into the Caspio DB that will access the USPS web service and run the authentication and data update automatically? Is this something we would use Caspio Web Service for? If not, what's the best way to do this (architecturally)?