0

freeze data in a field

Hi Folks, I'm sure this has been asked about before but none of the solutions are working for me.

Simply put, I have a formula field that is calculating based on 2 number fields on separate tables.

The calculation is fine but I want to preserve the answer and not have it affected when one of those number values is changed on a future record.

A trigger after update at the table level is copying the result from the formula to a number field which is set to only be writable if null but the formula output is of course, not affected by this lock out.

The simplest way I can describe this, I want Ninox to be a printing calculator and no matter what I change in the calculation, the previous print out can not be altered.

Any advice?

Many thanks 

1 reply

null
    • Fred
    • 6 hrs ago
    • Reported - view
     said:
    I want Ninox to be a printing calculator

     I'm not sure what that means. Are you creating a new record in a table every time you change values? If not then where do you want to store the data with every change?

    What is your work flow? Once we know that then we can figure out ways to make sure things don't get overwritten.

Login to reply

Content aside

  • 6 hrs agoLast active
  • 1Replies
  • 14Views
  • 2 Following