Create formula to concatenate columns and keep appending new data

Question

In this report, multiple users will be adding a comment for each record.  Last column will save the historical comment data. This column is a concatenation of first 5 columns and keep appending data whenever any new user save comment. I want to create a formula to automatically update the last column. Can this be done in QuickBase? Please advise.

Comment
Date
Added by user
Delegate ID
Delegate Name
Comment Summary

Added new column to the DB
3/23/2022
Mrunali
123
John
Added new table to the DB 3/21/2022 [Deb] 356 Priya]Added new column to the DB 3/23/2022 [Mrunali] [123 John]

------------------------------Mrunali Kadam------------------------------

MarkShnierYou · Answer

It sounds like you just want to concatenate several fields together.List("
 ",ToText([Date]), [Added by User],List(" ", [Delegate ID] & [Delegate Name])If the [added by User] is a User field then it would have to be wrapped like thisToText(User)if [Delegate ID] is a numeric field, the it will have to also be wrappedToText([Delegate ID])------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Comment	Date	Added by user	Delegate ID	Delegate Name	Comment Summary
Added new column to the DB	3/23/2022	Mrunali	123	John	Added new table to the DB 3/21/2022 [Deb] 356 Priya] Added new column to the DB 3/23/2022 [Mrunali] [123 John]

Sign up

Login to the community