Hi Everyone,
I have a column with the ‘Number’ type. However, when I update the value in this column, I get an error saying ‘Cannot be converted to type “Number”’. I also tried using the ‘Decimal’ type, but I encountered the same error. (I am using MySQL)
I think the error details are indicating that the update operation done on the record seems to be adding a date value to the number column.
Please look into why that is happening. For example is the backend data source column set to date type by any chance?
I am setting the Number/Decimal type in both AppSheet and MySQL. However, when I update the number value, AppSheet automatically converts it to a Date type and shows an error.
I have a feeling the number you entered is being referenced to as eg. row_number and its fetching the date recorded in the entry, i might be wrong…
I don’t use any formula and don’ t use any Ref. I am thinking the issue at Quick edit columns function.
any data validation rules in place that is messing with the quick edit?
Please post a screenshot of the column’s configuration including the entire Type details, Data validity, and Auto-compute sections.
