Skip to main content
Question

If / or statement

  • Jan 31, 2025 10:55 PM UTC
  • 0 replies
  • 173 views

Forum|alt.badge.img+3

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

 

SSNJeffP
Forum|alt.badge.img+11
  • Qrew Colonel
  • Feb 1, 2025 12:40 AM UTC

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.