Playground and DEMO space
This is a playground and demo space for ConfiForms and ConfiDoc addons developed and supported by Vertuna LLC
Most pages provide a storage format for the demo, so you can use the free add-on from Atlassian Confluence Source Editor to import this configuration into your Confluence and see it in action
To import examples from the storage format on Confluence Cloud please see this page
Please note, all the examples here are provided without any obligation and may or may not be incomplete or may have bugs, and we provide NO SUPPORT for these examples and demos.
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:
id | name | link |
---|---|---|
1 | ConfiForms add-on for Confluence | https://marketplace.atlassian.com/plugins/com.vertuna.confluence.plugins.confiform/server/overview |
2 | ConfiDoc add-on for Confluence | https://marketplace.atlassian.com/plugins/com.vertuna.confluence.plugins.confirest/server/overview |
3 | Smart Templates & Pages nice app | https://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>