Is there a way to take notes on a client that is timestamped, and lasts for longer than a year? The only two options I see are Long Text, which doesn’t timestamp or put last note first, and adding a comment, which doesn’t have any formatting and doesn’t last more than a year.
I think there are a number of ways to do this, but all of the ones I’ve explored are script-based.
I have a client who uses Airtable forms to take notes but the notes arrive in Airtable as new records and ideally wanted the notes to be embedded into a single CRM record over many years (they consult with clients concerning geological changes in soils which are a slow and long process).
To make this work for them, there’s a form that allows geologists to enter notes using a form and the notes are stored in a table like transactions. Then another process (I use Google Apps Script but it could be the new automation script capability as well) transforms each note record into an entry in a long text field that includes the date/time of the note, author, etc. As new notes arrive, the long text field is updated and historical notes are sustained.
The process even supports images that are uploaded via the forms. The URLs to the images are also scripted into the long text field as embedded links for easy reading and access to the different images.
My recommendation is to create a table for just communication and link it to the table(s) that you’re adding comments to. This would allow for better searching and you would never lose any details (past your year).