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...
Can we write formula to keep appending new data one after another? (see below screenshot) Multiple users will be adding comment for each record. Current formula concatenates as expected but it refreshes data if we change user field or comment etc. If user1 saves any comment and then user2 adds something then would like to see it gets appended to the existing concatenated string. so all comments can be saved in a single cell.
Can this be done in QuickBase?
If not then is there any way to make formula field non-editable? so we can ask user to manually edit this column.
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 ------------------------------
