Currently, when a change is made to a project custom field, all data in that field is wiped out of active and historical projects. Ideally, the system would prompt the user if they want to replace or retain historical data.
For example, we currently track if Profile Center is proposed on a project (field is "Is Profile Center included?" With the name change from Profile Center to Trust Center, I want to update the field to say "Is Trust Center included?" but if I do so, all historical projects will lose the data previously captured. I would like them to keep that data since the answer would still apply, its just the product name that's changing.
If the system prompted the user if they wished to retain the existing data or delete it, they could choose accordingly. Vs. just wiping out the data which means I have to go back and update each historical project manually.
