Referencing Formulas in Formulas

:robot: Kuma (Baserow’s AI assistant): often the fastest way to get help. Try asking Kuma before posting here. Available to all SaaS users, and to self-hosted users with a connected AI model.

on

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

Self-hosted

If you are self-hosting, what version of Baserow are you running?

2.3.3

If you are self-hosting, which installation method do you use to run Baserow?

Cloudron - Package version 1.39.0

What are the exact steps to reproduce this issue?

Steps to reproduce:

  • Create a Table A with a Formula field (e.g. CONCAT(field(‘Prefix’), field(‘Number’)) named Device ID)
  • Create a Table B with a Linked Row field pointing to Table A
  • In Table B, create a Lookup field that references the Device ID formula field from Table A
  • Create a Formula field in Table B that references the Lookup field

Expected behavior:
The Lookup field should return the computed string value of the formula field (e.g. C324), and the Formula field should be able to use it as a plain text value.

Actual behavior:
The Lookup field returns the raw object ([{“id”: 14, “value”: “C324”}]) instead of the resolved formula value. When referenced inside a Formula field, it renders the full JSON object as a string rather than just the value.

Additional context:

  • This only occurs when the Lookup field targets a Formula field in the linked table
  • Lookup fields targeting plain text or number fields in the linked table work correctly