Strange behaviour when setting EnumList type, base type YesNo in Quick Edit.

1.The table below shows.
1.png

2.[EnumList_YN] is set as follows.
Column type: EnumList
Allow other values: ON
Base type: Yes/No
Valid If: LIST(TRUE, FALSE)
2.png

3.[EnumList_YN] is set to Quick edit columns in the Detail view.
3.png

4.When the actual operation is checked with this setting, the behaviour is very puzzling.
See attached video.
ใƒžใ‚คใƒ“ใƒ‡ใ‚ช2.gif

As the video shows, some values are recorded in the spreadsheet but do not appear in the Detail view,
In other cases, the same value may be entered in duplicate on the sheet.

I consider this phenomenon a bug.

0 5 229
5 REPLIES 5

It does look strange.

However, you do not create an ENUMLIST of type Y/N because that does not really make sense in practice. You select EITHER true or false and never TRUE and FALSE which makes no logical sense.

Maybe you have some cases where this setup is useful. If so, I would be interested to know them.

Maybe you have some cases where this setup is useful. If so, I would be interested to know them.


The answer to the above is a filter dashboard, implemented with a combination of Detail view and Slice, for example, as shown in the video below.
https://www.youtube.com/watch?v=YKE9IKXzuSM 

When I want to implement this kind of implementation, I want to select both TRUE and FALSE.

I had been aware of this strange behaviour for some time, so I dared not use Yes/No for the base type, but used Enum, Text, etc.
I would like this submission to be accepted as a 'bug report'.

 

Ok, I see where you're coming from now and the necessity to use a work-around.

Funny I or anyone else except you never had to use that before..

So you use TYPE ENUM, an allowed list of TRUE, FALSE and do the below meanwhile?

TRUE -> Select TRUE records

FALSE-> Select FALSE records

ISBLANK -> Both TRUE and FALSE records

No.
I do not use the Yes/No type in the search target table (Slice target table).

Then, The alternative values for TRUE and FALSE are then set to the Enum type.
(e.g. "YES", "NO")

In the Search Detail view, the EnumList type sets the choices to "YES" and "NO".The base type is TEXT.

Top Labels in this Space