Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need an expression for conditional show to hide a text box when no selection is taken.
Thanks
Thanks to you Gents I was able to solve it.
if(GetSelectedCount([AnyObjectOnSheet])=1 and not IsNull([Extended Till]),1,0)
best regards,
Wael
Hi,
Try this expression it works.
Textbox-->Layout-->show-->conditional-->
IF(Count(distinct [Customerid]) >1, 0,1)
Regards,
Muni
Hi,
First Right Click on Text object ==> Layout tab ==> Conditional = NOT ISNULL(GetFieldSelections(YourField))
Hope this help.
Regards,
Sokkorn
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
Hi Wael,
Did you try expression NOT ISNULL(GetFieldSelections([Extended Till])) yet? This work for me when I clear selected values.
Regards,
Sokkorn
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
Hi Wael,
Can you share your app? It may easy to find solution.
Regards,
Sokkorn
Thanks to you Gents I was able to solve it.
if(GetSelectedCount([AnyObjectOnSheet])=1 and not IsNull([Extended Till]),1,0)
best regards,
Wael
Well done Wael.
Cheer!!