Skip to Navigation

Knowledge Base

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.


Last 3 Comments From an Append Field

Is there a way (formula) to display only the last 3 comments from the append field?

see below

My comment to Jedd explains how to do this.



Show Latest comment, but keep the timestamp?



This is a great little formula. Is there a way to adjust it so that it captures the timestamp as well? Currently, your formula only shows the latest text. Thanks.

Recent comment with time stamp



I did it like this:


"[" & Part([Notes],2,"[")


Where Notes is a field that prepends.

Last 3 Comments

Is there a way (formula) to display the last 3 comments from the append field?

you may be able to use Part()

Yes, there is. The Part() function sees the value of a field as a series of "parts" which are delimited by one or more characters you specify. Use Part([AppendField], -3, "[") & Part([AppendField], -2, "[") & Part([AppendField], -1, "[") to get the last three comments from a field that appends to the bottom of the field. Use positive numbers in the formula to get the most recent three entries if the append field appends to the top of the field.



Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit