We’ve been using a single line address field for our job locations for years. This has allowed us to have a clickable address that technicians can select for a mapping program. We are interested in expanding this field to it’s components: Street Address, City, State, and Zip Code. Then using a formula to combine the components to a clickable address in a read only field. This change will allow us to sort projects by city/states/zip codes and to mail merge the components in a more useful manner.
However, we have 20,000+ records without the components. If someone were to press “Apply all formulas on this sheet to saved records” during future development, or if someone were to enter data into the components and save an older entry, the existing address will be deleted.
Can we lock all entries all entries with this older feature to prevent this accidental overwriting of Job Location, or at minimum, prevent entry into the component fields for a range of entries?
Or is there another way we can implement this change without future risks of overwriting old addresses?
I will gladly offer more details to solve this problem.