Forum Discussion

Qrew Member

4 years ago

Searching for text not included in Home default report

Is it possible to have fields included in the search parameters on the Table Home Page if it's not included on the home page. For example, if a form/records includes a notes field but that's not a def...

Formulas and functions

MichaelTamoush

Qrew Captain

You can thank @Mark Shnier (YQC) for this one!

//use formula rich text with the code below, and put this in the report. Make the column header a period to essentially remove the title and 'hide' this column.

var text URL = List(" ", [field 1] , [field 2], [field 99]); // all the extra fields to be searched. if not text, the wrap them in ToText

"<a name=" & $URL & "</a>"

------------------------------
Michael Tamoush
------------------------------

Juliannada_Silv

Qrew Member

4 years ago

Hi Michael and Mark,

I work with Chelsea and I'm struggling with getting this formula to work. I'm brand new to this so I was hoping either of you would be able to point out where my formula is going wrong - please see below and attached for reference. Thank you so much in advance!

var Text URL = List(" ",[FOCO Tag - Category],[FOCO Tag - Sport],[FOCO Tag - Team (NCAA)],[FOCO Tag - Team (Pro)]);
<a name=" & $URL & " "</a>

------------------------------
Julianna da Silva
------------------------------

MarkShnier__You
Qrew Legend
4 years ago
try wrapping those fields in ToText

var Text URL = List(" ",ToText([FOCO Tag - Category]),ToText([FOCO Tag - Sport]),ToText([FOCO Tag - Team (NCAA)]),ToText([FOCO Tag - Team (Pro)]));
<a name=" & $URL & " "</a>

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Juliannada_Silv
  Qrew Member
  4 years ago
  Hi Mark,
  
  Thank you for that! I'm still getting an error though - see attached
  var Text URL = List(" ",ToText([FOCO Tag - Category]),ToText([FOCO Tag - Sport]),ToText([FOCO Tag - Team (NCAA)]),ToText([FOCO Tag - Team (Pro)]));
  <a name=" & $URL & " "</a>
  
  ------------------------------
  Julianna da Silva
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    4 years ago
    The last line should read
    
    "<a name=" & $URL & "</a>"
    
    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------