Hello,
I have a custom collection, with a rich text component inside, that has some HTML.
I’m trying to filter based on an IF then Else column, works with a native collection but not with custom ones. I can’t figure this out. is there any limitation for that in glide?
thanks
If I understand, you have a standard collection and also a custom collection with both a filter. The standard collection filter works, but not the custom collection filter. Right?
May I ask you to show us how you configured your filters?
Now after troubleshooting, it seems it’s related to row ownership.
I have a table listing all cars, that all users have access to, Im querying ongoing and upcoming bookings doing an IF else that will show “available” and “Not available”. for a user with ownership on the Bookings table, the filter works. for a non owner it just displays a fallback value as “Available”. if I look into the table the values are correct, you think there is a workaround to other than removing row ownership and exposing my data?
What do you expect the logic to be with the non-owner? I assume that you’re showing a list of available cars, but the bookings that are tied to the car are protected with row owners?
Correct. In the data editor all is good. But when it comes to filtering with the obtained data it doesn’t work. Unless I remove the row ownership.
Is there a way you can have a mirrored table with only the columns you can make public? E.g: The date and the car ID.
Im not sure. How can i do that
When you add a new booking, add a row with basic columns in the “mirrored” table, alongside the rowID of the original booking row.
Establish a relation between the original and the mirrored row.
When you edit a booking, edit the mirrored row as well.
Same as delete.
The idea is you will store only info that are not identifiable or public-able in that table, and keep the rest of the info private via row owners in the bookings table.
