Forum Discussion

MrunaliKadam's avatar
MrunaliKadam
Qrew Trainee
4 years ago

Create formula to concatenate columns and keep appending new data

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 w...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
If you wanted to keep appending when the record is changed, then you would need to create a multi line text field and set logging on.  Then use an Automation a Pipeline to update it when the record is saved.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
MrunaliKadam's avatar
MrunaliKadam
Qrew Trainee
4 years ago
Thanks Mark! I created multi-line text field and set logging on. I haven't created any pipeline yet so learning how to create it.

thanks again!

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