Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
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
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,
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
Hello,
I would like to populate a list field from an external source in Joget cloud edition. Is this possible, and if yes, how ?
Thank you in advance,
Daniel