How Can I Change A Field for only Future Records (not affecting current records)?
Sorry if this has been answered somewhere but I tried searching and couldn't find it.
I have some price changes on our services and I'm wondering how to change the price on one product moving forward so it doesn't affect our current / previous clients. For example, our "Product A" has always been $500, we are now changing it to $650 moving forward for new clients. But when I change the amount to $650, it changes all our previous clients amount too which in turns shows that they have a remaining balance of $150 now. How do I just change it moving forward without affecting current & previous clients?
We are using a calculation field that says; If ( Product A = "Yes" ; 500 ; 0 )