Shorten Column Width
I have a report called "Vendor List". Which lists Vendor Name, Address, etc. One of the fields we created is "Keywords", a text field where we include former names of the vendor, or AKA names... Th...
Forum Discussion
Ok, so I have a magic answer.
Make a formula rich field type and concatenate all the fields that you want to search into one field and make a fake hyperlink. The field will be searchable but invisible to the naked eye.
Add the field as the last column of the report and either override the column heading with a dot for a label or just call the field [.]
It will be a skinny field at the end of the report that no one will notice but magically all the extra fields you need searched will be searched using the filter box.
var text URL = List(" ", [sub 1], [sub 2], [sub 40]); // put the extra fields to be searched here
var text Words = "";
"<a href=" & $URL & ">" & $Words & "</a>
Make a formula rich field type and concatenate all the fields that you want to search into one field and make a fake hyperlink. The field will be searchable but invisible to the naked eye.
Add the field as the last column of the report and either override the column heading with a dot for a label or just call the field [.]
It will be a skinny field at the end of the report that no one will notice but magically all the extra fields you need searched will be searched using the filter box.
var text URL = List(" ", [sub 1], [sub 2], [sub 40]); // put the extra fields to be searched here
var text Words = "";
"<a href=" & $URL & ">" & $Words & "</a>
Thanks for your help -- but I'm still having trouble:
var text URL = List(" ", [Key words]);
var text Words = "";
"<a href=" & $URL & ">" & $Words & "</a>"
That's the formula I used, but I am getting an error...
var text URL = List(" ", [Key words]);
var text Words = "";
"<a href=" & $URL & ">" & $Words & "</a>"
That's the formula I used, but I am getting an error...
