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

Juliannada_Silv

Qrew Member

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
  ------------------------------
  - Juliannada_Silv
    Qrew Member
    4 years ago
    it worked - thank you so much!
    
    ------------------------------
    Julianna da Silva
    ------------------------------