How can I show or hide an inline view based on the input value of another field?

AppSheet AppSheet Q&A
,
1

I am working on an app that should display a subform based on the selection of a prior field value. Please see the example below:

Table: sch_level

emis_id ece primary junior senior alp abe tvet dcare other
c67f4177 TRUE TRUE FALSE FALSE FALSE FALSE FALSE TRUE
9ebc2d2f TRUE TRUE TRUE TRUE FALSE FALSE FALSE TRUE
004A TRUE TRUE TRUE FALSE TRUE TRUE TRUE FALSE
3ed386ae TRUE TRUE TRUE TRUE FALSE FALSE FALSE TRUE
72871f2b FALSE FALSE TRUE TRUE TRUE FALSE FALSE FALSE

Continual Education
fb595ca8 TRUE TRUE TRUE TRUE FALSE FALSE FALSE TRUE

I want the following table/view to be displayed when ece is TRUE. This will allow the user to enter the data in the ece table as seen below. If ece is not true, this should not be shown. Am I doing this the right way? Your suggestions and support are appreciated.

emis_id tot_stu_male tot_stu_female tot_teacher_male tot_teacher_female teach_one_grade_male teach_one_grade_female

num_teacher_needed
004A 5 6 5 7 2 1 4
2

Conditionally show or hide a column value (Show_If) - AppSheet Help

1 Like
3

I have done some research on the link shared prior to posting this query. I think this is like a skip logic that I want to be applied among the child tables. When a school has Early Childhood Education(ece), the entry form or table for ece should be displayed. The entry form/table to be displayed depends on the level of the school selected.

4

This is the school-level form. When Y is selected, then the detail form for ece should be displayed.

Eric_D_Mason_0-1658253860913.png
Eric_D_Mason_0-1658253860913.png402Ă—462 18.5 KB

This is the ece form

Eric_D_Mason_1-1658253932915.png
Eric_D_Mason_1-1658253932915.png976Ă—412 9.4 KB

Has anyone ever had such a situation before? Your ideas will be helpful. Do I need to restructure? I want the users to have access to the relevant forms based on the prior selection as explained.

5

Hi Eric, I believe you can accomplish this through a table slice of the ece table and having a key that points to that specific user in that table. Then, in the Slice>>Row Filter Condition, you could put a condition that limits the rows to that user.

In my own app, I captured their email beforehand and saved it in a “Users” table with the User Email column. Then used [User Email] = USEREMAIL() as the condition for the slice - this shows the rows that were connected to the current email they were logged into, it works perfectly!

Now in your case where the Yes/No condition is added and you have your emis_id as the key, your Row Filter Condition formula would look something like this: AND([User Email] = USEREMAIL(), [ece] = TRUE). The [User Email] piece will need to be substituted with whatever data you decide to connect the emis_id key to the user that is logged in. I would recommend making a “Profiles” table where each user has a unique profile based on their email and have possible roles (ie. admin, teacher, parent, student, etc.) - this will save you lots of trouble in the long run if you want to manage what content they can and cannot see through formulas. Hope this helps!

6

Hi Wheaties,

Thank you.

I will try this workaround and revert.

Regards

7

Sounds good buddy, feel free to reach back out if that doesn’t work. Happy to help further! Goodluck!