can I make a rule to lock a cell

[dumbomichael]

hi Guys

i have a drop down box with a list of options the user can choose on aa active form. i would like the cell to be locked if they choose 'appointment'. ie. they can select any option they want and change it, but if they select appointment, they cannot write back any information to that cell only. below is the rule i have done.

['result'] = S:if(DB('Suspect Capture',!Sales - Campaign, !Prospect Owner ,!position, !sic code, !Location, !contact person, !Suspect name, !ki Reference,'result')
@= 'Appointment' ,
read,
continue);

i have tried lock as well instead of read, but it keeps giving me an error. if i put ' ' around read or lock, the error disappears, but then when the user selects appointment, it changes to read or lock, so thats not what i need.

any suggestions?

[declanr]

hi Guys

i have a drop down box with a list of options the user can choose on aa active form. i would like the cell to be locked if they choose 'appointment'. ie. they can select any option they want and change it, but if they select appointment, they cannot write back any information to that cell only. below is the rule i have done.

['result'] = S:if(DB('Suspect Capture',!Sales - Campaign, !Prospect Owner ,!position, !sic code, !Location, !contact person, !Suspect name, !ki Reference,'result')
@= 'Appointment' ,
read,
continue);

i have tried lock as well instead of read, but it keeps giving me an error. if i put ' ' around read or lock, the error disappears, but then when the user selects appointment, it changes to read or lock, so thats not what i need.

any suggestions?

Where have you written this rule? In a cellsecurity cube?

You do need to put in a security cube of some sort, I would expect it can be done at element level security instead of cell level but would need to know more about the rest of your model.

Edit - and in security cubes you would need to use @='READ' etc as opposed to READ without any quotes.

[dumbomichael]

hi

sorry, it was a silly mistake on my part. i put it in the cell security cube and it's fine. i did the test on it when it was in then data cube. rookie mistake. thanks for your help