What's up with Glides AND and OR logic?

[Jeff_Hager]

Completely agree. All IF and Conditional logic in Glide is horribly designed. Can’t tell you how many times people have asked for help with simple AND/OR logic. I have this longstanding Feature Request out there already.

Better and more consistent IF THEN logic

I’ve spent the past few days trying to work out some IF/THEN logic for a side project. The problem is that this is something I could have worked out in a matter of a few minutes with actual code. I’m running into several limitations with the current IF/THEN logic we currently have in Glide. First of all there are inconsistencies between what’s possible with an IF/THEN column, and what’s possible with If/Then logic in visibility conditions or actions. Most importantly, an IF/THEN column only…

Usually the best suggestion is to twist around your logic a bit and kind of reverse it to get an IF column to handle AND mixed with OR. I don’t didn’t like it because it’s hard to follow and maintain it afterwards, but it’s the only solution we’ve had over the years. Unfortunately it doesn’t work for all use case.

For your case, if there was such a thing as ‘Not Within’ then I could get it all into one IF column. Otherwise, short of something hacky like “is included in ‘NewModified’”, I think the best alternative would be to use a javascript column for more complex IF logic.