Importing rawdata

Hello @slandoulsi,

I’m sorry, but I really do not understand your question. If you want to display the sections depending on the choice selected in a DropDown field, you should define dependencies.

For example, inserting a “DIV” field for each section (instead of “Section Break” fields), with all the fields corresponding to the section into it, and then, select the “DropDown” field, click the “Show dependencies” link in the choices section, and select for each choice, the corresponding “DIV” field that depends of it.

and that’s all.
Best regards.

Sorry for my confused question. I try to make it clearer.

I have a huge quantity of data to insert in the form. Each of them are to be entered as dropdown list choises. But this will take me hours if i use the form builder interface. So I was wondering if you can recommend a way to import them from an excel file by using the import section of the formbuilder or anythingelse.

Hope it clarifies

Thanks
Skl

Hello @slandoulsi,

My apologies, but the current version of the plugin does not includes this feature, however, if you have the information into CSV files, you can use the “DS” fields, in your case the “DropDown DS” (distributed with the “Developer” and “Platinum” versions of the plugin) to read the data from the CSV file instead to enter the choices manually.

Note that if your form includes too many “DropDown DS” fields, the form’s performance might be affected.

Best regards.

Hello

Thanks for this. That’s seems to be precisely what I’m looking for but can you please help me one step further. I read your online documentation but I’m still confused how to connect RecordesetDS and DropDownDS.

This is basicaly what i’m trying to achieve : I would like dropdown field2 to show choices filtered on dropdown field1 choice. The data to populate field1 and field2 are available in a local CSV file that looks like this

Column1;Column2
abc;123
def;456
ghi;789
def;101112
def;131415
xyz;161718

So,
– field1 should show only “abc”, “def”, “ghi”,”xyz”.
– If field1 selects “def”, then field2 should only show “456”, “101112”, “131415” as choices.

Please help me setting up RecordSetDS et DropdownDS accordingly.

Thanks a lot
skl

Hello @slandoulsi,

In this case you should use the Recordset DS field only for the second DropDown DS field, and directly the CSV file for the first own.

– Insert the first DropDown DS (fieldname1) field with the CSV file as the datasource choice that will use the Column1 for the values and texts of the choices.

– Insert the Recordset DS field (fieldname2) reading the CSV file, select the column to use for filtering (Column1) and enter as the attribute: “Where the value is equal to”, the tag of the first DropDown field: "<%fieldname1%>"

– Finally, insert the second DropDown DS field:
– with the “Recordset” option selected for the “Datasource” attribute,
– the name of the recordset field selected through the “Recordset” attribute (fieldname2),
– and the column’s name through the attributes: “Property for values”, and “Property for texts” (in this case Column2)

Best regards.

crystal clear

thanks

Hello

I’m back to this topic.
Your solution works fine but every click on the dropdown field make it slower and slower to update, until the final page crash.
Any idea about the reason to that ?

Best Regards,
skl

Hello @slandoulsi,

Could you send me the link to your webpage, and indicate the fields that are related in the process, please?

Best regards.