I have a column in the locations_filter table named “Driver Name.” I’m trying to create a data slice with this column but AppSheet won’t recognize the column. What did I do wrong?
What is the expression you are using?
Is the show? option enabled on the column? slices don’t see any columns that have a disabled show? field, I believe.
Did you use Driver Name or Driver Name. ??
News to me…
Wait nope I retract that statement I was thinking about views!
Oh that just looks like your formula is wrong.
Your formula “any(locations_filter[driver name]=[drive name])” doesn’t make since. ANY() means return the first record in a list and locations_filter[driver name]=[drive name] 1. is a list = a column and 2. return true or false so its not a list for ANY() to work with. I’d recommend trying to use a full SELECT() instead of the locations_filter[driver name]=[drive name] to create your formula. You’re likely trying to get SELECT(Locations_Filter[driver name], [driver name]=[_THISROW].[driver name]).
Thank you Austin. So what I’m trying to do is filter gps check-in data according to the name in locations_filter. The gps check-in data is in delineatedLocations. How do I do that?