Forum Discussion

ChelseaGiacchi's avatar
ChelseaGiacchi
Qrew Member
3 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
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
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's avatar
Juliannada_Silv
Qrew Member
3 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's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    The last line should read

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

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • Juliannada_Silv's avatar
      Juliannada_Silv
      Qrew Member
      3 years ago
      it worked - thank you so much!

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