A formula with multiple requests…
Hi,
What is the formula to have multiple requests ?
For example in a cars database I seek 3 requests : power : 600 hp, country : Italie numbers of cylinders : 6
Thanks for your kind attention and advices.
Best regards,
Steve
11 replies
-
In a View try the formula:
select cars where power = "600 hp" and country = "Italie" and 'numbers of cylinders' = 6 -
The above assumes your three columns have data types of text, text and number. A column name with spaces requires single quotes.
-
Thank you Dean
Can you explain me the way to
get to formula box ?
there is a screen shot, is it all right ?
- And wich is the good tab : "visual" or "text"
- I can't write the formula you suggest me on The white area… -
-
You say :
"The above assumes your three columns have data types of text, text and number."
In the formula box I found in the tab "text" : "text" but not "text and numbers".
Where do you find that "text and numbers" ?
-
I tried that with "text"
I drag and drop text in the white area
Inside this text I write :
select voiture where pays = "ALL"
(My app is for French so car > voiture and country > pays)
But it did not work…
-
Click "Texte" (not "Visual"), so you can type or paste in code. Data type is selected when you create each field, in "Edit Fields". In my example, 'numbers of cylinders' is a number field, not a text field, so its value is a number with no quotes.
-
-
If you do not want to use select statements you can just enter your search criteria in the Find field above a table to search across all visible columns.
-
Thank you Dean.
Is it possible to search in the same column few text values
Ex Display : Ferrari and Audi and Aston Martin ?With the filter it works with number values with ”and” but not with text values…
-
In a View formula, for the country column you could do:
select cars where country = "France" or country = "Germany"
I do not know if this is possible with a Find field.
Content aside
- 4 yrs agoLast active
- 11Replies
- 1153Views