Forum Discussion

RebeccaLutz's avatar
RebeccaLutz
Qrew Trainee
12 days ago

If / or statement

I want to "lock" the data in a section of a form, but have the ability for one role to override the lock.  

If the Manufacturing Start date/time field is empty, I would allow editing: 

OR if the QA Manufacturing Start Comments field is not empty, I would allow editing in the section

I have in the expression builder:

IsNull([Manufacturing Start]) OR Not ISNull([QA Manufacturing Start Comments])

Then:

Make editable: Section

But I am getting an error on the "OR". It says that there are extra characters beyond the end of the formula.

What do I need to do to fix the formula?

Thanks!

Becky

 

  • Assuming that Manufacturing start is a date or datetime field and QA Manufacturing Start Comments is text,  try this formula instead:

    isNull([Manufacturing Start]) or [QA Manufacturing Start Comments]!=""

    For text you can't use isnull/ not isnull.