Mastering AppSheet field visibility with Context()
ฝัง
- เผยแพร่เมื่อ 16 มิ.ย. 2024
- To have more control on showing or hiding columns/fields in your AppSheet app, you need to know how to control their visibility depending on the current view or the type of view (form, deck, table, card, etc).
In this video, we will learn the different Context() options available, and how to use them to control how columns or fields are shown in your app based on the given context. With this knowledge,
we can master field visibility in our AppSheet apps.
As a bonus, we will also show a "Power Tip" that allows you to have different columns shown on your Inline Table views, even if they are based on the same data table source.
Recommended related video:
Building Strong Connections with Many-to-Many in AppSheet
• Building Strong Connec...
_________________________________________
Do you need coaching and/or consultation with the app that you are building?
Book a call with me. Link found in main channel
=========================
Video Chapters
00:00 The challenge in having many columns/fields
00:39 Different Show-if options
00:53 Where Context() expressions can help
01:08 The different Context() options
01:21 Context("View")
02:05 Context("ViewType")
02:39 Context("Host")
03:24 Context("Table")
03:52 Review app from our last video
05:00 Our problem with Inline tables last time
05:47 Bonus! Having different Inline Table columns for different views
11:48 Show a column/field on specific views only
14:44 Show a column/field on Detail type views only
15:47 Where else can you use Context() expressions
17:08 What's next in the series
17:22 A small favor, please 🙏
=========================
#appsheet #tutorial #context #fullofsheets - แนวปฏิบัติและการใช้ชีวิต
Amazing 😊 work around for the views 👍 I appreciate the way you demo and explain the function. Thank you so much 😊
Thank you, too, my friend.
I'm glad you like my teaching style. 🤗
Another great tutorial! Thank-you, especially for the workaround regarding the inline view at the centre of a many-many relationship. Being new to AppSheet, it's exactly the problem I have been trying to nut out. I found that other, more obvious solutions aren't available (like being able to identify the parent view to contextually hide a column of the inline view; or being able to manually define what inline view a parent view uses). I am learning a lot from your tutorials.
Glad it was helpful!
@@FullOfSheets I have been modifying a template app and have noticed that changing column or table names causes problems as the system doesn't seem to propagate the changes throughout expressions etc and perhaps seems to just delete some things that now break the system. What is the most efficient process to use to make name changes to columns and tables without losing functionality/messing things up?
Haha. That's just the way appsheet works.
If you are simply changing column names, then you can just edit the column name in the app editor and in your sheet.
But if you moved column orders, or added/deleted columns in the sheets then you will have to regenerate the table schema.
Take note though, that if you used the old column names in one or more expressions across tables and views, then you will have to manuall update all of those to the new name.
If you are changing the Sheet/Tab name, then you will have to let the app break first, so you can go back to the Table settings and select the new sheet name on the Storage section of the Table's settings.
@@FullOfSheets Thanks so much! I was kind of hoping there was some easier way. Thank-you for saving me from more searching
No problem, mate!
I watched all your videos and I have learned a lot from you, but I'm still not able to do what I need. I'm trying to have the latest input date in one cell in one table automatically added to another cell in another table. I have a google sheet file with two tables one is called "patients Info" and the second one is called "dates". in the "dates" table the patients are schedule appointments weekly or every 10 days by inputing the next appointment date in a cell titled "next appointment date" after each visit. In the "patient info" table there is also a cell titled "next appointment date". I want the cell in the "patient info" table to automatically get the latest "next appointment date" from the input in the "dates" table. Can you please help me with this or do you have a video that will explain how to do something similar? I watched all the videos in this channel and even though I have learn a lot and I have implemented some of your suggestions I'm still not able to figure out how to do what I explained. Salamat nang maaga para sa iyong tulong.
Sure. I'm just outdoors right now. I'll give you some pointers when I get to a steady place. Thanks for the sub. Cheers!
Hii,, how to allow duplicate value in key column ?
You can't. Key columns should always be unique because it allow to identify sa specific column.
If you have duplicate appsheet starts to malfunction.
You're right! 💯