dynamic select box

 
1
0
-1

Hi!

I already setup 5 organizations in the apply leave system. I would like to set the approver dynamically according to the selected organization of the current user only. for example when cat (in joget org) login, the approver listed will be the HOD of joget. but when chriss (in icon org) login, the approver listed will be the HOD of icon.

How can i do it? what kind of binder is suitable?

thank you

 

    CommentAdd your comment...

    3 answers

    1.  
      1
      0
      -1

      Hi Noor Juaini Zakaria

      If you are running Joget Workflow on MySQL, you can download and install this free Windows database management tool SQLyog Community to view the database, tables and columns generated by the Joget forms. See image below.

      If you define the table name in the Joget form as "yourtablename", the full table name in database is app_fd_yourtablename.

      If you define the field name in the Joget form as "firstName", the full column name in database is c_firstName. Exception is the primary key remains as "id".

      More documentation available in Joget Knowledge Base on Text Field.
      1. Noor Juaini Zakaria

        thank you Andrew!

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

      I want to use jdbc binder, but i don't know the name of column name setup in joget database to make the query. for example the organization column name and group name assigned in database. how i want to solve this?

       

      can i view the database?

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

        Hi Noor

        You can try the User Options Binder for user selection.

        1. Noor Juaini Zakaria

          the notes is too general..do you mind to share an example of implementing user options binder? thank you Andrew.

        CommentAdd your comment...