Forums

Documentation for FORM BLOCK schema

Permalink
Hi, I'm looking for a documentation on Form Block database schema. In perticular the way btFormAnswers, btFormQuestions and btFormAnswerSet tables are mapped so that i can query the database for the form values.
 
ScottC replied on at Permalink Reply
ScottC
or just check out the adoxmls (not sure if the s is on there) under the block's directory under db.xml

I have no idea why, but I just opened it so i might as well paste it:

<?xml version="1.0"?>
<schema version="0.3">
   <table name="btForm">
      <field name="bID" type="I">
         <key />
         <unsigned />
      </field>
      <field name="questionSetId" type="I">
         <unsigned />
         <default value="0" />
      </field>
      <field name="surveyName" type="C" size="255">
      </field> 
      <field name="thankyouMsg" type="X" >
      </field>
Viewing 15 lines of 109 lines. View entire code block.
venkat replied on at Permalink Reply
Thanks for your reply.

Iam just trying to get the form field value on form submit.
Is there a better way than just querying the BtAnswers table with msqID and qsID from btQuestions table.
hereNT replied on at Permalink Reply
hereNT
The way that it stores and names the form fields, it's not easy to check on submit. For more control, you probably want to use the external form block.

It would be nice to add in a handle field similar to the page attributes for the form block, but last time I checked, it still wasn't there.