Solved: Help with Enum data type using Percent as base typ... - Page 2

Hamlet · 07-03-2021 09:18 AM

Hello all,

I have a strange thing happening and can’t figure it out. Need some help. I have a Column Type Enum that has some choices for values that need to be presented as Percent, so I have selected Percent as the Base Type.

The issue is that some of the values do not show up as selected when viewing the record in Form View and other values do show up as selected. All other functionality using these values is working as expected.

Attached images of what it looks like in Form View and the corresponding screenshot of the data in the table showing the values of the field.

Thanks in advance!

Marc_Dillon

That’s odd. Could be a bug.

Let’s try a couple other things though:

Make all of your Enum selections the full 3-digit representation. So 1.00, 0.20, etc.
In your GSheet, select the values and format them as “plain text”, then report back what the actual data values are in both the working and not-working cases.
You could try to use Percent column type, instead of Enum, then provide the following expression in Valid_If or Suggested Values
LIST( 0.00 , 0.02 , 0.10 )

View solution in original post

Help with Enum data type using Percent as base type