Skip to main content
Question

Searching for text not included in Home default report

  • September 28, 2021
  • 0 replies
  • 37 views
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 default column on the table home page, is there a way to still search for the text from the table home page?

------------------------------
Chelsea Giacchi
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • September 28, 2021
You can cheat.

Make a formula URL field called [.] and add it to the home pages and mark it as searchable.
Use this formula

var text SearchTerms = (make a formula here to list the fields you want searched);
// for example list(",", [Phone],[address])
var text Words = " ";

"<a name=" & $SeachTerms & "</a>"
add that to the table Home Page Report. No one will ever ask you why you have a field on the right side of the report named [.] You can even override the column heading to blank using the new report.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+14
  • MichaelTamoush
  • Quickbase Alumni
  • September 28, 2021
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
------------------------------
Terms & ConditionsAccessibility statement