Hi,

This should be possible with the JDBC Binder Plugin.
Depending on what you mean with a "list" (probably a grid?) their is an article in the knowledge base about populating a grid with the jdbc loader that should cover that off.

Cheers,

Eric

Hi Eric,

thank you for your answer.

In fact, with "list", I mean a dropdown (select) list in a Form.

I'm using the cloud edition of Joget and the data I need to use are in a local (on a PC in my LAN) Excel file.

I will have a look at the JDBC Binder to see if it helps.

Best regards,

Daniel

Hi,

Since you need to import the data from a local Excel file, you can use the Import Tool into the table of a form.

Then, you can populate the desired select box using the Default Form Options Binder to load the values from that form. You will probably want to use a Popup Select Box or Multi Select Box instead of a normal select box if you have many records.

Hi Anders,

Could you please provide me with a sample of what I need to do ?  The way to use Import Tool and how to link it to a select box in another form is not really clear to me.  How do I do the link between the columns in my CSV file and the pair « Value / Label » of the Select Box ?  What do I need to put in both forms ?

My CSV file is of the form « provider;email » and I would like to use column « provider » as Label and column « email » as value of my Select Box.

Thank you in advance,

Daniel

Hi, found a video tutorial on importing csv at https://www.youtube.com/watch?v=OWpEDZTPLwQ. You could import the data directly into the form table for the select box, otherwise you can also use this https://dev.joget.org/community/display/KBv5/Pre-populate+Form+Select+List+from+External+Source