Changes

Custom Lookup Options

8 bytes removed, 15:43, 17 May 2022

m

→‎Setting Up a Successive Dropdown Lists

[[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 laborious 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.

University ID,Primary Key,University 100,100,--- Please Select --- 100,100,Totally Totes College 200,200,Obviously OBVI College 300,300,Artisanal Art College 400,400,Coffee for Me University 500,500,Asymmetrical University of Aesthetics 600,600,University of Cold-pressed Flannel

===FacultyLookup.csv===

University ID,Faculty ID,Faculty,University 100,100,--- Please Select ---,--- Please Select --- 100,101,Arts & Literature ,Totally Totes College 100,102,Natural Sciences,Totally Totes College 100,103,Humanities,Totally Totes College 100,104,Mathematics,Totally Totes College 200,201,English Literature,Obviously OBVI College 200,202,Physical Sciences,Obviously OBVI College 200,203,History & Humanities,Obviously OBVI College 200,204,Mathematics & Computer Science,Obviously OBVI College 300,301,Literature ,Artisanal Art College 300,302,"Biology, Chemistry, and Physics",Artisanal Art College 300,303,"History, ~~Anthropoly~~Anthropology, and Psychology",Artisanal Art College 300,304,Mathematics & Philosophical Sciences,Artisanal Art College 400,401,Faculty of English Literature,Coffee for Me University 400,402,Faculty of Natural Sciences,Coffee for Me University 400,403,Faculty of History,Coffee for Me University 400,404,Faculty of Mathematics & Computing,Coffee for Me University 500,501,Modern Arts & Literature,Asymmetrical University of Aesthetics 500,502,Hard Sciences,Asymmetrical University of Aesthetics 500,503,Modern History & Anthropology,Asymmetrical University of Aesthetics 500,504,Mathematics & Computing,Asymmetrical University of Aesthetics 600,601,Department of English,University of Cold-pressed Flannel 600,602,Department of Science,University of Cold-pressed Flannel 600,603,Department of History,University of Cold-pressed Flannel 600,604,Department of Mathematics,University of Cold-pressed Flannel

===UniversityCourseLookup.csv===

University ID,Course ID,Faculty ID,University,Faculty,Course 100,1000,100,--- Please Select ---,--- Please Select ---,--- Please Select --- 100,1001,101,Totally Totes College,Arts & Literature ,Gothic Literature in the 19th Century 100,1002,102,Totally Totes College,Natural Sciences,Organic Compounds in Chemistry 100,1003,103,Totally Totes College,Humanities,Introduction to Modern History 100,1004,104,Totally Totes College,Mathematics,Introduction to Calculus 100,1005,101,Totally Totes College,Arts & Literature ,Comparitive Mythology & Folklore 100,1006,101,Totally Totes College,Arts & Literature ,Introduction to Latin American Literature 200,2001,202,Obviously OBVI College,Physical Sciences,Fluid Dynamics in Brownian Motion 200,2002,204,Obviously OBVI College,Mathematics & Computer Science,Advanced Lorentz Transformations 200,2003,201,Obviously OBVI College,English Literature,Analysis of Arthurian Legend 200,2004,202,Obviously OBVI College,Physical Sciences,Morphology in Evolution 200,2005,202,Obviously OBVI College,Physical Sciences,Thermodynamics 200,2006,203,Obviously OBVI College,History & Humanities,Early Modern Period 300,3001,303,Artisanal Art College,"History, ~~Anthropoly~~Anthropology, and Psychology",Architecture of the Roman Empire 300,3002,302,Artisanal Art College,"Biology, Chemistry, and Physics",Anatomy of the Human Body 300,3003,304,Artisanal Art College,Mathematics & Philosophical Sciences,Topology of Non-Euclidean Systems 300,3004,301,Artisanal Art College,Literature ,Ancient Epics and Poetry 300,3005,303,Artisanal Art College,"History, ~~Anthropoly~~Anthropology, and Psychology",History of the Dutch Golden Age 300,3006,302,Artisanal Art College,"Biology, Chemistry, and Physics",Virology and Epidemiology 400,4001,402,Coffee for Me University,Faculty of Natural Sciences,Inorganic Compounds in Chemistry 400,4002,401,Coffee for Me University,Faculty of English Literature,Russian Literature in the 19th Century 400,4003,401,Coffee for Me University,Faculty of English Literature,Proto-Indo European Folklore (Thesis) 400,4004,401,Coffee for Me University,Faculty of English Literature,Introduction to English Literature 400,4005,402,Coffee for Me University,Faculty of Natural Sciences,Nomenclature of Organic Compounds 400,4006,403,Coffee for Me University,Faculty of History,Monarchies Through the Ages 500,5001,504,Asymmetrical University of Aesthetics,Mathematics & Computing,Polynomial Differentiation 500,5002,501,Asymmetrical University of Aesthetics,Modern Arts & Literature,Ancient Greek Classics 500,5003,501,Asymmetrical University of Aesthetics,Modern Arts & Literature,Introduction to Renaissance Literature 500,5004,502,Asymmetrical University of Aesthetics,Hard Sciences,Quantum Mechanics 500,5005,504,Asymmetrical University of Aesthetics,Mathematics & Computing,Introduction to Algebraic Topology 500,5006,501,Asymmetrical University of Aesthetics,Modern Arts & Literature,Magic Realism in Latin American Literature 600,6001,602,University of Cold-pressed Flannel,Department of Science,Radiation and Thermonuclear Reactions 600,6002,602,University of Cold-pressed Flannel,Department of Science,Kinematics and Dynamics 600,6003,603,University of Cold-pressed Flannel,Department of History,Rise and Fall of the Mughal Empire 600,6004,603,University of Cold-pressed Flannel,Department of History,Neo-Classical ~~Archteture~~ Architecture Through the Ages 600,6005,602,University of Cold-pressed Flannel,Department of Science,Cardiovascular System Processes 600,6006,604,University of Cold-pressed Flannel,Department of Mathematics,Polynomial Field Theory

[[Category:Tools]]

← Older edit

Ann Vincent

Smartstaff

2,103

edits

Changes

Custom Lookup Options

SmartWiki