Bug 1 — Switching a field from Basic mode to Expert mode silently corrupts formulas containing function syntax, with no error shown

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?

Repro: in a Basic-mode field (e.g. a Row ID field), type a formula using function syntax, e.g. if(and(1=1,2=2),1,0), then click “Switch to expert mode.” Result: the entire field content gets wrapped as a single string literal — ‘if(and(1=1,2=2),1,0)’ — instead of being parsed/preserved as a function call. No error or invalid-formula banner appears; the result is syntactically valid, so this is easy to miss and can ship silently broken automations. Workaround: avoid switching Basic→Expert once a formula contains nested logic or function syntax — write complex formulas entirely in Expert mode from the start.

2

Hey @Nedrob the issue here is that functions like IF and AND aren’t supported in Basic mode. Basic → Expert generally works for functions that Basic supports, such as get and concat, but formulas using other functions can’t currently be converted properly. For now, the workaround is to enter those formulas directly in Expert mode.