I have a Project database with a field for each entry called “Historic Updates.” I try to write things as they happen in this field, with a date stamp.
I do a pretty good job of updating those things while I’m in the project working. But sometimes, like with emails, I just need to drop a quick update without much friction - going to find the project, then clicking on the rich text field, then clicking on the popup pane is too much friction in this case.
So I created another database called “Personal Work Updates” that I figured I’d just drop notes in as I went, then have my Assistant manually add those updates later on to each task.
But it occurred to me: what if I could just write the update, then later simply assign a project to each update and that assignment would then force the rich text update to apply to that first database field?
I fear I didn’t describe that well enough - and I know the simple solution sounds like: “create a new database called “Historic Updates” and just write stuff there then assign to projects.” But… I dunno - I prefer the idea of the updates being embedded in each project as a rich text field - not as a series of relations. ¯_(ツ)_/¯
I realize to do this would also mean to override whatever existed in the rich text field originally. So maybe this is a bad idea overall, but perhaps it could be useful for other field types?
Thanks in advance!