Choice list reference to table's column field

[ericwtng]

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

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:

Is there any way of achieving it?

[bernyalvarado · Accepted solution]

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]

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]

Great thanks ! It totally solved my problem.

[SC10]

Good day,

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