Keep getting "Error with formula: text is not a valid function" error

Technical Help
1

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

SaaS

What are the exact steps to reproduce this issue?

  1. Edit field in table
  2. Select ‘Formula’ as the field type
  3. Click ‘Generate using AI’
  4. Put in the prompt “Create a goods receipt reference like GR-0001 using the autonumber field called ID” (I left all other fields as is)
  5. It creates the following formula: concat(‘GR-’, right(text(field(‘ID’)), 4))
  6. I click ‘Save’
  7. I get the error “Error with formula: text is not a valid function.”

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

Screenshot 2026-05-13 123859.png
Screenshot 2026-05-13 123859.png675×616 27.9 KB

2

Hey @markusername, can you try this one:

concat('GR-', right(concat('0000', field('ID')), 4))

3

Yep that worked perfect. Thanks @olgatrykush !