Hi!
I’m quite new to Baserow but have 15+ years of experience with dabases and an extensive experience with other no-code database solutions.
I’m trying to do something fairly basic in a formula field: use a series of and/or conditions to determine the value of a status field.
The problem is, AND and OR functions are limited to 2 arguments, which is quite unexpected and forces to add up many AND/OR operators. This renders formulas quite heavy and very hard to read.
Example with a very simple set of AND conditions:
- instead of:
AND(
totext(field('Status'))="Validated",
field('Name')!="",
field('Description')!="",
totext(field('Language'))!="",
field('Rank')>0
)
- we need to write:
AND(
totext(field('Status'))="Validated",
AND(field('Name')!="",
AND(field('Description')!="",
AND(totext(field('Language'))!="",
field('Rank')>0
))))
Is there a plan to support more than 2 arguments to AND and OR functions in the future and avoid impossible formulas with dozens of operators?
Best,
Ludo