This video explains how DeReferencing works with Ref and Enum-Ref type columns and how it differs for each of them.
DeReferencing allows users to select a value from a dropdown, and based on the selection, AppSheet automatically fills in other fileds in the form using values from another column of the reference table.
This video is a direct response to a comment asked by @danielpaes6457 in our video on Dependent Dropdowns (https://youtu.be/fFxGRbktA0U?si=Z2WtIWjH4Nx-1wai).
Building from this app, watch this next:
https://youtu.be/Eo20CQnT-Dw?si=27OskLFpJbMSaNSu
____________________________
Recommended Related Vidoes:
5 Best Ways to Create Dropdowns
https://youtu.be/KtTEbu9hYmE
AppSheet Best Practices
https://youtu.be/nuBAOEPIMo8?si=zD8ot3mP8A0vx3W8
================================
Video Chapters:
00:00 Background
00:23 Member Shoutout
01:31 Google Sheet table structure
02:25 Setting up the references
03:41 Ref vs Enum-Ref?
05:01 Explaining what we want to do
05:34 What is DeReferencing?
07:00 Implementing the Dereference
09:05 Test the Finished Product
09:58 Another Variation / Permutation
11:05 What's our next video?
================================
#appsheet #dereference #appsheetrefdropdown #appsheetdereferencing #buildingwithappsheet #tutorial #howto #dropdowns