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?
Question
Impact to existing data by changing a field from a radio button selection to a formula?
+2This topic has been closed for replies.
+22If 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.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.