Hey there,
I am trying to create a column 'winddirection' in which I use a list of possible options.
In the 'suggested values' option for the column I use:
LIST(ZW, W, NW, N, NO, O, ZO, Z)
This is giving me an error because the value "N" is not accepted.
Expression '=LIST(ZW, W, NW, N, NO, O, ZO, Z)' was unable to be parsed: Unrecognized token: N.
Also not as initial value.
Why can't "N" not be used as a value.
Solved! Go to Solution.
Make sure each element matches the column base type. (check the base type attribute if an enum or enum list column).
If TEXT, then you will need quotes around each element in the list:
LIST('ZW', 'W', 'NW', 'N', 'NO', 'O', 'ZO', 'Z')
Please try
LIST("ZW", "W", "NW", "N", "NO", "O", "ZO", "Z")
Works like a charm.
Thank you very much
Make sure each element matches the column base type. (check the base type attribute if an enum or enum list column).
If TEXT, then you will need quotes around each element in the list:
LIST('ZW', 'W', 'NW', 'N', 'NO', 'O', 'ZO', 'Z')
Also this works like a charm.
Thank you very much
User | Count |
---|---|
26 | |
25 | |
25 | |
22 | |
22 |