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

    When you say "cross" are you typing in the letter "x"? Or is this an icon? What kind of fields are they (text, number, etc)?

    Like
  • Hi Fred,

    I'am typing the letter "x"

    Field text.

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

    Don't you then do a select like:

     

    select Table1 where field1 = "x"  and field2 = "x"

    Like
  • Thanks 

    Where do I have to enter this script ?

    Like
  • Surely I have to create a formula but I think something is missing in the script, isn't it ?

    Like
  • I tried :

    for in select 'Table ok*' 'Trés petite taille'=x and 'Petite taille'=x

    It does not work…

    Like
  • I add end at the end.

    Error : 

    "Identifier waited on the line 1, column 6"

    Like
  • I removed "for in"
    select 'Oiseaux famille genres espéces' where 'Trés petite taille' = "x"  and 'Petite taille' = "x"
    end

    but I get 

    end waited : end on the line 2, column 3 !

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

    Maybe you can tell me exactly what you are trying to do.

     

    Your last formula doesn't need an end, if you are just doing a select.

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

    I am trying to create a formula as you told me to do but I do not succeed !

     

    select Table1 where field1 = "x" and field2 = "x"

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

    Please tell us what do you want to happen?

     

    what tables are you using? 

     

    What fields are you using?

     

    are you in a record or are you looking at a table view?

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

    Hi

     

    I am on a table called "Oiseaux famille genres espéces" (in the begining I made a mistake I put "Table ok*")

    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)

    I am trying to create a formula to search and display the records with a field with a cross in one field called Trés petite taille and in the same time another one called Petite taille

     

    I created a new formula field that I called  "Trés petite taille et Petite taille"

    I entered in the formula area :

     

    for in select 'Oiseaux famille genres espéces' where Trés petite taille = "x"  and Petite taille = "x"

     

    I tried with for in and without "for in" in the beginning and with "end" and without end at the end

     

    I alway have this error :

     

    "Identifier waited on the line 1, column 6"

     

    Coul you please help me ant telling me where is the error in my script ?

    Like
  • In your formula field "Trés petite taille et Petite taille" put this code

     

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

     

    Regards John

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

    Thanks John

    no more error this time but it does not work.

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

    95DA9A62-1DEE-40C8-95E5-A7CBFDDD708F

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

    I displayed the new field formula "petits et trés petits" : it is empty !

    Like
  • That is correct. It will only have an "x" in it if both Trés petite taille and Petite taille have an x in them and there are no records in your screenshot that have that. Are you sure that is what you wanted?

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

    It looks like the formula is working. The records you show do not show "x" in both Trés petite taille and Petite taille so then there is nothing in petits et trés petits.

     

    Look for records that have an "x" in Trés petite taille and Petite taille and then see what petits et trés petits displays.

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

    Thank you

     

    Strange...

     

    I just noticed that my formula field "petites tailles et très petite taille" is in a text format in the table view !

    I can't no more drag and drop it again because it is no more in the right window…"available columns"

    I think it is the explanation of the issue : the column "petites tailles et très petite taille" in the table view is not a formula...

    What could I do ?

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

    I create a new formula field and the same thing happens : when I drag and drop the formula from the right window to the left one the formula becomes a text field !

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

    By the way if the fied was a formula field what I have to enter in the filter area of the column ?

    x ?

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

    The picture from May 30 10:17pm doesn't change the formula field into a text field. What it is showing you is that the data in the field is text. The field is still a formula field. The Edit Columns window doesn't edit fields. Only the Edit Fields window does that.

     

    You are correct, you just need to put x in the filter and it will show you all records with an x in that field.

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

    Thanks Fred

    When I enter a X in the filter no X are displayed…

     

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

    You can't try ="x, but I suspect that you don't have any data that has an x in both fields. Can you find, or make, a record that does and see what the new field says?

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