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
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view
    Like
    • Fred
    • Fred
    • 1 yr ago
    • Reported - view

    I thought you wanted an x in Trés petite taille et Petite taille if there is an x in both Trés petite taille AND Petite taille. Is that not true?

     

    Or do you want an x in Trés petite taille et Petite taille if there is an x in Trés petite taille OR Petite taille? If you want this then change your and to or.

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

    Thanks Fred

    I tried that but same result : no crosses displayed…

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

    Remember that equal is case sensitive. From your screenshots it looks like you have "X" (capitol) in your data, but you are searching for "x" (lowercase) in your formula.

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

    Thanks, but same issue with x in lower case…

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

    I tried :

     

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

    It does not work either…

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

    Ok now you have to investigate the data. 

    1) what kind of field is Trés petite taille?

     

    2) if you put a 1 in one of the records and switch the formula to look for 1 does it mark it properly?

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

    Hi Fred,

    Thanks

    I tried 1 in "petite taille" and "trés petite taille"  : when I put it in "petite taille et trés petite taille" in the filter, 1 does not appear…

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

     "Trés petite taille" is a text field

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

    Did you change the formula in petite taille et trés petite taille to look for 1?

     

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

     

    then you can filter petite taille et trés petite taille to filter for 1

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

    Yes it works with 1 with 

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

    So is there an error in the code :

    if 'Trés petite taille' = "x" and 'Petite taille' = "x" then "x" end ?

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

    I have not seen any record with both Trés petite taille and Petite taille marked with an "x" so I don't think anything is wrong.

     

    Can you confirm that you have records with x's in both fields?

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

    Yes I already joined a screen shot that I join again where one can see crosses in "trés petite taille", the other one is lower and can't be in the shot.

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

    Find a record that has both or just put an "x" in both fields and see what happens. 

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

    It does not work either.

    Like
  • Is this what you are looking to have?

     

    Screenshot 2021-06-02 at 16.22.06

     

    Screenshot 2021-06-02 at 16.22.40

     

    Screenshot 2021-06-02 at 16.23.11

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

    Yes exactly, John

    What do you enter in the filter box ? X ?

    2AABD853-F2FC-4852-BBBC-3808BCBE9C49

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

    The first screen shot is the result of the search X in the filter of "Petites tailles et Très petite taille" : there is not cross…

    Like
  • I have't put anything in the filter box. Before moving on to that test your code with an "x" in each of the fields and see if your formula gives an "x". See how I have tested my code in my third screenshot.

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

    If you do not put anything in the filter box search area hox can you use the formula ?

     

    Anyway here are screenshots showing that the "Petites taille" and "Très petites taille" works well.

    738486A6-9D98-4D7C-A7BF-BEBB550B5B5D

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

    F9085A80-3DB0-4C76-8035-00884DFA3E1D

    Like
  • The formula will give its result automatically and has nothing to do with the filter. You can, of course, filter the result if you so wish.

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

    Ok. But as you can see there is nothing in the column-formula there is something wrong somewhere. 

    But where ?

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