How to remove Enum comma in Number data type

AppSheet AppSheet Q&A
1

Hi

I need help.

I have a CSV file that will be uploaded regularly which contains the Year column in number type. In the app Year is an Enum Number data type. But by doing this thousand separated comma is automatically added.

Is there a way to go about this without changing the data type to text in CSV or in the APP?

2

Mayura_0-1704174478381.png

Want the comma removed in the UX

3

Does it save the separator to your data source?

4

No it does not. Only in the app we can see the separator

Mayura_0-1704181788449.png
Mayura_0-1704181788449.png131×355 685 Bytes

5

@AleksiAlkio Will you be able to help me here?

6

In the beginning when you added the value directly through the app without any CSV import, was it showing the number without the separator? What happens now if you add it through the app?

7

In the app also it shows with a separator. Since it an Enum

Mayura_0-1704272764548.png
Mayura_0-1704272764548.png1920×1080 306 KB

Mayura_1-1704272823927.png
Mayura_1-1704272823927.png1920×1080 312 KB

8

Have you tried to use a different locale settings with the CSV import?

9

I tried changing locale setting. It doesn’t solve the issue. :frowning:

10

This may be a dumb suggestion, but have you tried putting the Enum values in quotes?

11

I found a solution for this. Writing the solution for others to see.

Add a new table with the ID as list of year.

Use Enum and Base type make it Ref and reference the year table. This solves the issue.

Mayura_0-1705400496087.png
Mayura_0-1705400496087.png963×730 25.9 KB