** Reupload due to Music Copyright Claims***
What is the best way to create a dropdown list in your AppSheet apps? When should you use an Enum, and when should you use a Ref?
This video will show you how these different methods differ and how they may be the same.
Get the AppSheet Best Practices eBook:
https://bit.ly/4bh3JSp
(Thanks for your suppport. 🙏)
Related Videos:
AppSheet Best Practices you should know by now
https://youtu.be/nuBAOEPIMo8?si=u4pUr88-f7rNGFEw
Creating Dynamic Dependent Dropdown Lists
https://youtu.be/fFxGRbktA0U?si=2ghrlTYSDDPPfKVh
===========================
Video Chapters:
00:00 Intro to Dropdown list boxes in AppSheet
00:59 Method 1: Adding Enum or Enum List option values
02:02 Allowing other values for Enum or Enum List columns
02:33 Auto-complete other vakye for Enum or Enum List columns
03:16 Get Enum value options from another sheet or table
04:43 Applying the same value options setup for Enum List
05:33 Method 2: Using Ref columns for dropdown lists
06:50 Save the Label value of a Ref column to the underlying Google Sheet
07:07 Using Dereference in column app formula to get Ref's Label value
08:53 Ref column's "Is a part of" toggle settings
09:51 Method 3: Using Enum-Ref and Enum List-Ref combinations to create dropdown lists
12:20 Enum-Ref + Valid If vs Text + Valid If combinations
12:53 Method 4: Using Text + Valid If combination to create dropdowns
13:37 Method 5: Use Text + Suggested Values combination to create dropdowns
15:09 What will be the next level of dropdown boxes?
≈================
#appsheet #fullofsheets #dropdownlist #buildingwithappsheet #appsheetforbeginners
#appsheetrefdropdown