Choice list reference to table's column field

ericwtng
Mega Contributor

I would like to create a new choice field using the Form Design. For the choice list inside this newly created choice field, I want it to be able to reference to a table's column field. Let's say the "u_place_holder" table with the "department" field

Screen Shot 2015-07-30 at 3.37.06 am.png

So from this table's column "Department", all of the Finance, Marketing, Engineering, Sales, Procurement, Programming & Human Resource will become the choice list. And if I importing some more staff record with different departments into this table, my choice list will be added dynamically.

Similar to this:

Screen Shot 2015-07-30 at 3.57.13 am.png


Is there any way of achieving it?

1 ACCEPTED SOLUTION

bernyalvarado
Mega Sage

Hi Wan To Ng,



Why don't you make your Office/Department field of type reference and include as Department table as the reference. If you need to filter-down the departments to a few that you will like to display then you can use a reference qualifier to specify the criteria that an option should meet in order to be visible/selectable



Thanks,


Berny


View solution in original post

4 REPLIES 4

bernyalvarado
Mega Sage

Hi Wan To Ng,



Why don't you make your Office/Department field of type reference and include as Department table as the reference. If you need to filter-down the departments to a few that you will like to display then you can use a reference qualifier to specify the criteria that an option should meet in order to be visible/selectable



Thanks,


Berny


Gurpreet07
Mega Sage

If you want this field to be a drop down then you may need to provide attribute ref_qual_elements=field_name


Reference Qualifier on Lookup Select Box Variable


ericwtng
Mega Contributor

Great thanks ! It totally solved my problem.


Good day,



Can you please share what you did to get this to work? It is still not working for me.