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

74replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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'

    Like
    • Addinsell
    • Addinsell
    • 1 yr 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…

    Like
    • Fred
    • Fred
    • 1 yr 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"

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

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

    No result !

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

    Steven

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

    Thank you Steven.

    infortunatly it does not work either…

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

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

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

    Here 

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

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

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

    Like
    • Fred
    • Fred
    • 1 yr 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.

    Like
    • Fred
    • Fred
    • 1 yr 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

    Like
    • Fred
    • Fred
    • 1 yr 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.

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

    Here

    It does not work either.

    My base must be damn…

    B1A93F35-A6DD-4879-85D5-28C3260E48A6

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

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

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

    Is that what you mean ?

    A29F166D-8E4E-4F36-B7FE-881637116952

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

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

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

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

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

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

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

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

    Like
    • Fred
    • Fred
    • 1 yr 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.

    Like
    • Addinsell
    • Addinsell
    • 1 yr 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

    Like
    • Addinsell
    • Addinsell
    • 1 yr 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 !!

    Like
    • Fred
    • Fred
    • 1 yr 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.

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

    Thanks again Fred.

    Like
Like Follow
  • 1 yr agoLast active
  • 74Replies
  • 2464Views