UNWANTED COMMAS IN ENUM LIST

[Lindsey_Lindow]

In a vehicle repair app, column [YEAR] is an enum column (base type: number). When opening the form to select the vehicle's year, unwanted commas are showing for each selection. For enum columns, the option to show or not show commas is not present. How can I make the commas not show in the dropdown list items? I have tried changing the base type to text instead of number, but then one of my automations will not work.

[WillowMobileSys]

---

@Lindsey_Lindow wrote:

I have tried changing the base type to text instead of number, but then one of my automations will not work.

---

Why won't it work?   You can use the NUMBER() function to treat the Text value as a number - NUMBER([Text Value]).

[Lindsey_Lindow]

With the Enum base type set to Text, I tried the following initial value expression:

IF([INVENTORY TYPE] = "NEW", NUMBER(YEAR(TODAY())), "")

With this expression, I received the following error:  "The expression is valid but its result type 'Number' is not one of the expected types: Enum".

The expression works if I change NUMBER to TEXT, but then the unwanted commas are showing.

[SkrOYC · Accepted solution]

IFS(
  [INVENTORY TYPE] = "NEW",
  TEXT(TODAY(), "YYYY")
)

[Lindsey_Lindow]

Your expression worked perfectly. Thank you so much!