Table slice by user settings. I use usersett...

(tsuji koichi) #1

Table slice by user settings.

I use usersettings as filter to slice the table.

Usersettings has Ref type, and user select items to custom filter to show some views.

What the problem is when the usersetttings is left untouched (or none is selected) we could not pick up any row out of table. What i wish to do is to show all if none of usersetting is selected.

I tried to use IF expression like IF(ISNOTBLANK(USERSETTINGS(XXX)), USERSETTINGS(xxxxx), “”), but this expression didnt work.

How can we achieve this?

(tsuji koichi) #2

@Suvrutt_Gurjar @Grant_Stead Thank you for your comment, really helpful.

I tried various stuffs, and eventually, I came up with the following expression which did work fine and achieved what I wanted to do.


Once again, I filtered table by usersettings. When nothing is selected (default) on usersetting, then show all the row. User select item (usersetting column is set as ref type) and show only rows matching with criteria.

Once again thank you for your help.

(Suvrutt Gurjar) #3

Hi @tsuji_koichi,I am sure you have already tried this before.But just in case not yet tried, please explore following.

Have you tried configuring

“initial value” attribute in all user settings? The initial value may be set based on say User Email. Just in case any user forgets to do any User Settings, at least some initial value

that is relevant to him is available to the user. For example

The slice that needs to be made based on Enum type [Reports] column may have options such as “Manufacturing Report”, “Sales Report” and “Marketing Report”

Now in UserSettings,

create an Enum type setting titled Reports with Enum values as three reporting options mentioned above and initial value expression as follows

=IF(USEREMAIL(),“ManufacturingReport”,IF(USEREMAIL(),“Sales Report”,“Marketing Report”))

The slice row filter may have setting as [Reports] = USERSETTINGS(Reports)

Hope this helps in some way.

(Grant Stead) #4

I know this is going to sound crazy but please try the expression backwards, with isblank…

(Suvrutt Gurjar) #5

Hi @tsuji_koichi , thank you for your reply. Your solution is interesting. Showing all rows verses selected through your slice expression involving usersettings.

All the best.

(tsuji koichi) #6

@Suvrutt_Gurjar Hi, actually, my real scenario involved multiple usersettings, but in combination of IF expression, it worked as well. Good to hear this is of your interest. Take care.