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

[Eric_D_Mason]

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

[SkrOYC]

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

[Eric_D_Mason]

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.

[Eric_D_Mason]

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

This is the ece form

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.

[wheaties]

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!

[Eric_D_Mason]

Hi Wheaties,

Thank you.

I will try this workaround and revert.

Regards

[wheaties]

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