how should I build the checkbox dynamically with Elements fr

Suite and Optimus Suite 5
#1

how should I build the checkbox dynamically with Elements from the database:

Hello everyone,
I have a small problem since 3 days, in fact I would like to build a list of 14 checkbox,
where the elements (label, value, name) from the database.

can someone have an idea?

Thank you for your contribution.

#2

You need to generate corresponding json or xml for form init according data in your database

#3

This is the json file I built, and I want the properties value, name and label come from the database

list:
				[
					{type: "settings",position: "label-right",labelWidth: 250},
					{type: "label", label: "Associer les commandes à ce groupe",name: "validation",value:""},
					{type: "checkbox", label: "Creer un ordre de mission",name: "creer_om",value:""},
					{type: "checkbox", label: "valider un ordre de mission",name: "valider_om",value:""},
					{type: "checkbox", label: "Cloturer une mission",name: "cloturer_om",value:""},
					{type: "checkbox", label: "Annuler une mission",name: "annuler_om",value:""},
					{type: "checkbox", label: "Creer un ordre de frais",name: "creer_of",value:""},
					{type: "checkbox", label: "valider un ordre de frais",name: "valider_of",value:""},
					{type: "checkbox", label: "payer les frais de mission",name: "payer_of",value:""},
					{type: "checkbox", label: "Valider une mission en tant que responsable de service",name: "valider_resp",value:""},
					{type: "checkbox", label: "Valider une mission en tant que responsable RH",name: "valider_rh",value:""},
					{type: "checkbox", label: "Valider une mission en tant que Directeur général",name: "valider_dg",value:"10"},
					{type: "checkbox", label: "payer les fraisde mission en tant que responsable de la caisse",name: "payer_caisse",value:""},
					{type: "checkbox", label: "Cloturer une mission en tant que Responsable de service",name: "cloturer_resp",value:""},
					{type: "checkbox", label: "Cloturer une mission en tant que Responsable RH",name: "cloturer_rh",value:""},
					{type: "checkbox", label: "Cloturer une mission en tant que Directeur général",name: "cloturer_dg",value:""}
				]

I do not know how to do

#4

Hi

json is almost correct,
{type: “checkbox”, label: “Creer un ordre de mission”,name: “creer_om”,value:""}

here you have label and name, just set “1” for value

#5

What should I do so that everything comes from the database

#6

sorry not sure I understand your question

#7

I have this xml file and, I want to build it dynamically so this properties (label,values,name) come from my database.the table in my database has two fields: id and libel

<?xml version="1.0"?>
<items>
		<item type="settings" position="label-right" labelWidth="250" />
		<item type="hidden"  name="idcache"  value="save"/>
		<item type="hidden"  name="op"  value="-1"/>
		<item type="input"  inputWidth="200" labelWidth="100" name="nom" label="Nom du groupe" validate="NotEmpty" position="input-right" />
		<item type="label" name="validation" labelWidth="auto" position="label-right" label="Associer les commandes à ce groupe" />
		<item label="Creer un ordre de mission" name="creer_om"  value="" />
		<item type="checkbox"  label="Creer un ordre de mission" name="creer_om" value=""/>
		<item type="checkbox"  label="valider un ordre de mission" name="valider_om" value="2"/>
		<item type="checkbox"  label="Cloturer une mission" name="cloturer_om" value="3"/>
		<item type="checkbox"  label="Annuler une mission" name="annuler_om" value="4"/>
		<item type="checkbox"  label="Creer un ordre de frais" name="creer_of" value="5"/>
		<item type="checkbox"  label="valider un ordre de frais" name="valider_of" value="6"/>
		<item type="checkbox"  label="payer les frais de mission" name="payer_of" value="7"/>
		<item type="checkbox"  label="Valider une mission en tant que responsable de service" name="valider_resp" value="8"/>
		<item type="checkbox"  label="Valider une mission en tant que responsable RH" name="valider_rh" value="9"/>
		<item type="checkbox"  label="Valider une mission en tant que Directeur général" name="valider_dg" value="10"/>
		<item type="checkbox"  label="payer les fraisde mission en tant que responsable de la caisse" name="payer_caisse" value="11"/>
		<item type="checkbox"  label="Cloturer une mission en tant que Responsable de service" name="cloturer_resp" value="12"/>
		<item type= "checkbox"  label="Cloturer une mission en tant que Responsable RH" name="cloturer_rh" value="13"/>
		<item type="checkbox"  label="Cloturer une mission en tant que Directeur général" name="cloturer_dg" value="14"/>
		<item type="button" value="Enregistrer" name="enregistrer"/>
</items>

Thank you for your contribution

#8

DHTMLX components don’t work directly with database. if you need to bind form with server, you can be guide the documentation, for example docs.dhtmlx.com/doku.php?id=dhtm … orm_server