Filter a slice with a comparison

AppSheet AppSheet Q&A
1

Hello All,

I have another situation that we are struggling with. I will try to explain briefly. We have one table - CAR, we have another table PDP. The PDP table is planning stage, the CAR table is the actual Capital Request. If the Capital Request is a budgeted item, I need to pull the list of Project Titles from the PDP table that matches the facility chosen in the new CAR record. When I hard code the facility number, my slice is filtered appropriately. When I try to do a comparison, it doesn’t work - we have tried many, many, many different ways (including Any, IN, Contains, etc.) None seem to work the way we are expecting it to. Screen shots are below and any help, as always, is greatly appreciated!

This is the code in the row filter for the slice that populates the PDP Project Title field:

IN([ProjectTitle],select(PDP[ProjectTitle],([Company]=[_THISROW].[Company])))

This one works for the hard-coded company:

IN([ProjectTitle],select(PDP[ProjectTitle],([Company]=110)))

PJMatelli_2-1656026533298.png
PJMatelli_2-1656026533298.png478Ă—608 34.6 KB

PJMatelli_3-1656026543134.png
PJMatelli_3-1656026543134.png478Ă—642 15.6 KB

The list you are seeing includes Titles that do not belong to the Facility selected (Royal Oaks). **The last 2 that begin PJs Test are for other facilities - not Royal Oaks.

TIA!
~Paula

2

Verify that the [Company] column in the CAR table is of Number type.

1 Like
3

The [Company] column in the CAR and PDP tables are a ref to the list of facilities in tblFacility which is a number.

4

I figured it out…instead of trying to do it in the slice, I used the Valid if section of the field PDPProjectTitle with this select statement: SELECT(PDP[ProjectID], ([Company]=[_THISROW].[Company]))

2 Likes