Is there a way to conditionally show/hide tab...

(Grant Stead) #1

Is there a way to conditionally show/hide table grouping?

(Levent KULAÇOĞLU) #2

@Grant_Stead I believe it could be possible if you set your grouping condition to a VC and set its false value to CONCATENATE (""). Haven’t tried something like this though but it sounds logical

(Grant Stead) #3

I just tried some physical columns, and when they were set to show_if false, they are still in the grouping, and you have to drill down through them, even though they are show_if false… Also, I always turn OFF the show_if universal…

(Jonathon Sinclair) #4

@Levent_KULACOGLU This is the most logical way to handle it, and really not that much trouble as you can set up the ungrouped UX, copy it and add the grouping…

Handle the option as a USERSETTING()?

(Levent KULAÇOĞLU) #5

@Grant_Stead I believe rather than show it or not, it’s related with its value. Therefore I suggested an empty value CONCATENATE expression. As I said haven’t tried it.

(Grant Stead) #6

@Levent_KULACOGLU what do you mean by “false value”

(Levent KULAÇOĞLU) #7

@Grant_Stead let’s say you have a physical column with YES and NO values and you want to group your UX as per this column if and only if both values exists in the column. If you set a VC with an expression like this for ex:

=IF(AND(CONTAINS([PysicalColumnName],“YES”,CONTAINS([PysicalColumnName],“NO”),[PysicalColumnName],CONCATENATE(""))

I believe it might work. It might also group them with an empty header. As I said I haven’t tried something like this before, but it sounds logical to me. At least it worths trying :slight_smile:

(Grant Stead) #8

Yeah, it’s just going to show a black header…

(Levent KULAÇOĞLU) #9

@Grant_Stead have you tried it bud?

(Levent KULAÇOĞLU) #10

@Grant_Stead another idea could be arranging 2 UXs with grouped as per your column and ungrouped. Then you may set a SHOW_IF expression similar to I have given to each of the UX views. Too much job I know, but it’s a workaround.

(Grant Stead) #11

@Levent_KULACOGLU I’ll report back when I get back to my rig… I like calling it a rig… It’s mostly just a 13.3" Chromebook lol

(Levent KULAÇOĞLU) #12

@Grant_Stead LOL