302 Found

Found

The document has moved here.

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

https://www.quickbase.com/user-assistance/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/user-assistance/edit_view_5_columns.html

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

Comments

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.

Regards,

--Sybil

Show Latest comment, but keep the timestamp?

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.

Recent comment with time stamp

Sheri,

 

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.

Regards,

--Sybil

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.
302 Found

Found

The document has moved here.