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
 
					
				
		
 muniyandi
		
			muniyandi
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Try this expression it works.
Textbox-->Layout-->show-->conditional-->
IF(Count(distinct [Customerid]) >1, 0,1)
Regards,
Muni
 
					
				
		
 Sokkorn
		
			Sokkorn
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 
					
				
		
 Sokkorn
		
			Sokkorn
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 
					
				
		
 Sokkorn
		
			Sokkorn
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 
					
				
		
 Sokkorn
		
			Sokkorn
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Well done Wael.
Cheer!!
