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?
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í.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |