Enum initial value set to "no". not working

AppSheet AppSheet Q&A
,
1

hi all ,

i have a column (date type: enum),I tried to set the enum field with initial value as =“no” but seems like its not working. im assuming that will make all the empty (blank fields) - it will set =“no” and that way i dont have blank in the display. in chart;

sandeepraon_0-1684426069183.png
sandeepraon_0-1684426069183.png327×234 6.38 KB

sandeepraon_0-1684425613257.png
sandeepraon_0-1684425613257.png509×278 9.35 KB

seems like that’s somehow is not setting. is there any other way to set the column for enum type initial value to “no”.

2

Initial value

ANY(LIST(“No”))

3

Please note that initial value will work only when user is adding a new record.

It works on existing records, if " reset on edit" is set up and the user opens the record for editing.

Please check whether you are expecting " initial value" to take effect on existing records. It will not work if " reset on edit" is not set on existing records.

Please check by adding a new record and " initial value" should work.

Define App formulas and Initial values - AppSheet Help

Suvrutt_Gurjar_0-1684428667648.png
Suvrutt_Gurjar_0-1684428667648.png1026×129 18.6 KB

2 Likes
4

Thanks for both of you : @Suvrutt_Gurjar @Izzat_Safrah

unfortunately That’s not going to work for my use case and probably is a limitation for the existing rows.

so Tried to figure the solution : created a virtual column , made it as Enum type

Formula: IF(ISBLANK([columnName]),“no”,“yes”)

and used the virtual column in the display on piechart to get rid of the blank

2 Likes