Two search in a base

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'

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…

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"

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

No result !

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

Steven

Thank you Steven.

infortunatly it does not work either…

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

Here 

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 John this is what I get:

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.

Here

It does not work either.

My base must be damn…

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

Is that what you mean ?

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

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.

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

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 !!

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.

Thanks again Fred.