Smartstaff
2,460
edits
Changes
m
no edit summary
In the previous example, all the predefined options had to be hardcoded into to the custom field configuration settings. This could be a tedious an inefficient process if the custom data needs regular updates or new entries. The process can be simplified by importing multiple lookups. The section will illustrate how to use successive dropdown lists and reference multiple custom lookups without having to hardcode predefined options.
As an example, we want to set up a chain of parent-child dropdowns for course registration. We want the user to first select from a list of available universities, then select from a list of available faculties at that selected university, and lastly, we want the user to select from a list of available courses under that university faculty. All referenced CSV files are provided in the appendix below.
====Configuring the Parent Dropdown====
====Configuring the Second Child Dropdown====
# Import UniversityCourseLookup.csv with the Faculty ID as the Lookup Key and the Course ID as the Primary Key
|}
=Appendix==Sample CSV==UniversityLookup.csv===
University ID,Course ID,University,Course
0,0,--- Please Select ---,--- Please Select ---