Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.
How do I show only the most recent comment from an append field in my report?
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.
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.