0

Two search in a base

Hi

 

Among others I have 2 fields in a base.

-One with a cross inside sometimes (x)

-Another one also with a cross inside sometimes (x)

 

What should I do to find the both with their crosses displayed ?

 

Thank you

74 replies

null
    • John_Halls
    • 2 yrs ago
    • Reported - view

    I still haven't seen a screenshot where you have an "x" in both 'Trés petite taille' and 'Petite taille'. Only then will you seen an "x" in your formula field 'Petite taille et Tres petite taille'

    • Addinsell
    • 2 yrs ago
    • Reported - view

    It's normal : there is a cross for each of one, never the both.

    Either the bird is "très grande taille" either is "petite taille".

    I tried to replace "and" by "or" in the code but the issue persists…

    • Fred
    • 2 yrs ago
    • Reported - view

    Thanks for the clarification. Now for a bit more troubleshooting:

     

    You said when you put a 1 in Trés petite taille and changed Petite taille et Tres petite taille to:

     

    if 'Trés petite taille' = "1" then "x" end

     

    that works. What about another letter, i.e. "h"?

     

    Have your tried putting a 1 in Petite taille then change Petite taille et Tres petite taille to:

     

    if 'Petite taille' = "1" then "x" end

     

    Does that work? What about another letter, i.e. "h"

    • Addinsell
    • 2 yrs ago
    • Reported - view

    I already tried with "1" before (see the post higher) and just tried with "h"

    No result !

    • Ninox partner
    • RoSoft_Steven.1
    • 2 yrs ago
    • Reported - view

    I sometimes experienced that if you want to check text from a formula field, using -      text('Petite taille') = "x"         -could be the solution.

    Steven

    • Addinsell
    • 2 yrs ago
    • Reported - view

    Thank you Steven.

    infortunatly it does not work either…

    • Fred
    • 2 yrs ago
    • Reported - view

    Please show us the Edit Fields window for Petite taille and Trés petite taille. 

    • Addinsell
    • 2 yrs ago
    • Reported - view

    Here 

    13158B4D-87F5-4A45-B561-B3D35C67ACB7

    • Addinsell
    • 2 yrs ago
    • Reported - view

    96658B85-07DC-4B46-900A-32EE4174543E

    • Fred
    • 2 yrs ago
    • Reported - view

    Well they are text fields.

     

    Just to verify that your if is looking for "X" not "x". Your data is showing "X" (captial).

     

    If you are still getting nothing then I would suggest that you create a new DB, create a new table like John did with just three fields:

     

    text field called Trés petite taille

    text field called Petite talle

    formula field with the following formula:

     

    if 'Trés petite taille' = "x" or 'Petite talle = "x" then "x" end

     

    Then type create three records:

     

    first record has a lowercase "x" in Trés petite taille

    second record has a lowercase "x" in Petite talle

    third record has lowercase "x" in both fields

     

    tell us what happens.

    • Fred
    • 2 yrs ago
    • Reported - view

    Like John this is what I get:

    Screen Shot 2021-06-02 at 19.52.10

    Screen Shot 2021-06-02 at 19.52.19

    Screen Shot 2021-06-02 at 19.52.29

    • Fred
    • 2 yrs ago
    • Reported - view

    I created a fourth record with blanks for the two fields. Then when I filter petites tailles et très petite taille for X, I get the 3 records that have an X in petites tailles et très petite taille.

    • Addinsell
    • 2 yrs ago
    • Reported - view

    Here

    It does not work either.

    My base must be damn…

    B1A93F35-A6DD-4879-85D5-28C3260E48A6

    • Fred
    • 2 yrs ago
    • Reported - view

    Can you put up screenshots of your new DB that match what I put up?

    • Addinsell
    • 2 yrs ago
    • Reported - view

    Is that what you mean ?

    A29F166D-8E4E-4F36-B7FE-881637116952

    • Addinsell
    • 2 yrs ago
    • Reported - view

    55ABF032-46E2-462F-91E6-CFEC73CB83FE

    • Addinsell
    • 2 yrs ago
    • Reported - view

    73DAE438-255B-4CD6-B286-79A5ADCD171C

    • Fred
    • 2 yrs ago
    • Reported - view

    Great! Now one more of the formula you put in Petite taille et Trés petite taille

    • Addinsell
    • 2 yrs ago
    • Reported - view

    D3E62E6E-2322-47B3-8AB4-87678CA8A9F4

    • Fred
    • 2 yrs ago
    • Reported - view

    the formula is still looking for lowercase "x" and the data is using uppercase "X". Please make sure you double check that what you are looking for actually exists in your data.

    • Addinsell
    • 2 yrs ago
    • Reported - view

    Thanks Fred you are right

    For the new base it works now.

    But it still does not work for the other one.

    Yet of course, I check the error with upercase/lower case.

     

    if text('Trés petite taille') = "X" and text('Petite taille') = "X" then
    "X"
    end

    • Addinsell
    • 2 yrs ago
    • Reported - view

    Sorry it is another code, I redo it as :

    if 'Trés petite taille' = "X" or 'Petite taille' = "X" then
    "X"
    end
    and………it works !!

    • Fred
    • 2 yrs ago
    • Reported - view

    Ok, so we know it works in a new DB. Now you need to figure out why it is not working in your main DB. Start simple with just:

     

    if 'Trés petite taille' = "X"

     

    if that works, then switch to:

     

    if 'Petite taille' = "X"

     

    if that works then you can add the "or".

     

    Again you have to make sure you have the data in the fields you are looking for.

     

    Good luck.

    • Addinsell
    • 2 yrs ago
    • Reported - view

    Thanks again Fred.

Content aside

  • 2 yrs agoLast active
  • 74Replies
  • 2511Views