I have a Students1 table. From that table, I created several slices. Every student has an advisor, and each advisor has their own slice.
I noticed that the detail views for each slice seemed to be different. So instead of trying to manage them independently, I changed the Row Selection Event Action from Auto to “Students1 detail view” thinking advisors could click on their student, and see the same detail view they’d see in the Students1 table.
However, it seems that clicking on a row always takes the user to the detail view of our very first student, instead of the student that was clicked on.
Is this a bug? And if not, is there a way to change the event action so that clicking on a record in the slice takes the user to the detail view of that particular record?
I tried to create a LINKTOROW expression, but I must have done something wrong. Now when clicking on a student in a slice, it redirects to the Students view (but not a particular student). Here’s the action:
It’s still not working for me. I must have confused myself somewhere along the way.
I tried using LINKTOROW([@lfccadulted.com email], Students), and that still takes me to the Students view, and not a particular row.
Is that how the expression should look? My thinking is the first element in the () tells AppSheet to get the value from [@lfccadulted.com email] in the row the user clicks on, and then the second element tells AppSheet to go to the record in the Students view with a key that matches the email value in the current row. But no dice.
I guess maybe I need to signify I want to use the column value of the row clicked on? At first, I thought maybe I needed [_THISROW] to do that. Is there some other way to do that?
Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…
Bear in mind that, no one in the community has the ability to foresee the future nor we have the magic sphere to see what you have built, your sheet structure, your table schema etc. Provided you are asking something technical, try to support the question with 1 or 2 screenshots.
It would be nice to have the whole table schema and the name of your slices.
Also, you need a way to identify or relate each slice to each student
There are 50 columns in the Students1 table, which feeds the Students view. I can post them all if that would be helpful. Just let me know. Here are the first few columns, including the key:
The slices, and the corresponding views, should all be identical. The only difference is that each slice is filtered so that only students with the appropriate value in the [Advisor] column are shown in that slice.
I’m not sure what you mean when you say I need a way to identify or relate each slice to each student. Students are included in a particular slice, or not, based on their assigned advisor.
I think I understand the LINKTOROW expression Steve shared. I just don’t know how to write the row-key expression so that AppSheet checks the [@lfccadulted.com email] column of the row the user clicks. I thought using [_THISROW].[@lfccadulted.com email] would let me specify I want to use the value of the row being clicked on, but I guess that’s not the case. If not that, I assume there’s a standard [_CLICKEDROW] expression or something similar, but I can’t find anything like that.
