Re: How can I get a list of text to display in columns rather than one long list?
Make a formula rich text field called either like [Search target] or a really skinny name such as a dot [.]
add that to a report as say the last column. If it's labelled as a dot either as the native field name or as a column override field name, no one will even notice that it's there.
Basically it's a cheat. For performance reasons Quick Base only searches fields that are on a table report. So this makes a fake hyperlink but the only visible words are null - empty quotes. but it's a field on the report so it gets searched.
var text URL = [my search target field]; var text Words = "";
"<a href=" & $URL & ">" & $Words & "</a>"
add that to a report as say the last column. If it's labelled as a dot either as the native field name or as a column override field name, no one will even notice that it's there.
Basically it's a cheat. For performance reasons Quick Base only searches fields that are on a table report. So this makes a fake hyperlink but the only visible words are null - empty quotes. but it's a field on the report so it gets searched.
