This is probably common knowledge but I'm having trouble finding the answer. If I change an existing field entry on a form from a radio button selection to an auto-populated field based on a formula, will only new entries be affected or are there other considerations I should be aware of to ensure I don't lose historical data?
If you change your data entry to a formula field then you will lose the historical data entry information.
I suggest you do is to maybe rename that field to suffix it with the word (phase out), and then use a Forum rule to hide that field unless it is already populated. Then you could have your formula field take into account if that field had a value in which case to use it else continue on with the formula field.
Ok, thanks! I'm really glad I asked as I had nearly convinced myself to go ahead under the assumption that my existing records wouldn't change.
