Hi all,
I use AppSheet to enter and track a plant nursery inventory. I have a column “Transplant Code” that will usually be filled by numeric values, but occasionally there are situations where a number is not required, or the number is unknown. As such, I would like the field to remain numerical, but have an exception to allow the following character values: “unknown” and “null”, as well as allow for multiple codes to be input, comma separated. My current setup is to have this column type set as “EnumList”, where I have “unknown” and “null” as Values, and then I’ve toggled the “Allow other values” with “Base type” set to number and “Item separator” input as “,”. This generally works as intended, but users can still add non-numerical values and I would like there to be stronger constraints. Basically, I would like to have “unknown”, “null” and any comma separated numbers as the only acceptable non-numeric values. Is this possible or am I asking too much? Help is appreciated. Thanks!