Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.
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?
Let's assume the text field is called "Notes". Create a formula text field with the following formula:
Left([Notes], 100) &
" " & URLRoot() & "db/" &
[Record ID#] &
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:
The above formula displays the first 100 characters of the "Notes" field. To dipslay more or less characters change the number one hundred above.