Boost Your AppSheet Project Efficiency with Dropdown DeReferencing and Auto Fill

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 ( • Say Goodbye to Complex... .
Building from this app, watch this next:
• AppSheet Batch Update ...
____________________________
Recommended Related Vidoes:
5 Best Ways to Create Dropdowns
• Top 5 Ways to Make Dro...
AppSheet Best Practices
• Level Up Your App Deve...
================================
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

[@EricaDyson]

Much better than LOOKUP. Thanks

[@FullOfSheets]

Indeed. But only works if there is a Ref or Enum-Ref column you can use to dereference, though.

[@temyraverdana6421]

Thanks a lot, an amazing lesson

[@FullOfSheets]

You are welcome! I'm happy you found it great! 😊

[@andyburnett4918]

Thanks for creating such a clear explanation. I really appreciate you taking the time to share your knowledge.

[@FullOfSheets]

My pleasure! And i appreciate you taking the time to thank me in the comments.

[@danielpaes6457]

thank u, has aswered!!

[@FullOfSheets]

Welcome. Thanks you, also.

[@AndersonKuba]

Awesome

[@FullOfSheets]

Thank you 🤗

[@joyceilao8030]

Is there a way to edit action for “new” button in ref list?

[@FullOfSheets]

If you are referring to the system-generated Add button, then ylu are pretty much limited to editing the Display Text, the icon, Display mode, the behavior, and other settings.
If you want to edit the actual action it does, then simply duplicate the system-generated action, then Hide the original action.
On the newly created icon, you can pretty much change most settings.

[@sajinj2457]

How can i contact you?

[@FullOfSheets]

Hi,
Please see my channel description. Thanks.