Formula- issue with Concat & space in column name [Jul 14]

Discord-Discussions
1

:raising_hand_man: edon asked

Hello - big fan of your project! Currently migrating an airtable and working on rebuilding formulas. Having issues with it not being able to validate column names that have spaces in them, sucha as “Item Name”. formula CONCAT({Item Name}, " SOLD OUT") for example would get me validation error “Column 'Item ’ is not available”

2

:man_bald: dstala replied

<@306585454507982849> please help us with your project configurations (open project, right top menu, copy project info).

3

:man_bald: dstala replied

I tried with following project info, worked well

Node: v16.14.0

Arch: arm64

Platform: darwin

Docker: false

Database: mysql2

ProjectOnRootDB: true

RootDB: mysql2

PackageVersion: 0.92.3

4

:man_bald: dstala replied

& do specify the type of the field “Item Name”

5

:raising_hand_man: ideeb replied

Copy project info only gives me: keyQBkWiM6kQde8Wp

6

:raising_hand_man: ideeb replied

I’ve tried it with, text, numbers, and lookups with no success

7

:man_bald: dstala replied

strange. what version of nocodb are you on? you can hover around nocodb logo to find it out.

8

:raising_hand_man: ideeb replied

0.92.3

9

:raising_hand_man: ideeb replied

Node: v16.15.0

Arch: x64

Platform: linux

Docker: false

Database: mysql2

ProjectOnRootDB: false

RootDB: mysql2

PackageVersion: 0.92.3

10

:raising_hand_man: ideeb replied

Both issues stemmed from using safari – :speak_no_evil: no problems on chrome

11

:man_bald: dstala replied

> Both issues stemmed from using safari – :speak_no_evil: no problems on chrome

ah, thats interesting.

12

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs