Hello Pigment Community,
I just want one option to be marked, if suppose Absolute is checked, then the other options (Percentage and fixed) cannot be checked. How can I do this?
Please kindly guide me to perform this operation. Thanks a lot!
Hello Pigment Community,
I just want one option to be marked, if suppose Absolute is checked, then the other options (Percentage and fixed) cannot be checked. How can I do this?
Please kindly guide me to perform this operation. Thanks a lot!
Hi
To achieve your goal, you will need to leverage Access Rights (AR). Here's a step-by-step guide:
You can use the ACCESSRIGHTS
function with the following formula:
ACCESSRIGHTS(truerADD: User,Options] , 'Radio button T/F'/ADD: User])
TRUE
for all users.'Radio button T/F'
, dimensioned by your Options dimension. Use the formula:IF(
'Radio button selection'oREMOVE ANY: Options] = FALSE OR
ISBLANK('Radio button selection'oREMOVE ANY: Options]),
truerADD: Options],
'Radio button selection'
)
This formula checks two conditions:
FALSE
value: 'Radio button selection'oREMOVE ANY: Options] = FALSE
ISBLANK('Radio button selection'oREMOVE ANY: Options])
If either of these conditions is TRUE
, write access is allowed for all options :
the AR metric would be:
.Otherwise, write access is granted only for the selected option.
The AR metric would be:
Once configured, apply the AR metric in the Data Access Rights section.
For more information on implementing AR, refer to:
Create an Access Rights Metrics and Rules
Hope this helps,
Issam
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.