How can I populate a list field from an external source in Joget cloud edition ?

 
1
0
-1

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

    CommentAdd your comment...

    4 answers

    1.  
      1
      0
      -1

      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.

       

        CommentAdd your comment...
      1.  
        1
        0
        -1

        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

        1. Anders

          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

        CommentAdd your comment...
      2.  
        1
        0
        -1

        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

          CommentAdd your comment...
        1.  
          1
          0
          -1

          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

           

            CommentAdd your comment...