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=kfnLet'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.commark.shnier@gmail.com
------------------------------
