Bug in row update: Number seen/treated as Date?

[Sirotti]

I have a simple app that’s used by our vendors to request quotations of incoming used vehicles.

One of the field is the wheelbase, “PASSO”. It’s defined as a number and always used as a number

But sometimes (I haven’t been able to figure out why) Appsheet seems to think it’s a Date, and stops updating the relevant row

It look like a bug and it’s quite hard to reproduce (we have entered 30+ rows with no errors), so can anybody give me some suggestions? I can try to work around it, but it’s quite annoying as it’s unpredictable and stops the user from interacting with the app.

[WillowMobileSys]

Check the data type assigned to your sheet column. I always make ALL the columns “PlainText” and not automatic. Automatic causes issues when certain values are stored into the sheet.

The sheet attempts to automatically convert the values into the data type it THINKS that is needed. Dates, in automatic form, are stored as Integers and then the Date value upon retrieval is calculated as an offset from 1/1/1900. I think this is what has happened in your case.

ALWAYS set your sheet columns to “Plain Text” before you start building to avoid these issues. It is okay to set all the column to “Plain Text” right now but any column data already translated might need to be re-entered.

I hope this helps!

[Steve]

I agree.

[Sirotti]

@WillowMobileSys

The sheet attempts to automatically convert the values into the data type it THINKS that is needed. Dates, in automatic form, are stored as Integers and then the Date value upon retrieval is calculated as an offset from 1/1/1900. I think this is what has happened in your c

Thank you, I’ll try that.