I have A filter that was working but isnt now

AppSheet AppSheet Q&A
, ,
1

Hello I had a filter made for a table that was working before but I changed one of the items in the filter from being its own table to a slice but also I’m using [ID]'s as the Key for the Employee’s and Address’s and I’ve ref from that. I believe that is causing a problem somewhere now I’m just not sure.

The filter its self is giving me the correct options so it is reading the [ID]'s to give me correct options I’m just not sure why its not filtering it.

Screenshot 2023-05-22 203420.png
Screenshot 2023-05-22 203420.png746×146 3.77 KB

Screenshot 2023-05-22 202643.png
Screenshot 2023-05-22 202643.png961×410 27.9 KB

Screenshot 2023-05-22 202716.png
Screenshot 2023-05-22 202716.png790×830 45.1 KB

2

I don’t think a slice can reference another slice. But I’m not 100% sure…

3

I think you are right cause I’ve made the table the main data for the filter and it is now working only issue is now is because I separate my clients and employee’s using a slice. If you want to enter hours for a timesheet if you want to select a employee it shows all the users. but the filter is working correctly.