- I have a Date Field (Field A) for the date I last wore an outfit: “7/28/2018”
This changes regularly; I change it each time I wear an outfit.
- I have a Long Text Field (Field B) I use for ongoing Notes on where I wore the outfit: “Special dinner XYZ”
I add to this, but do not remove data.
I need two fields:
- Field C: An ongoing, static text list created from the Field A information, including each time I change it. So, each time I change the date in Field A, it adds that date to the list in Field C: “7/28/2018, 8/01/2018, 9/15/2018”
- Field D: A combination of Field C and Field B, ongoing-style: “7/28/2018: Special dinner XYZ; 8/01/2018: Family reunion” etc.
As far as I can tell, such a thing is not possible because the Date Field cannot cause another field to statically concatenate; once that date changes, the field reading that date must change, it cannot “store” the first date entry, and build upon that each time you change the Date Field.
Obviously, if there is some MUCH better way to do this, that doesn’t involve what seems like impossible fields/formulas, please let me know! I cannot think of a better (non-manual) way to have this information updated and tracked.