0

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

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 wk ago
    • Reported - view

    You can use the constraints settings in this field:

    let c := concat((select Tickets).QR_Code.QR);
    not contains(c, b.QR)

      • Christoph_Hintermuller.1
      • 3 wk ago
      • Reported - view

       that looks great. 

      But Ninox is showing me an error for the second line "Function is not defined"... 

      • Ninox partner
      • RoSoft_Steven.1
      • 3 wk ago
      • Reported - view

       

      Where did you put this formula? here ? (maybe there's a typo?) >>>

      • Rafael Sanchis
      • Rafael_Sanchis
      • 3 wk ago
      • Reported - view

       

      Maybe this 

      let c := concat((select Tickets).'QR_Codes_>'.QR);
      not contains(c, text(b.QR))

      • Rafael Sanchis
      • Rafael_Sanchis
      • 3 wk ago
      • Reported - view

       

      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 = d
      

      and 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