OR function allowing multiple argruments

Feature Ideas
1

Not sure if this is a bug or a feature idea. Decided to post here since the error message I’m getting suggests it’s working as written.

I’d like to write an OR function that checks multiple fields and returns true if any of them are true. Per the 20 Essential Baserow Functions post, the OR function should be able to evaluate multiple conditions. However, when I try to use OR to check 3 different fields, I get:

Error with formula: 3 arguments were given to the function or, it must instead be given exactly 2 arguments.

For what it’s worth, the specific thing I’m hoping to check is:

if(or(field(‘Break Adj?’)=“Yes”,field(‘Shift Adj?’)=“Yes”,field(‘Meal Adj-A?’)=“Yes”),“Yes”,“No”)

I’m a long-time spreadsheet master that’s still pretty new to databases… thanks in advance for any help!

2

Hi @olive2punk,

you will need to wrap the third argument in another OR, like this:

if(or(or(field('text')='true',field('text2')='true'),field('text3')='true'), 'Yes', 'No')

Meaning that the or() function only accepts 2 arguments, as described in the article’s example and in-app help.

To your point: yes, this is then a feature idea, we can keep it here for the upvotes!

3

Thank you! I figured that might be only only option for now but wanted to be sure I wasn’t missing something.

4

Hey @olive2punk, we also created an issue to make the OR function accept multiple arguments: OR function in Formula field to accept multiple arguments · Issue #4660 · baserow/baserow · GitHub

Thanks for bringing this up!

5

Yay! Thank you so much :grin: