Google Sheets - Formula in Display Column creates error

[OneUglySquatch]

• I have searched budibase discussions and github issues to check if my issue already exists

• Cloud

  • Tenant ID: gohlowbed

Formula column set as Display Column will cause an error with Google Sheets as data source.

Steps to reproduce the behavior:

1. Link Google Sheet
2. Create new formula column with a text format and combine 2 or more other columns: {{ Last Name }}{{ First Name }}
3. Set the new column as Display Column
4. Switch to another table and return to this one.
5. Error on screen preventing any access to table. Have to delete entire DB source to clear the issue.

To operate as other data source. Tested with Sample DB and internal DB and worked as expected

• OS: Windows 11 Pro
• Browser Chrome
• Version 127.0.6533.120 (Official Build) (64-bit)

[linear]

BUDI-9012 Google Sheets - Formula in Display Column creates error