You are currently reviewing an older revision of this page.
The API is described here at the VERY BOTTOM of the page:
https://www.tessituranetwork.com/TNEW_7/TNEW.htm#Topics/Form_Fields.htm
Note that @line_id is required on product-based custom forms, but not on a checkout survey form.
TIPS:
TO CONFIRM: If all of the fields in a form are optional, the stored procedure will NOT fire if the form is interacted with, but WILL fire if the form is interacted with, even if the state of the form is the same as when the page loaded.
To suppress procedure functionality when the form is submitted empty, you must add conditional logic to your procedure.
When switching from default CSI creation to stored procedure execution, a couple of data points that are supplied automatically on CSIs are not provided directly to the procedure, depending on the product type.
For example, a custom form on a contribution saved to a CSI will include (?? fund, contrib_type, cont_amt ??), but when saving to a stored procedure, only @line_no is supplied. These other data points can be retrieved based on line_no by doing a lookup on T_WEB_CONTRIBUTION WHERE ref_no = @line_no.