One of the random string IDs I had created as a key for my data was 0e<valid digits>. 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?
Solved! Go to Solution.
In the spreadsheet, try setting the format of the column to Plain text.
User | Count |
---|---|
19 | |
9 | |
8 | |
6 | |
5 |