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)-
that looks great.
But Ninox is showing me an error for the second line "Function is not defined"...
-
Where did you put this formula? here ? (maybe there's a typo?) >>>
-
Maybe this
let c := concat((select Tickets).'QR_Codes_>'.QR);
not contains(c, text(b.QR)) -
Hi Steven
I have in the Activities table two n:1 field one 'Disciplinas_Act_>' and other 'Especialidades_Actv _>' here the following constraints on 'Especialidades_Actv_>'
let c := a.'Disciplinas_Actv_>'; let d := b.'Disciplinas_Espec_>'; c = dand in the Especialidades Table I have another n:1 field 'Disciplines_Espec_>'
The constraints work well but there are other best way to resolve this.
On Activities table I select the Disciplina and when select Especialidades display only the Especialidad for the Disciplina. Work ok
-
Content aside
- 10 days agoLast active
- 5Replies
- 48Views
-
3
Following