Search for a name in several fields
Hi
Could someone tell me way to search for words in multiple fields (multiple columns)
Example :
in a database I have the same name "John Miles" which is in column 2, 4, 6, 8, 10
I would like them to display all five of them.
What should I do ?
Thank you
3 replies
-
if you are talking about columns being those shown on a table view and you typeing in that search box at the top.
then make sure all the coluns you want to be search are invluded in the table view
then the the search will return records with John Miles in any of the columns
-
Thanks Mel
My question was what script should I create to find the same word in differents columns.
And it is possible to write it in the search box at the top ?
-
You don't need a script as long all the columns you want to search on are included in the grid then
typing a name etc in the top search box will find them no matter what column you have the data in !
if you have say set names that you always want to find then you could creat a new table view and pr filter it.
Scripts etc would go onto a button/fields etc but in form view not table view!
Content aside
- 4 yrs agoLast active
- 3Replies
- 466Views