Hi,
I have a field in a model that needs to be set as read only apart from when one condition is met when users will then need to edit it. Whats the best way of going about this?
Thanks,
Make 2 fields and read data from override field on condition
YKUD-
For clarity, is what you mean, create an if-then formula involving at least three fields (override field, reporting field, data field)?
Example
Reporting field formula:
if(criteria is true, then take data field value, otherwise take value from override field)
The field that contains this formula (reporting field) will always be read only. The override field is always writeable, but data will not flow through unless criteria is met.
There is no way that I am aware of to edit read/write access on the fly through contributor web grid. It is handled within the CAC. There is data validation functionality in version 8.2 and higher, but I don't believe it can be used to affect read/write access.
Yes, you got it right, I was talking about setting up a condition.
The version 8.2+ validation functionality in the admin console might also be a valid way of checking the 'consistency' of the users entries.
You can set up read only status bu using D-links. Use a conditional calc based on the contents of the criteria field. D-list format this Conditional using a flag. Include this flag in the dimensions of the cube. use an accumulation link to target the cell you want to be read only.