Bug in Automations: No boolean combination supported for linked table entries

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What are the exact steps to reproduce this issue?

  1. Set up an automation with a branching element.
  2. One branch has as formula a AND-connection, whereby one field is a linked table entry.
    Idea: I want the “reagenz_filled” branch only to be executed, when linked table column “Reagenz” is filled, and text field “Lot-Nummer” is not filled.

→ Get error:
Value error for edge “reagenz_filled” condition: Value is not a valid boolean or convertible to a boolean.

The solution of the AI was to check if for field Reagenz the ID is > 0, but also this fails.

Attach screenshots, videos, or logs that demonstrate the issue.

Hi @kuechleo!

This isn’t a bug as much as a limitation we currently have in the router condition formulas; they expect a boolean value. In the coming weeks, we are introducing support for more advanced formula functions, two of which would be useful for you: length and empty. With the latter, you will be able to check if Reagenz is empty for example.

A workaround for now would be to have a formula field in your database table that checks for these values being set, and so long as that formula field returns a boolean, you can then use that as a condition of your reagenz_filled branch.

I hope this helps, my apologies for the inconvenience; better functions are coming! :grimacing:

Cheers,

Peter Evans