Good day Appsheet Community.
I am looking for a way to filter data on a slice using a column value from the Parent table.
Parent table Name = Fleet_Information
The key of this table = Registration
Filter Column - Fleet Status = Active
Child table should only show data where the fleet status is = Active
Child Table name = Fleet Service and Compliance
Hope someone can help.
I know this is probably something with a easy solution but, I can’t seem to figure it out.
@Louwrens
Do you want to do this in the inline view of the child records in Parent record’s Detail View?
Nope,
I want to create a slice only showing the active fleet.
Simply your REF_ROWS() expression should point out to that slice rather than the table itself, if that’s what you are asking.
I need to show all the columns in the Fleet Service and Compliance (Child Table) if the Fleet Status = Active in Fleet_Information (Parent Table).
As I said its probably something basic but I seem to not be able to figure it out.
You should be able to do that with the deref formula like [RefColumnName].[Fleet Status]=“Active”