Share
Report
87Hello all,
I have a gallery with billing tracker, which I would like to filter based on "quick" filters - buttons below the gallery.
In buttons I have set 2 boolean context variables filterOpen (for not sent invoices) and filterMyRequests to filter only requests by current user. Buttons Onselect properties are set as following:
UpdateContext({filterOpen: !filterOpen})
UpdateContext({filterOpen: !filterOpen})
I am struggling with setting the Gallery Items to show correct result. Below code is bet what I got, but it does not work as expected. When I select only one button, it works. But when I select both, result is whole table
Filter(
colBillings,
If(
filterOpen,
DocumentStatus <> "Sent"
) || If(
filterMyRequests,
varUser.Email = RequestedBy.Email
)
)
Categories:
I have the same question (0)
All responses (
Answers (
