Appsheet Episode 87: How to Create User-Specific Dropdown Options in AppSheet Using Expressions
ฝัง
- เผยแพร่เมื่อ 18 ก.ย. 2024
- Welcome to my AppSheet tutorial where i delve into creating dynamic dropdown options that are filtered based on the logged-in user's email. This step-by-step guide will show you how to use the powerful SELECT expression to ensure advisors can only select clubs associated with their email in your AppSheet applications. Perfect for ensuring data integrity and enhancing user experience, this method can be applied to various use cases in your custom business or educational apps.
What You Will Learn:
An introduction to AppSheet expressions.
-How to use the SELECT function to filter dropdown options.
-Configuring a "Valid If" condition for a REF column in your "Report" form.
-Testing the setup with different user emails to see the dynamic dropdown in action.
Who Should Watch:
AppSheet beginners looking to understand expressions.
Intermediate users seeking to implement user-specific functionalities.
Developers and creators of custom AppSheet applications for businesses or education.
Join this channel to get access to perks:
/ @aris_azhar
Another good one, please do one on updating a table based on a value of a record inserted in another table, one to one relationship
Interesting! do you have some info as to what you want to achieve? some detail would help skew my focus. I will do once detail is there. Thanks dear brother
@@aris_azhar Glad you have finally seen this, I have two tables. A master data form with Farmer number, name and location. A second table with inspection checklist criteria for form, which uses a valid if to pull farmer details from master table. Inspection checklist table contains the fields for Farmer number, name ,then inspection criteria columns. Once a farmer is inspection is saved, I would like to update the matching record as "Inspected" on the master data, this is because a farmer needs to be inspected only once. The matching fields between this two tables is farmer number, which should also be unique. I hope I made sense.
Bosku, Subscriber baru here.
Apa ada tutorial untuk button dengan lebih dari satu pilihan? contoh di button itu kita memilih lebih dari 1 pilihan.
Por favor, gostaria de pedir ajuda para um aplicativo que criei de agendamento para minha clínica. Estou tendo dificuldade em uma função ENUM (DROPDOWN). Gostaria que o usuário clicasse na opção "anamnese", por exemplo, e essa opção abrisse um formulário de entrevista, mas não estou conseguindo. Você tem alguma sugestão? Muito obrigado pela atenção e pelos seus vídeos!
Hi Aris, good day. I learned a lot from your videos. Big thanks.
Would like to seek a little help if this is possible.
I have 4 tables in appsheet, all of them have a date completed column. I want all the the date completed columns to be displayed in 1 calendar view. Hope you'll notice this. Thank you!
Hello there! This is a very interesting request. Mind sharing some info on the 4 tables as to what it contains? perhaps we can work out something
@@aris_azharhi aris. Thank you for noticing .
the tables are
Customer request
Trimming of vegetation report
Work orders
Meter Inspection report
All of these tables have date completed. If possible it would be viewed in 1 calendar view.
Thank you
Hello sir make a video on how to Calculate work days example. If the work hours is 8AM to 5PM, after the user log out at 5PM it will Automatically Calculate the day as "1" day. And also make for Absents (0) and Half Days (0.5)
Please, could you teach me how to create a Saas-type application, where my potential client will pay a monthly fee for my application.
Can you show us please how to copy data for each month according to its statues
For example I chose date and year
Year 2024
Month 2
Statues pending
When we move to month 3 can we copy the data from month 2 to month 3 automatically ? And so on
Please your help 🙈