Google spreadsheet backend treating a string starting with 0e as scientific notation

[anonymous]

One of the random string IDs I had created as a key for my data was 0e. When Appsheet API stored this in Google Spreadsheet it interpreted this as scientific notation and turned it into the number 0. Is there any fix around this?

[dbaum]

In the spreadsheet, try setting the format of the column to Plain text.

[anonymous]

Thank you. I was looking for that option and couldn’t find it. Would be nice if a type consistency option is added to Appsheet to enforce the type across the backend.