Slice Filtering

AppSheet AppSheet Q&A
, ,
1

Hi All,

2 Table: Outcomes & Offenders

Both tables have “Associated Ref” field which are references to a main table “Main”.

I want to filter the “Offenders” field ‘list’ to only show the offenders which have the same Associated Ref as what is current held in the [.THISROW].[Associated Ref] in the “Outcomes” form.

So my slice is using the offenders table as the source. Row filter condition: [Associated Ref]=[_THISROW].[Associated Ref]

Trouble is it is not filtering the offenders list to the test person. I have tried inserting the table name [Associated Ref]=Outcomes[_THISROW].[Associated Ref] but that also is not producing the desired result. Only Test Person 1 should show.

Domearian_1-1706006282421.png
Domearian_1-1706006282421.png369×645 12.1 KB

2

You mention Outcomes FORM. Is this a dropdown list where you only want to be able to select a subset of “Offenders”? If this is the case are you taking advantage of the Suggested Values setting?

3

I’ve managed to resolve the issue. I put FILTER(“Victim Offender”, AND(Contains([Associated SORF Ref], [Associated Ref]),[Offender/Victim]=“Offender”)) is the suggest value field.