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 ?
Hi @Anton_Jungreuthmayer It looks like you will need another column or virtual column to do your conversions.
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.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |