14.07.2022
14:49
Hi All,
We are implementing a workflow for payment list. We are using picker to add unpaid invoices to a list, but default behavior is that I can add the same values over and over.
Is it possible to limit/filter picker results to items that were not yet added?
21.07.2022
23:01
Hi,
I hope it's not to late.
You can achieve this by storing the already selected ids in a (technical) field and adding a where condition, that these are not part of the data source.
You can see in my attached screenshot, that 2,3 and 6 have been selected and when I wanted to select 2 again I got an "No matches found" error (1). The selected values have been stored in the field (2).
I stored them there using the Style and behavior of the picker column in the item list (3).
The SQL query excludes those ids from the result set (4).
Best regards,
Daniel
