How I can prevent user to change data in the past?

2.10K viewsTips and Techniques
0

I want to lock cell and don’t allow anyone to change it. For example, when we begin a new month, I want the program will automate lock the planning data in the past and it can’t be changed. How I can do that?

Answered question
0

Hi – Sorry this was not answered sooner. However, there is not auto-locking feature in Quantrix. However, you can certainly set up a time control in the model that detects if a month is in the ‘actual’ period… then use the actual numbers. Otherwise, refer to some type of “forecast” item to get that forecast or planning number.

Answered question
You are viewing 1 out of 2 answers, click here to view all answers.