Boost Your AppSheet Project Efficiency with Dropdown DeReferencing and Auto Fill

[@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.

[@krutoikulak-kingofthegulag5653]

Fantastic! You have earned yourself a new subscriber. This was one of the best and most comprehensive explanations I've seen. Thank you!

[@FullOfSheets]

Awesome, thank you! Welcome aboard!

[@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.

[@415_muhammadmukhlish7]

Awesome, thank u so much sir for the great explanation, i just wondering what if the value of on the reference table is changed is that value will automatically changing the value on the main table too? like cascade on relational database? thank you

[@FullOfSheets]

What did you mean by this? The only thing linking the 2 is the key of the main table also present in the related table. If you change it in the related table, then it would break the original link. Which changes in the related table are you thinking to change that should also change in the main table?

[@temyraverdana6421]

Thanks a lot, an amazing lesson

[@FullOfSheets]

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

[@dvdsierralta]

Hello and thanks for the videos. I have a patient record, the key is the ID (DNI) and as a label I have a name column. In another appointment table I refer to the ID and search by name when generating a new record. So far so good. Users also ask me to be able to search by ID in the same appointment form. Is this possible? Thanks

[@FullOfSheets]

You mean, in the appointment table, there is a dropdown which is a Ref type column pointing to #Patient# table's [DNI] column? Basically in the dropdown, you search for the [Name] which is the label for t #Patients#, right? Is what you want also to be able to type in the ID in that same dropdown instead of the label?

[@danielpaes6457]

thank u, has aswered!!

[@FullOfSheets]

Welcome. Thanks you, also.

[@MrKundu04]

i need your help to correlate the last stock of the provious day equal to opening stock for next day morning Reply

[@FullOfSheets]

What is the name of the columns of the prev day and new day stock? And what is the name of the date column?

[@ijb-unknown]

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.

[@AndersonKuba]

Awesome

[@FullOfSheets]

Thank you 🤗

[@sajinj2457]

How can i contact you?

[@FullOfSheets]

Hi, Please see my channel description. Thanks.