In this quick demo we show how to access other fields your database query returns together with the data for your dropdown field

Which uses a SQL like this to get the values:

select id, name, link from CD_DEMO

In a table we have just 3 rows and we return 3 columns:


idnamelink

1

ConfiForms add-on for Confluencehttps://marketplace.atlassian.com/plugins/com.vertuna.confluence.plugins.confiform/server/overview
2ConfiDoc add-on for Confluencehttps://marketplace.atlassian.com/plugins/com.vertuna.confluence.plugins.confirest/server/overview
3Smart Templates & Pages nice apphttps://marketplace.atlassian.com/plugins/com.vertuna.confluence.plugins.smart-templates/cloud/overview



values in a form so far


Storage format

<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>