Creating specific values for a dropdown list | AppSheet Explained

Hamlet Asked: - How do I create a list of specific values for a dropdown? The process for accomplishing what you want is not a straight-forward as you might be thinking, there's a few steps involved. 1) Create a space to hold the individual values you want to use - You need to have the values first, in order to use them in a dropdown 2) Create a derivative list of all the values 3) Integrate that list into your dependent dropdown -----| Table of Contents |----- 0:00 - Intro 0:10 - 1st Question 2:09 - Create a column to hold the value 3:40 - Why to use physical columns vs. virtual columns 5:00 - Label column CONCATENATE() formula 7:01 - Derivative list on Location table 9:40 - Using the list in the dashboard 10:56 - Valid If formula for dashboard control 12:21 - Process Overview ----------------------------------------------------------------------------------------------------------------------- ///////////////////////////////////////////////////////////////////////////// /// SUPPORT THE CHANNEL ///////////////////////////////////////////////////////////////////////////// // // Schedule a 1-on-1 // https://calendly.com/multitechvisions/1-on-1 // // Patreon // https://www.Patreon.com/MultiTech // // 15% off @ https://www.AppSheetTraining.com // Code: MULTITECH-15 // // Tip Jar // https://www.MultiTechVisions.com/Tips // // ///////////////////////////////////////////////////////////////////////// For more information about MultiTech Visions, visit https://www.MultiTechVisions.com #CitizenDeveloper #AppSheet #Patreon