How do I show only the most recent comment from an append field in my report?

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

Append fields can become quite large and contain too much text to display in a report easily. You can use a Formula - Text field to display only the most recent value from your append field and then display the formula text field in your reports instead of the append field.

1. Create a Formula - Text field. To learn how, please see our help topic.

2. In the field's formula box, enter in the following formula, making sure to replace "AppendTightField" with the name of your append field, exactly as it is spelled and punctuated in QuickBase.

NotLeft(Right([AppendTightField],"]"),1)

3. In your reports, remove the append field as a column and replace it with the Formula - Text field. To learn more, please see our Columns to Display help topic.

Your report is now much easier to read now with only the most recent comment visible.