Challenge! Who Can Simplify This Snippet?

Hello Blazers!

There are so many talented people in this community. I would love to see the different ways y'all can approach simplifying this snippet. Here's the details, and a sample snippet.

The needed output is for the user to ultimately be presented with a specific "Program Code" that is uniquely associated with a Degree Program Name they select by narrowing down parameters. This Program Code must be a value that can be referenced elsewhere in the snippet.

Select Venue: {formmenu: default=; Campus; Online; name=venue; cols=10}

Select Type of Program: {formmenu: default=; Associates; Bachelors; Masters; UG Cert; name=typeofprogram; cols=20}

Select Program Name: {if: venue == "Campus" AND typeofprogram == "Associates"}{formmenu: default=; Audio Production - A.A.S. - Campus; Cloud Technologies - A.S. - Campus; Computer Animation - A.S. - Campus; Computer Science - A.S. - Campus; Digital Arts and Design - A.A.S. - Campus; Film - A.A.S. - Campus; Game Art - A.S. - Campus; Game Design - A.A.S. - Campus; Game Development - A.S. - Campus; Graphic Design - A.A.S. - Campus; Media Communications - A.A.S. - Campus; Music Business - A.S. - Campus; Music Production - A.A.S. - Campus; Recording Arts - A.A.S. - Campus; Show Production - A.A.S. - Campus; Sportcasting - A.S. - Campus; Sports Marketing and Media - A.A.S. - Campus; name=campusassociates; trim=left; cols=50}{endif}
{if: venue == "Campus" AND typeofprogram == "Bachelors"; trim=left}{formmenu: default=; Game Art - B.S. - Campus; Game Art - B.S. - Campus (ext); Game Design - B.S. - Campus; Game Design - B.S. - Campus (ext); Game Development - B.S. - Campus; Game Development - B.S. - Campus (ext); Graphic Design - B.S. - Campus; Information Technology - B.S. - Campus; Media Communications - B.S. - Campus; Media Communications - B.S. - Campus (ext); Mobile Development - B.S. - Campus; Music Business - B.S - Campus (ext); Music Business - B.S. - Campus; Music Production - B.S. - Campus; Music Production - B.S. - Campus (ext); Recording Arts - B.S. - Campus; Recording Arts - B.S. - Campus (ext); Show Production - B.S. - Campus; Show Production - B.S. - Campus (ext); Simulation and Visualization - B.S. - Campus; Software Development - B.S. - Campus; Software Development - B.S. - Campus (ext); Sports Marketing and Media - B.S. - Campus; Sportscasting - B.S. - Campus; Sportscasting - B.S. - Campus (ext); Web Development - B.S. - Campus; Web Development - B.S. - Campus (ext); name=campusbachelors; trim=left; cols=50}{endif}
{if: venue == "Campus" AND typeofprogram == "Masters"; trim=left}{formmenu: default=; Entertainment Business - M.S. - Campus; Entertainment Business (Sports) - M.S. - Campus; Film Production - M.F.A - Campus; Game Design - M.S. - Campus; name=campusmasters; trim=left; cols=50}{endif}
{if: venue == "Campus" AND typeofprogram == "UG Cert"; trim=left}{formmenu: default=; 3D Arts - Certificate - Campus (7 mo Ext); Application Development Fundamentals - Certificate - Campus (7 mo Ext); Audio Arts - Certificate - Campus (7 mo Ext); Business - Certificate - Campus (7 mo Ext); Computer Science - Certificate - Campus (7 mo Ext); Creative Writing - Certificate - Campus (7 mo Ext); Film and Video - Certificate - Campus (7 mo Ext); Game Design - Certificate - Campus (7 mo Ext); Information Technology - Certificate - Campus (7 mo Ext); Intensive English Program - Certificate (Level 1) - Campus; Intensive English Program - Certificate (Level 2) - Campus; Intensive English Program - Certificate (Level 3) - Campus; Intensive English Program - Certificate (Level 4) - Campus; Marketing - Certificate - Campus (7 mo Ext); Media Strategy - Certificate - Campus (7 mo Ext); Sportscasting - Certificate - Campus (7 mo Ext); name=campusugcert; trim=left; cols=50}{endif}
{if: venue == "Online" AND typeofprogram == "Associates"; trim=left}{formmenu: default=; Audio Production - A.A.S. - Online; Computer Animation - A.S. - Online; Computer Science - A.S. - Online; Creative Writing - A.S. - Online; Digital Cinematography - A.A.S. - Online; Digital Marketing - A.A.S. - Online; Entertainment Business - A.S. - Online; Game Art - A.S. - Online; Game Business and Esports Associate of Science; Game Design - A.A.S. - Online; Game Development A.S. - Online; Graphic Design - A.A.S. - Online; Information Technology - A.S. - Online; Media Communications - A.A.S. - Online; Mobile Development - A.S. - Online; Music Business - A.S. - Online; Music Production - A.A.S. - Online; Sports Marketing and Media - A.A.S. - Online; Sportscasting - A.S. - Online; User Experience Associate of Science; Web Development - A.S. - Online; name=onlineassociates; trim=left; cols=50}{endif}
{if: venue == "Online" AND typeofprogram == "Bachelors"; trim=left}{formmenu: default=; Audio Production - B.S. - Online; Computer Animation - B.S. - Online; Computer Science - B.S. - Online; Computer Science B.S. Completion with a Concentration in Artificial Intelligence - Online; Computer Science B.S. Completion with a Concentration in Mobile Development - Online; Creative Writing - B.F.A - Online; Cybersecurity Bachelor of Science Completion Program - Online; Digital Cinematography - B.S. - Online; Digital Marketing - B.S. - Online; Entertainment Business - B.S. - Online; Game Art - B.S. - Online; Game Business and Esports Bachelor of Science; Game Design - B.S. - Online; Game Development B.S. - Online; Graphic Design - B.S. - Online; Information Technology - B.S. - Online; Media Communications - B.S. - Online; Mobile Development - B.S. - Online; Music Business - B.S. - Online; Music Production - B.S. - Online; Sports Marketing and Media - B.S. - Online; Sportscasting - B.S. - Online; User Experience Bachelor of Science; Web Development - B.S. - Online; name=onlinebachelors; trim=left; cols=50}{endif}
{if: venue == "Online" AND typeofprogram == "Masters"; trim=left}{formmenu: default=; Business Intelligence - M.S. - Online; Computer Science M.S.; Digital Marketing - M.S. - Online; Entertainment Business - M.S. - Online; Entertainment Business (Sports) - M.S. - Online; Game Design - M.S. - Online; Innovation and Entrepreneurship - M.S. - Online; Instructional Design and Technology - M.S. - Online; Media Design - M.F.A. - Online; Mobile Gaming - M.S. - Online; New Media Journalism - M.A. - Online; Public Relations - M.A. - Online; name=onlinemasters; trim=left; cols=50}{endif}
{if: venue == "Online" AND typeofprogram == "UG Cert"; trim=left}{formmenu: default=; 3D Arts - Certificate - Online (7 mo Ext); Application Development Fundamentals - Certificate - Online (7 mo Ext); Audio Arts - Certificate - Online (7 mo Ext); Business - Certificate - Online (7 mo Ext); Computer Science - Certificate - Online (7 mo Ext); Creative Writing - Certificate - Online (7 mo Ext); Digital Marketing - Certificate - Online; Film and Video - Certificate - Online (7 mo Ext); Game Business and Esports Certificate; Game Design - Certificate - Online (7 mo Ext); Information Technology - Certificate - Online (7 mo Ext); Instructional Design and Technology - Certificate - Online; Intensive English Program - Certificate (Level 3) - Online; Intensive English Program - Certificate (Level 4) - Online; Marketing - Certificate - Online (7 mo Ext); Media Strategy - Certificate - Online (7 mo Ext); Sportscasting - Certificate - Online (7 mo Ext); User Experience Certificate; Visual Design - Certificate - Online (7 mo Ext); name=onlineugcert; trim=left; cols=50}{endif}

Program Code: {if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Audio Production - A.A.S. - Campus"}APRAS01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Cloud Technologies - A.S. - Campus"}CTEA01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Computer Animation - A.S. - Campus"}CANA01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Computer Science - A.S. - Campus"}COSA001E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Digital Arts and Design - A.A.S. - Campus"}DADAS01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Film - A.A.S. - Campus"}FLMAS01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Game Art - A.S. - Campus"}GARA01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Game Design - A.A.S. - Campus"}GDNAS01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Game Development - A.S. - Campus"}GDVA01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Graphic Design - A.A.S. - Campus"}GDSAS01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Media Communications - A.A.S. - Campus"}MCMAS01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Music Business - A.S. - Campus"}MUBA01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Music Production - A.A.S. - Campus"}MPRAS01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Recording Arts - A.A.S. - Campus"}RARAS01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Show Production - A.A.S. - Campus"}SPRAS01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Sportcasting - A.S. - Campus"}SCSA01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Associates" AND campusassociates == "Sports Marketing and Media - A.A.S. - Campus"}SMMAS01E-I{endif: trim=yes}

{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Cloud Technologies - B.S. - Campus"}CTEB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Computer Animation - B.S. - Campus"}CANB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Computer Animation - B.S. - Campus (ext)"}CANB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Computer Science - B.S. - Campus"}COSB001E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Creative Writing - B.F.A - Campus"}CWRB02E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Creative Writing for Entertainment - B.F.A. - Campus"}CWEB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Creative Writing for Entertainment - B.F.A. - Campus (ext)"}CWEB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Digital Arts and Design - B.S. - Campus"}DADB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Digital Arts and Design - B.S. - Campus (ext)"}DADB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Entertainment Business - B.S. - Campus"}ENBB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Entertainment Business - B.S. - Campus (ext)"}ENBB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Film - B.S. - Campus"}FLMB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Film - B.S. - Campus (ext)"}FLMB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Game Art - B.S. - Campus"}GARB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Game Art - B.S. - Campus (ext)"}GARB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Game Design - B.S. - Campus"}GDNB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Game Design - B.S. - Campus (ext)"}GDNB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Game Development - B.S. - Campus"}GDVB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Game Development - B.S. - Campus (ext)"}GDVB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Graphic Design - B.S. - Campus"}GDSB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Information Technology - B.S. - Campus"}ITEB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Media Communications - B.S. - Campus"}MCMB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Media Communications - B.S. - Campus (ext)"}MCMB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Mobile Development - B.S. - Campus"}MDVB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Music Business - B.S - Campus (ext)"}MUBB2E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Music Business - B.S. - Campus"}MUBB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Music Production - B.S. - Campus"}MPRB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Music Production - B.S. - Campus (ext)"}MPRB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Recording Arts - B.S. - Campus"}RARB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Recording Arts - B.S. - Campus (ext)"}RARB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Show Production - B.S. - Campus"}SPRB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Show Production - B.S. - Campus (ext)"}SPRB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Simulation and Visualization - B.S. - Campus"}SIMB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Software Development - B.S. - Campus"}SDVB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Software Development - B.S. - Campus (ext)"}SDVB02E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Sports Marketing and Media - B.S. - Campus"}SMMB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Sportscasting - B.S. - Campus"}SCSB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Sportscasting - B.S. - Campus (ext)"}SCSB01E-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Web Development - B.S. - Campus"}WDVB01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Bachelors" AND campusbachelors == "Web Development - B.S. - Campus (ext)"}WDVB02E-X{endif: trim=yes}

{if: venue == "Campus" AND typeofprogram == "Masters" AND campusmasters == "Entertainment Business - M.S. - Campus"}ENBM01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Masters" AND campusmasters == "Entertainment Business (Sports) - M.S. - Campus"}ENBMS01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Masters" AND campusmasters == "Film Production - M.F.A - Campus"}FLMM01E-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "Masters" AND campusmasters == "Game Design - M.S. - Campus"}GDNM01E-I{endif: trim=yes}

{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "3D Arts - Certificate - Campus (7 mo Ext)"}3DAC01E7-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Application Development Fundamentals - Certificate - Campus (7 mo Ext)"}ADFC01E7-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Audio Arts - Certificate - Campus (7 mo Ext) "}AARC01E7-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Business - Certificate - Campus (7 mo Ext)"}BUSC01E7-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Computer Science - Certificate - Campus (7 mo Ext)"}COSC01E7-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Creative Writing - Certificate - Campus (7 mo Ext)"}CWRC01E7-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Film and Video - Certificate - Campus (7 mo Ext)"}FLMC01E7-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Game Design - Certificate - Campus (7 mo Ext)"}GDNC01E7-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Information Technology - Certificate - Campus (7 mo Ext)"}ITEC01E7-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Intensive English Program - Certificate (Level 1) - Campus"}IEP001L1-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Intensive English Program - Certificate (Level 2) - Campus"}IEP001L2-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Intensive English Program - Certificate (Level 3) - Campus"}IEP001L3-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Intensive English Program - Certificate (Level 4) - Campus"}IEP001L4-I{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Marketing - Certificate - Campus (7 mo Ext)"}MKTC01E7-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Media Strategy - Certificate - Campus (7 mo Ext)"}MSTC01E7-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Sportscasting - Certificate - Campus (7 mo Ext)"}SCSC01E7-X{endif: trim=yes}
{if: venue == "Campus" AND typeofprogram == "UG Cert" AND campusugcert == "Visual Design - Certificate - Campus (7 mo Ext)"}VSDC01E7-X{endif: trim=yes}

{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Audio Production - A.A.S. - Online"}APRAS01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Computer Animation - A.S. - Online"}CANA01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Computer Science - A.S. - Online"}COSA001E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Creative Writing - A.S. - Online"}CWRA02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Digital Cinematography - A.A.S. - Online"}DCIAS01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Digital Marketing - A.A.S. - Online"}DMKAS01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Entertainment Business - A.S. - Online"}ENBA01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Game Art - A.S. - Online"}GARA01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Game Business and Esports Associate of Science"}GBEA01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Game Design - A.A.S. - Online"}GDNAS01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Game Development A.S. - Online"}GDVA01E-O {endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Graphic Design - A.A.S. - Online"}GDSAS01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Information Technology - A.S. - Online"}ITEA01E-O {endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Media Communications - A.A.S. - Online"}MCMAS01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Mobile Development - A.S. - Online"}MDVA01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Music Business - A.S. - Online"}MUBA01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Music Production - A.A.S. - Online"}MPRAS01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Sports Marketing and Media - A.A.S. - Online"}SMMAS01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Sportscasting - A.S. - Online"}SCSA01E-O {endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "User Experience Associate of Science"}UXPA01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Associates" AND onlineassociates == "Web Development - A.S. - Online"}WDVA01E-O{endif: trim=yes}

{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Audio Production - B.S. - Online"}APRB02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Computer Animation - B.S. - Online"}CANB02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Computer Science - B.S. - Online"}COSB001E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Computer Science B.S. Completion with a Concentration in Artificial Intelligence - Online"}CSBCPAI1-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Computer Science B.S. Completion with a Concentration in Mobile Development - Online"}CSBCPMD1-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Creative Writing - B.F.A - Online"}CWRB02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Cybersecurity Bachelor of Science Completion Program - Online"}CYBCP01E-O {endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Digital Cinematography - B.S. - Online"}DCIB02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Digital Marketing - B.S. - Online"}DMKB01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Entertainment Business - B.S. - Online"}ENBB02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Game Art - B.S. - Online"}GARB02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Game Business and Esports Bachelor of Science"}GBEB01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Game Design - B.S. - Online"}GDNB02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Game Development B.S. - Online"}GDVB01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Graphic Design - B.S. - Online"}GDSB02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Information Technology - B.S. - Online"}ITEB01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Media Communications - B.S. - Online"}MCMB02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Mobile Development - B.S. - Online"}MDVB03E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Music Business - B.S. - Online"}MUBB02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Music Production - B.S. - Online"}MPRB02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Sports Marketing and Media - B.S. - Online"}SMMB02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Sportscasting - B.S. - Online"}SCSB01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "User Experience Bachelor of Science"}UXPB01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Bachelors" AND onlinebachelors == "Web Development - B.S. - Online"}WDVB02E-O{endif: trim=yes}

{if: venue == "Online" AND typeofprogram == "Masters" AND onlinemasters == "Business Intelligence - M.S. - Online"}BIMS001-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Masters" AND onlinemasters == "Computer Science M.S."}COSM01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Masters" AND onlinemasters == "Digital Marketing - M.S. - Online"}DMKM01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Masters" AND onlinemasters == "Entertainment Business - M.S. - Online"}ENBM01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Masters" AND onlinemasters == "Entertainment Business (Sports) - M.S. - Online"}ENBMS01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Masters" AND onlinemasters == "Game Design - M.S. - Online"}GDNM02E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Masters" AND onlinemasters == "Innovation and Entrepreneurship - M.S. - Online"}IEMS001-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Masters" AND onlinemasters == "Instructional Design and Technology - M.S. - Online"}IDTM001-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Masters" AND onlinemasters == "Media Design - M.F.A. - Online"}MDMF003-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Masters" AND onlinemasters == "Mobile Gaming - M.S. - Online"}MGM001-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Masters" AND onlinemasters == "New Media Journalism - M.A. - Online"}NMJM002-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "Masters" AND onlinemasters == "Public Relations - M.A. - Online"}PRMA002-O{endif: trim=yes}

{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "3D Arts - Certificate - Online (7 mo Ext)"}3DAC01E7-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Application Development Fundamentals - Certificate - Online (7 mo Ext)"}ADFC01E7-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Audio Arts - Certificate - Online (7 mo Ext)"}AARC01E7-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Business - Certificate - Online (7 mo Ext)"}BUSC01E7-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Computer Science - Certificate - Online (7 mo Ext)"}COSC01E7-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Creative Writing - Certificate - Online (7 mo Ext)"}CWRC01E7-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Digital Marketing - Certificate - Online"}DMKC01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Film and Video - Certificate - Online (7 mo Ext)"}FLMC01E7-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Game Business and Esports Certificate"}GBEC01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Game Design - Certificate - Online (7 mo Ext)"}GDNC01E7-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Information Technology - Certificate - Online (7 mo Ext)"}ITEC01E7-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Instructional Design and Technology - Certificate - Online"}IDT002-CTO{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Intensive English Program - Certificate (Level 3) - Online"}IEP001L3-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Intensive English Program - Certificate (Level 4) - Online"}IEP001L4-OÂ {endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Marketing - Certificate - Online (7 mo Ext)"}MKTC01E7-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Media Strategy - Certificate - Online (7 mo Ext)"}MSTC01E7-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Sportscasting - Certificate - Online (7 mo Ext)"}SCSC01E7-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "User Experience Certificate"}UXPC01E-O{endif: trim=yes}
{if: venue == "Online" AND typeofprogram == "UG Cert" AND onlineugcert == "Visual Design - Certificate - Online (7 mo Ext)"}VSDC01E7-O{endif: trim=left}

@Brad_Hedinger - Can you post the entire list in plain text please? I think this would make most sense as a list of lists.

Glad to do so! All this lives in an Excel doc at the moment. I could have easily linked the snippet to reference that doc, but our tenant does not allow this feature. Google sheets is out of the question as well due to compliance restrictions. Hope this helps!
Venue:
Campus
Online

Program Type:
Associates
Bachelors
Masters
UG Cert

Program Name:
Audio Production - A.A.S. - Campus
Cloud Technologies - A.S. - Campus
Computer Animation - A.S. - Campus
Computer Science - A.S. - Campus
Digital Arts and Design - A.A.S. - Campus
Film - A.A.S. - Campus
Game Art - A.S. - Campus
Game Design - A.A.S. - Campus
Game Development - A.S. - Campus
Graphic Design - A.A.S. - Campus
Media Communications - A.A.S. - Campus
Music Business - A.S. - Campus
Music Production - A.A.S. - Campus
Recording Arts - A.A.S. - Campus
Show Production - A.A.S. - Campus
Sportcasting - A.S. - Campus
Sports Marketing and Media - A.A.S. - Campus
Cloud Technologies - B.S. - Campus
Computer Animation - B.S. - Campus
Computer Animation - B.S. - Campus (ext)
Computer Science - B.S. - Campus
Creative Writing - B.F.A - Campus
Creative Writing for Entertainment - B.F.A. - Campus
Creative Writing for Entertainment - B.F.A. - Campus (ext)
Digital Arts and Design - B.S. - Campus
Digital Arts and Design - B.S. - Campus (ext)
Entertainment Business - B.S. - Campus
Entertainment Business - B.S. - Campus (ext)
Film - B.S. - Campus
Film - B.S. - Campus (ext)
Game Art - B.S. - Campus
Game Art - B.S. - Campus (ext)
Game Design - B.S. - Campus
Game Design - B.S. - Campus (ext)
Game Development - B.S. - Campus
Game Development - B.S. - Campus (ext)
Graphic Design - B.S. - Campus
Information Technology - B.S. - Campus
Media Communications - B.S. - Campus
Media Communications - B.S. - Campus (ext)
Mobile Development - B.S. - Campus
Music Business - B.S - Campus (ext)
Music Business - B.S. - Campus
Music Production - B.S. - Campus
Music Production - B.S. - Campus (ext)
Recording Arts - B.S. - Campus
Recording Arts - B.S. - Campus (ext)
Show Production - B.S. - Campus
Show Production - B.S. - Campus (ext)
Simulation and Visualization - B.S. - Campus
Software Development - B.S. - Campus
Software Development - B.S. - Campus (ext)
Sports Marketing and Media - B.S. - Campus
Sportscasting - B.S. - Campus
Sportscasting - B.S. - Campus (ext)
Web Development - B.S. - Campus
Web Development - B.S. - Campus (ext)
Entertainment Business - M.S. - Campus
Entertainment Business (Sports) - M.S. - Campus
Film Production - M.F.A - Campus
Game Design - M.S. - Campus
3D Arts - Certificate - Campus (7 mo Ext)
Application Development Fundamentals - Certificate - Campus (7 mo Ext)
Audio Arts - Certificate - Campus (7 mo Ext)
Business - Certificate - Campus (7 mo Ext)
Computer Science - Certificate - Campus (7 mo Ext)
Creative Writing - Certificate - Campus (7 mo Ext)
Film and Video - Certificate - Campus (7 mo Ext)
Game Design - Certificate - Campus (7 mo Ext)
Information Technology - Certificate - Campus (7 mo Ext)
Intensive English Program - Certificate (Level 1) - Campus
Intensive English Program - Certificate (Level 2) - Campus
Intensive English Program - Certificate (Level 3) - Campus
Intensive English Program - Certificate (Level 4) - Campus
Marketing - Certificate - Campus (7 mo Ext)
Media Strategy - Certificate - Campus (7 mo Ext)
Sportscasting - Certificate - Campus (7 mo Ext)
Visual Design - Certificate - Campus (7 mo Ext)
Audio Production - A.A.S. - Online
Computer Animation - A.S. - Online
Computer Science - A.S. - Online
Creative Writing - A.S. - Online
Digital Cinematography - A.A.S. - Online
Digital Marketing - A.A.S. - Online
Entertainment Business - A.S. - Online
Game Art - A.S. - Online
Game Business and Esports Associate of Science - Online
Game Design - A.A.S. - Online
Game Development A.S. - Online
Graphic Design - A.A.S. - Online
Information Technology - A.S. - Online
Media Communications - A.A.S. - Online
Mobile Development - A.S. - Online
Music Business - A.S. - Online
Music Production - A.A.S. - Online
Sports Marketing and Media - A.A.S. - Online
Sportscasting - A.S. - Online
User Experience Associate of Science - Online
Web Development - A.S. - Online
Audio Production - B.S. - Online
Computer Animation - B.S. - Online
Computer Science - B.S. - Online
Computer Science B.S. Completion with a Concentration in Artificial Intelligence - Online
Computer Science B.S. Completion with a Concentration in Mobile Development - Online
Creative Writing - B.F.A - Online
Cybersecurity Bachelor of Science Completion Program - Online
Digital Cinematography - B.S. - Online
Digital Marketing - B.S. - Online
Entertainment Business - B.S. - Online
Game Art - B.S. - Online
Game Business and Esports Bachelor of Science - Online
Game Design - B.S. - Online
Game Development B.S. - Online
Graphic Design - B.S. - Online
Information Technology - B.S. - Online
Media Communications - B.S. - Online
Mobile Development - B.S. - Online
Music Business - B.S. - Online
Music Production - B.S. - Online
Sports Marketing and Media - B.S. - Online
Sportscasting - B.S. - Online
User Experience Bachelor of Science
Web Development - B.S. - Online
Business Intelligence - M.S. - Online
Computer Science M.S.
Digital Marketing - M.S. - Online
Entertainment Business - M.S. - Online
Entertainment Business (Sports) - M.S. - Online
Game Design - M.S. - Online
Innovation and Entrepreneurship - M.S. - Online
Instructional Design and Technology - M.S. - Online
Media Design - M.F.A. - Online
Mobile Gaming - M.S. - Online
New Media Journalism - M.A. - Online
Public Relations - M.A. - Online
3D Arts - Certificate - Online (7 mo Ext)
Application Development Fundamentals - Certificate - Online (7 mo Ext)
Audio Arts - Certificate - Online (7 mo Ext)
Business - Certificate - Online (7 mo Ext)
Computer Science - Certificate - Online (7 mo Ext)
Creative Writing - Certificate - Online (7 mo Ext)
Digital Marketing - Certificate - Online
Film and Video - Certificate - Online (7 mo Ext)
Game Business and Esports Certificate - Online
Game Design - Certificate - Online (7 mo Ext)
Information Technology - Certificate - Online (7 mo Ext)
Instructional Design and Technology - Certificate - Online
Intensive English Program - Certificate (Level 3) - Online
Intensive English Program - Certificate (Level 4) - Online
Marketing - Certificate - Online (7 mo Ext)
Media Strategy - Certificate - Online (7 mo Ext)
Sportscasting - Certificate - Online (7 mo Ext)
User Experience Certificate - Online
Visual Design - Certificate - Online (7 mo Ext)

Program Code:
APRAS01E-I
CTEA01E-I
CANA01E-I
COSA001E-I
DADAS01E-I
FLMAS01E-I
GARA01E-I
GDNAS01E-I
GDVA01E-I
GDSAS01E-I
MCMAS01E-I
MUBA01E-I
MPRAS01E-I
RARAS01E-I
SPRAS01E-I
SCSA01E-I
SMMAS01E-I
CTEB01E-I
CANB01E-I
CANB02E-X
COSB001E-I
CWRB02E-I
CWEB01E-I
CWEB02E-X
DADB01E-I
DADB02E-X
ENBB01E-I
ENBB02E-X
FLMB01E-I
FLMB02E-X
GARB01E-I
GARB02E-X
GDNB01E-I
GDNB02E-X
GDVB01E-I
GDVB02E-X
GDSB01E-I
ITEB01E-I
MCMB01E-I
MCMB02E-X
MDVB01E-I
MUBB2E-X
MUBB01E-I
MPRB01E-I
MPRB02E-X
RARB01E-I
RARB02E-X
SPRB01E-I
SPRB02E-X
SIMB01E-I
SDVB01E-I
SDVB02E-X
SMMB01E-I
SCSB01E-I
SCSB01E-X
WDVB01E-I
WDVB02E-X
ENBM01E-I
ENBMS01E-I
FLMM01E-I
GDNM01E-I
3DAC01E7-X
ADFC01E7-X
AARC01E7-X
BUSC01E7-X
COSC01E7-X
CWRC01E7-X
FLMC01E7-X
GDNC01E7-X
ITEC01E7-X
IEP001L1-I
IEP001L2-I
IEP001L3-I
IEP001L4-I
MKTC01E7-X
MSTC01E7-X
SCSC01E7-X
VSDC01E7-X
APRAS01E-O
CANA01E-O
COSA001E-O
CWRA02E-O
DCIAS01E-O
DMKAS01E-O
ENBA01E-O
GARA01E-O
GBEA01E-O
GDNAS01E-O
GDVA01E-O
GDSAS01E-O
ITEA01E-O
MCMAS01E-O
MDVA01E-O
MUBA01E-O
MPRAS01E-O
SMMAS01E-O
SCSA01E-O
UXPA01E-O
WDVA01E-O
APRB02E-O
CANB02E-O
COSB001E-O
CSBCPAI1-O
CSBCPMD1-O
CWRB02E-O
CYBCP01E-O
DCIB02E-O
DMKB01E-O
ENBB02E-O
GARB02E-O
GBEB01E-O
GDNB02E-O
GDVB01E-O
GDSB02E-O
ITEB01E-O
MCMB02E-O
MDVB03E-O
MUBB02E-O
MPRB02E-O
SMMB02E-O
SCSB01E-O
UXPB01E-O
WDVB02E-O
BIMS001-O
COSM01E-O
DMKM01E-O
ENBM01E-O
ENBMS01E-O
GDNM02E-O
IEMS001-O
IDTM001-O
MDMF003-O
MGM001-O
NMJM002-O
PRMA002-O
3DAC01E7-O
ADFC01E7-O
AARC01E7-O
BUSC01E7-O
COSC01E7-O
CWRC01E7-O
DMKC01E-O
FLMC01E7-O
GBEC01E-O
GDNC01E7-O
ITEC01E7-O
IDT002-CTO
IEP001L3-O
IEP001L4-O
MKTC01E7-O
MSTC01E7-O
SCSC01E7-O
UXPC01E-O
VSDC01E7-O

This is a perfect use case for a new feature that's about to lunch soon :wink:

5 Likes
2 Likes

Hey @Brad_Hedinger, I hope you and the students and faculty are safe.
Now that we launched Data Blaze... Do you have the above in a spreadsheet? I'll create an example of how this can be implemented easily in Data Blaze

Thanks Dan for the well wishes! It’s a mess down here but we’re always grateful it wasn’t worse.

I have not dug into Data Blaze fully yet - only minor beta testing. Would love to see what you are thinking!

So... I created a space that looks like this: Text Blaze Dashboard

Then I would recommend creating a simple snippet like the one below. Searching in the read from table menu is pretty easy.

{dbselect: SELECT `Program Name`, `Program Type`, Venue, `Program Code` FROM Brad; space=2U12drbK8KTzyCfoiNbQPI; menu=yes}
Program name: {=`program name`} Program type: {=`program type`} Venue: {=venue} Code: {=`program code`}

But you can create a more complex version with drop-downs that are used as filters when reading from the table.

Program type: {formmenu: default=Associates; Bachelors; Masters; UG Cert; name=selected_type}
Venue: {formmenu: default=Campus; Online; name=selected_venue}
Program name: {dbselect: SELECT `Program Name`, `Program Type`, Venue, `Program Code` FROM Brad WHERE `Program Type` == @selected_type AND Venue == @selected_venue; space=2U12drbK8KTzyCfoiNbQPI; menu=yes} {=`program name`} Code: {=`program code`}

1 Like