Greetings,
First of all - huge thanks to all developers for creating and supporting such an amazing tool. I’m building a very niche database to automate & control a couple of specific processes in my department, and Airtable is a not a viable solution simply because we need to have the self-hosted flexibility. Baserow’s closest competitor NocoDB is a bit unstable and clunky for our purposes (which among other things involve a great deal of duplicate many-to-many relationships which still don’t work as intended in NocoDB).
My question concerns fields set up as “Link to table” type, and how formulas in other fields referencing this “Link to table” field operate when the “Link to table” field is empty.
As an example, I have a table with a couple of fields.
- One of the fields named “Territory” is of the “Link to table” type, linking to another table with a list of countries.
- The next field (named “Availability”) has a simple formula checking whether “Territory” field has any values in it: isblank(field(‘Territory’))
It seems that the formula field works just fine when anything is linked from another table in the “Territory” field, displaying a red cross. However, when the “Territory” field is empty, the green tick is not displayed in the “Availability” field which I suspect means the formula returns an error.
Is this something that is planned to be addressed in future updates?..
Thanks,
Andrew