Hi there! I’m stuck with a filter that I need to do in my bubble app.
My client controls a list of his collaborators that work in a SERVICE. This services have the type of work as full time or part-time.
He needs to select a list of collaborators to allocate in a new service date, but only collaborators that are not in another full time service in that same day, or collaborators that are not allocated in 2 part-time services in the same day. And here is the point, how to retrieve a list of services that are part-time and does not have that chosen day 2 times?
I’ve tried :unique elements, but it brings 1 service of that chosen day.
I’ve tried group by, constraint by chosen date, and grouping by that chosen day, with count aggregation that result is 1, but it transforms the type of data in grouped, and I cannot merge or intersect anymore.
What can I do to make it work?