Form builder: global question response

Overview

Object name formbuilder_question_response
Table name psys_formbuilder_question_response
Path /preside-objects/formbuilder/formbuilder_question_response.cfc

Properties

property name="label" formula="${prefix}question.field_label" adminRenderer="none";

property name="question" relationship="many-to-one" relatedto="formbuilder_question" required=true ondelete="cascade";

property name="submission_type"      type="string" dbtype="varchar" maxlength=20 required=true indexes="type";
property name="submission_reference" type="string" dbtype="varchar" maxlength=50 required=true indexes="ref";

property name="question_subreference" type="string" dbtype="varchar" maxlength=100 required=false indexes="questionsubref" excludeDataExport=true  adminRenderer="none";

property name="response"           type="string"  dbtype="text";
property name="shorttext_response" type="string"  dbtype="varchar"  maxlength=200 indexes="shortresp" excludeDataExport=true  adminRenderer="none";
property name="date_response"      type="date"    dbtype="datetime"               indexes="dateresp"  excludeDataExport=true  adminRenderer="none";
property name="bool_response"      type="boolean" dbtype="boolean"                indexes="boolresp"  excludeDataExport=true  adminRenderer="none";
property name="int_response"       type="numeric" dbtype="int"                    indexes="intresp"   excludeDataExport=true  adminRenderer="none";
property name="float_response"     type="numeric" dbtype="float"                  indexes="floatresp" excludeDataExport=true  adminRenderer="none";

property name="sort_order" type="numeric" dbtype="int" required=false indexes="order" excludeDataExport=true  adminRenderer="none";

property name="submitted_by" type="string"  dbtype="varchar" maxlength=100 renderer="formUser";

property name="submission"   relationship="many-to-one" relatedto="formbuilder_formsubmission" required=false excludeDataExport=true;
property name="website_user" relationship="many-to-one" relatedto="website_user"               required=false excludeDataExport=true  adminRenderer="none";
property name="admin_user"   relationship="many-to-one" relatedto="security_user"              required=false excludeDataExport=true  adminRenderer="none";

property name="is_website_user" type="boolean" dbtype="boolean" formula="case when website_user is not null then 1 else 0 end"  adminRenderer="none";
property name="is_admin_user"   type="boolean" dbtype="boolean" formula="case when admin_user is not null then 1 else 0 end"  adminRenderer="none";

property name="parent_name"     type="string"  dbtype="varchar" formula="case when submission_type='formbuilder' then submission$form.name else '' end "  adminRenderer="none";