Hide related Columns when blank

[Luis_Gomes_Mac1]

Hi everyone,

Is it possible to hide related columns when their result is zero or null?
In the bellow picture there are several related columns only the "Contactos# one has a result. How can I hide the ones that have no result?

thanx a million

[Marc_Dillon]

help.appsheet.com

COUNT()

Number of list items

help.appsheet.com

Show_If Column Constraint

Conditionally show or hide a column value.

[Luis_Gomes_Mac1]

Hi Marc,

thank you for your reply!
Which one of the options you believe is the best practice?

[Marc_Dillon]

Use COUNT() in the show_if expression. It was intended as only 1 option.

[Luis_Gomes_Mac1]

Thanks again!

I suck with expressions that’s why I have so much trouble with these issues…

I will study the link you sent me

thanks again mate

[Luis_Gomes_Mac1]

Hi Marc,

I’ve been trying to set the count up with no success, I don’t understand the way Count will count the rows of column a related to a table, in this case a slice…

Can you r someone help?

[Lynn]

Hi @Luis_Gomes_Machado
Maybe try something like this in SHOWIF
COUNT([Related Column]) >= 1
What did you try?

[Aurelien]

Hi @Luis_Gomes_Machado

In addition to what @Lynn said, can you try that: ISNOTBLANK([Related Column])
(It’s an equivalent solution in my opinion)
I just gave it a try for testing, that works on my app.

Make sure you set this expression here:

for doing so:

[Lynn]

@Aurelien
Nice!

[Luis_Gomes_Mac1]

Aurelien:

ISNOTBLANK([Related Column])

Thank you so much you all for helping me
Still I am doing something wrong…

does it have to do with the column structure of my slice?

[Marc_Dillon · Accepted solution]

??

[Luis_Gomes_Mac1]

Sorry Marc… you are a genius!

thanxs man!!!

Thank you @Lynn and @Aurelien as well!!!