Skip to main content
Question

Large Note Field

  • June 8, 2020
  • 0 replies
  • 49 views

I have a large note field in my form. However, in the Table it takes up a ton of space. Is there a way to have a link to the note field in the table?

------------------------------
Mike McCartney
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Here is an app with a bunch of Tips which was presented at EMPOWER, and I have a link here to the tip you can use
https://team.quickbase.com/db/bpj7nsk6n?a=dr&r=br&rl=kfn

Let's assume the text field is called "Notes". Create a formula rich text field with the following formula:

Left([Notes], 100) & " " &

"<a href="&URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#] & "&dfid=11"&">"& "More" &"</a>" 

 where the number eleven above is the identifier of the custom form that displays only the field "Notes". To determine the dfid of your custom form you would want to open up the settings for that table, open up the forms section and you will see the form id of each form listed in that report. The above formula displays the first 100 characters of the "Notes" field. To display more or less characters change the number one hundred above. To change the display text for the link you would edit the part "More" to display the text you would like.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------