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! Go to 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.
Is your UX view configured to use the slice?
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.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |