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 | |
30 | |
29 | |
22 | |
18 |