Two search in a base
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 ?
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.
Thank you Steven.
infortunatly it does not work either…
Please show us the Edit Fields window for Petite taille and Trés petite taille.
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.
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
Sorry it is another code, I redo it as :
if 'Trés petite taille' = "X" or 'Petite taille' = "X" then
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.
Thanks again Fred.
- 2 yrs agoLast active