Condition Enumlist if "Check"

HI Friends, I want to ask you something that is perhaps very basic.

I have a column with all the days of the week from 1 to 7. The field is of type EnumList, Base Type Date

When I display the field I choose the days I want, let's say Monday, Wednesday and Friday, leaving the rest of the days unselected.

When I save, the list of those days appears.

I need to create an expression that searches for the days in the list and then returns a result that is true if it is true and false if it is not.

The days that are true are working days and the false ones are non-working days.

Is there a way to make appsheet understand this?

0 2 79
2 REPLIES 2

I believe your EnumList should be of type Number, not date, and the expression to use should simply be:

IN( WEEKDAY([Date]), [myEnumList] )

No?

Exacto Joseph! Buen día, lo que yo había planteado como alternativa (antes de leer el otro post) es una enumlist con base tipo ref apuntando a días, como los días tenían un Index y ese index era número el label era el día pero cada vez que seleccionaba se seleccionaba internamente un número.  Voy a crear un backup y veo que posibilidades hay de plantearlo tambien así.

Top Labels in this Space