How to Hide an object if there is no selection

[#1]

I need an expression for conditional show to hide a text box when no selection is taken.

Thanks

[muniyandi]

Hi,

Try this expression it works.

Textbox-->Layout-->show-->conditional-->

IF(Count(distinct [Customerid]) >1, 0,1)

Regards,

Muni

[Sokkorn]

Hi,

First Right Click on Text object ==> Layout tab ==> Conditional = NOT ISNULL(GetFieldSelections(YourField))

Hope this help.

Regards,

Sokkorn

[#4]

Thanks for your tip.

what I am trying to do is to get [Extended Till] Date if there was an extension from my data, and it works perfectly with the following formula

if(IsNull([Extended Till]),0,1)

now what I want to add is that if I clear all selections from my entire sheet, I want this box to disapear

Best regards,

Wael

[Sokkorn]

Hi Wael,

Did you try expression NOT ISNULL(GetFieldSelections([Extended Till])) yet? This work for me when I clear selected values.

Regards,

Sokkorn

[#6]

Sokkorn,

Thanks for your reply I tried it but didn’t work!! The box totally disappears and even when I do have an extension (TRUE VALUE)

maybe cuz my sheet is a bit complicated ☹

regards,

Wael

[Sokkorn]

Hi Wael,

Can you share your app? It may easy to find solution.

Regards,

Sokkorn

[#8 · Accepted solution]

Thanks to you Gents I was able to solve it.

if(GetSelectedCount([AnyObjectOnSheet])=1 and not IsNull([Extended Till]),1,0)

best regards,

Wael

[Sokkorn]

Well done Wael.

Cheer!!