Search Feature
I'm trying to create a search feature where a user can search for let's say John Smith or a Tax id or PIN. For the standard search, if the user searches for John Smith, it does not return any record...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCarol,
Let's nail this in three steps.
Make a new formula field called Search Target with the formula
List(" ", [First Name], [Last Name], [Tax ID], [PIN])
Put that field on the report and observe that the search for John Smith works.
Then, you can make a new formula rich text field called Hidden Search Target.
"<a name=" & URLEncode([Search Target]) & "</a>"
add that to a report. Either name the rename the field like a dot . or else do a column override on the report to have a . or blank for the column name and put the field at the far right of the report where users will not really notice it.
That allows you to make a hidden column with all the possible search terms you want without cluttering up the report with extra visible fields.
I used a similar solution to what you came up with, Mark! I made a formula rich text field, using the List function to string all of my searchable fields together, then inserted a small transparent image and used the result of the List function in the "title" attribute of the <img> tag. It ended up looking something like this. I purposely didn't include all of my searchable fields, just a few for this example.
var text agency = [Agency];
var text recordowner = UserToName([Record Owner],"FF");
var text projectname = [Project Name];
var text searchtitle = List(" ",$agency,$recordowner,$projectname);
var text transparent = "<img src='INSERT TRANSPARENT IMAGE URL HERE' title='" & $searchtitle & "'>";
$transparent
Then I added that field to the far right of my report. I overrode the column name with a dash (-). To the end user, it just looks like a blank column, but it allows them to search a lot of things that aren't on the report.