Once a text field reaches a certain length how can I truncate the text and add a link to allow the user to see the rest of the field's content?

[The Quick Base Knowledge Base is your library of frequently-asked questions that help you better customize your apps to solve your business problems.]

Let's assume the text field is called "Notes". Create a formula text field with the following formula: Left([Notes], 100) & " " & URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#] & "&dfid=11" 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 please read: http://quickbase.intuit.com/developer/node/2089 The above formula displays the first 100 characters of the "Notes" field. To dipslay more or less characters change the number one hundred above.