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

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

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. The following link explains how to create a field.

https://www.quickbase.com/help/adding_a_field.html

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. The following link explains how to adjust the columns to display in a report.

https://www.quickbase.com/help/edit_view_5_columns.html

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

Tags:

40696 reads

Comments

Last 3 Comments From an Append Field

Submitted by Anonymous (not verified) on Thu, 08/18/2011 - 11:45.

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

see below

Submitted by sshearin on Fri, 08/19/2011 - 13:38.

My comment to Jedd explains how to do this.

Regards,

--Sybil

Show Latest comment, but keep the timestamp?

Submitted by Sheri Auty (not verified) on Wed, 12/02/2009 - 10:53.

Hello,

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.

Last 3 Comments

Submitted by Jedd (not verified) on Thu, 08/18/2011 - 11:49.

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

you may be able to use Part()

Submitted by sshearin on Fri, 08/19/2011 - 13:37.

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.

Regards,

--Sybil

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * 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.

Knowledge Base