It is possible to configure enumlist Usersett...

(Arnaud B.) #1

It is possible to configure enumlist Usersettings() to filter many Year in a table ? If Yes, how to ?

(Levent KULAÇOĞLU) #2

@Arnaud_B can you elaborate your question? What do you mean with " many Year in a table "?

(Arnaud B.) #3

A User settings that select many year (2016, 2017, 2018) or single Year 2016 … One Enumlist in usersettings …

I’ve try in condition of slices but doesn’t work: YEAR([Date]) = USERSETTINGS(Year_Option)

(Aleksi Alkio) #4

You could use IN expresssion… like IN(YEAR([Date]),USERSETTINGS (Year_Option))

(Arnaud B.) #5

THX it work. One more expression problem to list YEAR Date

=SELECT(YEAR([My_Date]), TRUE) return that parameter 1 in YEAR function is invalid … and if i’ve many 2016 or 2017 or, … how to filter list to have just one entry of each

(Aleksi Alkio) #6

Would you please describe your case little more… I didn’t understand the reques totally, sorry.

(Arnaud B.) #7

I’ve set a usersettings Enumlist with Year Date. I can now filter with the expression u give me.

But i need one app formula in my usersettings Enumlist field to list Year Date from my column.

But , if i have many same Year in my column, i don’t want to see

2016 2016 2016 2017 2017 2017 2017 2017 … on my button enumlist … U understand ?

(Aleksi Alkio) #8

How about TableName[YearColumn]

(Arnaud B.) #9

@Aleksi_Alkio this expression in app formula to get list of Year ??? Mean it was =select(… to have a list ?

(Aleksi Alkio) #10

TableName[YearColumn] is basiacally the same than SELECT(TableName[YearColumn],TRUE,TRUE). When you want it as a dropdown list, you need to type it into the Valid_If.

(Arnaud B.) #11

Thx ill try