- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2015 01:02 PM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2015 11:04 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2015 11:04 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2015 11:20 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2015 10:02 AM
Great thanks ! It totally solved my problem.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2016 11:56 AM
Good day,
Can you please share what you did to get this to work? It is still not working for me.