Changes

Jump to: navigation, search

Custom Lookup Options

758 bytes added, 14:47, 5 July 2021
m
no edit summary
[[File:2021-07-ticket-124709-4.png|thumb|none|800px]]
 
===Setting Up a Successive Dropdown Lists===
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 following example 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.  ====Configuring the Parent Dropdown====# Import UniversityLookup.csv with the University ID as the Lookup Key ====Configuring the First Child Dropdown====# Import FacultyLookup.csv with the University ID as the Lookup Key and the Faculty ID as the Primary Key ====Configuring the Second Child Dropdown====# Import UniversityCourseLookup.csv with the Faculty ID as the Lookup Key and the Course ID as the Primary Key 
=Settings Explained=
Smartstaff
2,103
edits

Navigation menu