I’m having an issue with one of my apps with a couple fields, of data type “Number.” When the user modifies these fields, and then saves, the fields will briefly show as a date, corresponding to the number input, as if it was reading it as a data type “Date.” It shows this for a couple of seconds and then switches back to a number. Not a big deal, unless the user moves on before the data reverts back to a number type. If that happens, it causes a sync error due to data type difference, and the user can no longer save any data. Any ideas what could be causing this? I’ve checked that both the appsheet and the google sheet source data table are formatted for number.
That there is a delay before the change suggests the change is tied to a sync. That the display format changes and at one point it doesn’t reflect the input column format suggest two things: the displayed value is from a column that is not the input column, and that column providing the displayed value is a virtual column or is a non-virtual column that is updated by a bot during the sync.