0

Bigger or equal…

Hi

 

I have a formula in wich I should like to put the math symbol > or =

I am on an Ipad and the virtual keyboard have not that possibility; just touch > or touch =;  but not the math symbol with the two of them in the same touch.

 

So I tried to put in my formula

=>

Then

= or >

Then

= and >

But I get errors every time.

 

Could someone help me ?

 

Thanks if you do.

49replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 1 yr ago
    • Reported - view

    Just switch the symbols around >= or <= NOT => or =<.

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    Thank you Fred

     

    There are still few dupilcates

    Above all "duplicate" is written everywhere…

     

    My formula :

    let myV := Nom;

    if cnt(select 'Oiseaux famille genres espéces' where Nom = myV) >= 1 then

    "Duplicate"

    else

    null

    end

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view
    Like
  • Are U sure there are no 'spaces' in the field: Nom?

    We had that already in the past......

    Steven

    Like
  • You have >=1 so the result is true for every record. Try >1 instead.

     

    Regards

     

    John

    Like
    • Fred
    • Fred
    • 1 yr ago
    • Reported - view

    It took me awhile to figure it out, but I think you are seeing duplicates on empty cells because you are not checking for empty fields first.

     

    Even empty cells satisfy your current conditions. You ask Ninox to find records where Nom equals Nom. Even if Nom is empty, you are saying if Empty Nom equals Empty Nom then count it. So you will always get a 1 so you will always see Duplicate. You can see this if you add a new column with the following formula:

     

    let myV := Nom;

    cnt(select 'Oiseaux famille genres espéces' where Nom = myV)

     

    You will see that all of your records have at least a one.

     

    Will Nom be able to be empty or will it always have data when your db is complete?

     

    In addition, when you added >= 1 that will mark records with only a single instance of Nom to be a duplicate. Is that what you want?

     

    This is what I mocked up in a test db of mine, I've added in your names:

     

    let myV := Nom;
    if myV = null then
    "Empty"
    else
    if cnt(select 'Oiseaux famille genres espéces' where Nom = myV) > 1 then
    "Duplicate"
    else
    null
    end
    end

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    Thank you Steven, and John.

    Thank you Fred.

    Fred, your formula has some words in French.

    Maybe it will not work. I already had issues with that.

    I tried to manage it…but I need your help.

     

    A quote is missing at the end of Duplicate. Is that willful ?

    For "vide" is it empty or blank ? For "sinon" is it unless or if not ?

    Could you, please tell me what is correct ?

     

    let myV := Nom ;

    If myV = null then

    "empty" / "blank"

    sinon unless / if not

    if cnt(select 'Oiseaux famille genres espéces' where Nom = myV) > 1 then

    "Duplicate"

    unless / if not

    null

    end

    end

    Like
    • Fred
    • Fred
    • 1 yr ago
    • Reported - view

    Remember that all Ninox code has to be in English. Table/Field names can be in any language. Any text that is output can be in any language.

     

    let myV := Nom ;

    If myV = null then

    "empty" / "blank"<--you can put whatever you want here. you can put "vide"

    sinon unless / if not<--this has to be in English and has to be else

    if cnt(select 'Oiseaux famille genres espéces' where Nom = myV) > 1 then

    "Duplicate"

    unless / if not<--this has to be in English and has to be else

    null

    end

    end

    Like
    • Fred
    • Fred
    • 1 yr ago
    • Reported - view

    Also just noticed in line 2 you have a capital "I" for if. That has be lowercase "i". You also need a colon in front of the equal sign.

     

    if myV := null then

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    Thanks a lot Fred.

    About "unless"/"if not" what do you mean by "this has to be in English and has to be else". Else ?

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    It's ok. I understood…

    I'll tell you about the result.

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    It's ok. I understood…

    I'll tell you about the result.

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    Well I tried the formula : "Duplicate" is still everywhere.

    IE the Solitaires…

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    On another base :

    Like
  • Hi

     

    Can you copy and paste your final code here.

     

    Thanks John

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    That one for the second base :

     

    let myV := Nom;
    if myV := null then
    "empty"
    else
    if cnt(select 'Oiseaux famille genres espéces' where Nom = myV) > 1 then
    "Duplicate"
    else
    null
    end
    end

    Like
    • Fred
    • Fred
    • 1 yr ago
    • Reported - view

    Wow, maybe I need to stop posting. Another mistake of mine. In Line 2, I was wrong to say you need a colon in front of the equal sign. It should read:

     

    if myV = null then

     

    The second image it looks like the formula is working as intended. There are duplicates there.

     

    For the first image can you create a formula column that just has:

     

    let myV := Nom

    cnt(select 'Oiseaux famille genres espéces' where Nom = myV)

     

    then what number does it give for Souimanga for example? Does it say 1 or some other number?

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    Hi Fred,

     

    You say : "The second image it looks like the formula is working as intended. There are duplicates there."

     Yes but where are the "non duplicate" ?

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    With the new formule Souimanga has number 2 like all the others, except Dindon sauvage and Megapode de Reinwardt

     

    EBD1DA15-034C-4B1A-9043-521A69D16604

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    Dindon sauvage and Megapode de Reinwardt > number 1

    91212550-C45E-4C27-9D55-C703CCD5B84B

    Like
    • Fred
    • Fred
    • 1 yr ago
    • Reported - view

    can you post, again, the final code for "Formule doublons noms".

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    There are the two formulas of the two differents bases

    One has "Nom", the other "Noms"

     

    let myV := Nom ;

    if myV := null then

    "empty"

    else

    if cnt(select 'Oiseaux famille genres espéces' where Nom = myV) > 1 then

    "Duplicate"

    else

    null

    end

    end

     

    let myV := Noms;

    if myV = null then

    "empty"

    else

    if cnt(select 'Oiseaux famille genres espéces' where Noms= myV) > 1 then

    "Duplicate"

    else

    null

    end

    end

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    There are not differents bases but differents views of the same table of a base.

    Like
    • Fred
    • Fred
    • 1 yr ago
    • Reported - view

    Well I am now confused. But at least on the coding front you need to double check your coding.

     

    For the Nom formula you sill have the := in line 2.

     

    Now you say you have two formulas, the picture from April 22, 4:21pm is confusing me. one column says Nom and the other says Formule doublons Noms. So I don't know if the formula is pointing to the correct field. Please go back and double check that the fields and formulas you want to check are next to each other so you can be sure you are comparing the correct data.

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    I may have an explanation.

    When I open the fields of one of the bases, very often I have a column number of the field in the formula and a name in the name field

    Here "Noms" in the name field and "column14" in the formula field.

    Could that explain the issue ?

    Like
Like Follow
  • 1 yr agoLast active
  • 49Replies
  • 1658Views