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

3.12K viewsTips and Techniques

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?

Tahir Answered question April 1, 2019

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.

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

Latest Questions