New Bug Encountered: Slice fiter not working on UX

I put a slice filter and test it. The result looks correct. But when I enable it to UX. It seem not right.

My formula on slice filter is below

and([Delivery Date] >= Today() - 8, in([Store], lookup(useremail(), “Access Setup V2”, “Email”, “Access Store”)))

Solved Solved
0 8 267
1 ACCEPTED SOLUTION

This is a known issue with the combination of Slice and LOOKUP() when the target column is an EnumList. Workaround is to create a virtual List column with a LOOKUP() formula and then use that with the Slice.

View solution in original post

8 REPLIES 8

Steve
Participant V

Is your UX view configured to use the slice?

3X_2_1_218a7e346f2bd3e5bdbde1afb4bff68816742938.png

Yes, the UX use the slice. I tried IN, CONTAIN, FIND, they all work on the slice filter. Test results come back as what I want. But for somehow, it is just not working on the UX.

Hi @Info_Soonta
Could you please post pics of your view and the slice test.

Test result from slice

Setup for UX

Final view on app

In what way is the result not what you expect? What do you expect?

You can see the store name on the test result return with multiple stores. But the UX only show 1 store

Please contact support@appsheet.com for help with this.

This is a known issue with the combination of Slice and LOOKUP() when the target column is an EnumList. Workaround is to create a virtual List column with a LOOKUP() formula and then use that with the Slice.

Top Labels in this Space