Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

We have a simple form with just one field of type "Dynamic dropdown (database)"

ConfiForms Form Definition
formNameioimTest

dynDynselect code as id, name from somevals7422036e-9a6f-4455-92d9-7140131fb9dadbdynamicselect

Which uses a SQL like this to get the values:

Code Block
select code as id, name from somevals

In a table we have just 3 rows:

 

23 23
23.00 23.00
23.00.00 23.00.00

idname

23

23
23.00 23.00
23.00.0023.00.00

Typing 23 into the field will offer you the other possible choices for the field

ConfiForms (FormView) Registrations Control
formNameioimTest

 

 

values in a form so far

ConfiForms TableView
formNameioimTest

dyn

 

Storage format

Code Block
<ac:structured-macro ac:macro-id="02ab691f-7a29-4345-84aa-d187accd8f82" ac:name="confiform" ac:schema-version="1">
  <ac:parameter ac:name="formName">ioimTest1</ac:parameter>
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="b3bfde7a-aefa-4006-897f-60e900a6841e" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">dyn</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Dyn</ac:parameter>
        <ac:parameter ac:name="values">select code as id, name from somevals</ac:parameter>
        <ac:parameter ac:name="extras">7422036e-9a6f-4455-92d9-7140131fb9da</ac:parameter>
        <ac:parameter ac:name="type">dbdynamicselect</ac:parameter>
      </ac:structured-macro>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="60746106-054b-4aeb-a9e7-3149219d8f70" ac:name="confiform-entry-register" ac:schema-version="1">
  <ac:parameter ac:name="formName">ioimTest</ac:parameter>
  <ac:rich-text-body>
    <p> </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p> </p>
<p>values in a form</p>
<ac:structured-macro ac:macro-id="8713fd28-cbf5-4a40-95c7-425ed62913ae" ac:name="confiform-table" ac:schema-version="1">
  <ac:parameter ac:name="formName">ioimTest1</ac:parameter>
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="d5028632-9ae4-4201-a8e2-2126891c3be1" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">dyn</ac:parameter>
      </ac:structured-macro>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>