Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
It seems to me that you want the checkbox which triggered the Automation to be read only
"When Multiple Conditions are true" ( thais one of the drop down options)
When all of the following are true
The user is in the Role Director Of Design
The checkbox is not checked
Food service is not blank
Interior designer is not blank
Estimator is not blank
The only problem Kee with the above is that there many be multiple high level Roles, which includes Admin, and includes the Director of Design Role, so the Admin may need to also be in that high level Role as well.
"When Multiple Conditions are true" ( thais one of the drop down options)
When all of the following are true
The user is in the Role Director Of Design
The checkbox is not checked
Food service is not blank
Interior designer is not blank
Estimator is not blank
The only problem Kee with the above is that there many be multiple high level Roles, which includes Admin, and includes the Director of Design Role, so the Admin may need to also be in that high level Role as well.
- IvanWeiss6 years agoQrew CaptainWhere am I placing this checkbox is read only when multiple connections are true? I went into dynamic form properties thinking it is there. But, there is no blank option on the users. Seems like what you are referring to is elsewhere
- QuickBaseCoachD6 years agoQrew CaptainOh right, I think I have run into that issue before. Try creating a Formula User field called
Blank User
And just leave the formula blank.
Then in the form rule refer to those user fields being equal to the value in the field Blank User - IvanWeiss6 years agoQrew CaptainThat worked, thanks!