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

74 replies

null
    • Fred
    • 2 yrs 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)?

    • saddinsell
    • 2 yrs ago
    • Reported - view

    Hi Fred,

    I'am typing the letter "x"

    Field text.

    • Fred
    • 2 yrs ago
    • Reported - view

    Don't you then do a select like:

     

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

    • saddinsell
    • 2 yrs ago
    • Reported - view

    Thanks 

    Where do I have to enter this script ?

    • saddinsell
    • 2 yrs ago
    • Reported - view

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

    • saddinsell
    • 2 yrs ago
    • Reported - view

    I tried :

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

    It does not work…

    • saddinsell
    • 2 yrs ago
    • Reported - view

    I add end at the end.

    Error : 

    "Identifier waited on the line 1, column 6"

    • saddinsell
    • 2 yrs ago
    • Reported - view

    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 !

    • Fred
    • 2 yrs 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.

    • Addinsell
    • 2 yrs 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"

    • Fred
    • 2 yrs 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?

    • Addinsell
    • 2 yrs 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 ?

    • John_Halls
    • 2 yrs ago
    • Reported - view

    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

    • Addinsell
    • 2 yrs ago
    • Reported - view

    Thanks John

    no more error this time but it does not work.

    • Addinsell
    • 2 yrs ago
    • Reported - view

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

    • Addinsell
    • 2 yrs ago
    • Reported - view

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

    • John_Halls
    • 2 yrs ago
    • Reported - view

    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?

    • Fred
    • 2 yrs 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.

    • Addinsell
    • 2 yrs 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 ?

    • Addinsell
    • 2 yrs ago
    • Reported - view
    • Addinsell
    • 2 yrs 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 !

    • Addinsell
    • 2 yrs 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 ?

    • Fred
    • 2 yrs 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.

    • Addinsell
    • 2 yrs ago
    • Reported - view

    Thanks Fred

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

     

    • Fred
    • 2 yrs 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?

Content aside

  • 2 yrs agoLast active
  • 74Replies
  • 2511Views