Field with Multiple Conditions

Question

Can I have multiple conditions on a field. For example

CONDITION 01

if the field is empty change the value to "No".

CONDITION 02

Only allow certain users to change the value to "YES" For this condition what would the code be?

hasChanged(FIELD):true AND FIELD:2 AND USER = 01 OR USER = 02 etc.

Do I put the conditions in their own rule (ie two rule fields) or do I have to set both conditions in the same rule separated by a ; or something?

Barry Smyth · Answer

So I think this is the condition I need to put but it would be good if someone can verify.

hasChanged(FIELD):true AND !FIELD:[01] AND [entry._user]:123456 OR [entry._user]:654321

the condition means that only the two specified users can change the field to anything other than 01. Meanwhile everyone else can change it to 01.

Barry Smyth · Answer

Creating a group is out of the question, there's so much red-tape around that internally that it would take weeks to setup assuming it got approved.

The first condition is easy, I already have it as a rule on the field. Basically it tests if the field is empty and is so defaults to a chosen value. So no issues there.

The 2nd condition needs some thought. It needs to be something like

Field change = True AND

Field Value !=01 (i.e. not equal to the first field value) AND

USER_ID = 123456 OR 234567 OR (etc.)

In other words the condition means only certain people are allowed to change the value of the field to anything other than 01

Ben Finn_jtpbl4 · Answer

I just noticed you posted this in Confluence. Could you give some more details about the field changes you are talking about.