Forum Discussion

JeremyShearouse's avatar
JeremyShearouse
Qrew Trainee
7 months ago

Impact to existing data by changing a field from a radio button selection to a formula?

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.  

     

    • JeremyShearouse's avatar
      JeremyShearouse
      Qrew Trainee

      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.