Having a problem with a column called [sales_...

[Parkdean_Resort]

Having a problem with a column called [sales_van] stored in my database as a 0 or 1.

Basically I want to be able to store a 0 or a 1 but ask the user to specify “sales” or “fleet”.

I figured I’d use a y/n column but I cant find a way to change the labels from “Y” and “N” to “sales” and “fleet”

I’ve tried defining the column as enum with 2 values “sales” and “fleet” and changing the base type to “y/n”. Works ok in the app but fails when it syncs with the message

Value ‘Sales’ in field ‘sales_van’ cannot be converted to type ‘Enum’.

Any ideas ?

[Lynn]

Hi @Anton_Jungreuthmayer It looks like you will need another column or virtual column to do your conversions.

[Aleksi_Alkio]

Or you can create a small additional table and call it with the Ref type column. You can show the value “Sales” but it will write 0 or 1 into your sheet.