Enum dropdown in Form populates a " ' "

AppSheet AppSheet Q&A
1

I have an Enum dropdown set-up that allows me to put in a number between 1 - 100

When I put my entry in, it populates in my app just fine. Let’s say I put in “8”

I go check the data in Gsheets, and the entry is " '8 "

Which of course won’t work to do formulas. Does anyone know how to fix this?

2

Please try to have the base type of the enum column as “Number” and in the Gsheet please format the corresponding column as 'Number"

2 Likes
3

3X_5_7_57c07bbd4620dc9cc7a4c219b485bc6f590a8417.jpeg
3X_5_7_57c07bbd4620dc9cc7a4c219b485bc6f590a8417.jpeg784×1067 161 KB

Hello. I have done so, but still, the numbers I put into my Form show up like this in the Gsheet.

4

I figured it out. Thank you.

1 Like
5

Great. May we know how you solved it?

2 Likes
6

It was exactly as you said but I hadn’t deleted the data from my app and re-added it, so the format changes to “Number” hadn’t taken place

3 Likes