N:1 Filter
Hi guys,
I am looking for some help. Maybe you have an idea.
I have a table which is called QR_Code. Inside of the table is a Callum with the title "QR" where I have 100 codes.
There is a second table which is called "Tickets". In Tickets I have a N:1 Relation to "QR_Code" because I want to assign a QR Code Number to every new entry in Tickets.
My problem is this: I want to assign every QR code Number only once. But if I am clicking on the N:1 Relation I can see still all. Is there a way to fade out used QR code numbers? Maybe with a formula which fades out all QR codes Numbers which are allready in a relation with Tickets?
Do you have an idea?
Best
Christoph
5 replies
-
You can use the constraints settings in this field:
let c := concat((select Tickets).QR_Code.QR);
not contains(c, b.QR)
Content aside
- 3 wk agoLast active
- 5Replies
- 48Views
-
3
Following