Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Can somebody please advise me how I can limit members of a field that are visible in a listbox object. The data model includes many business units but I want to restrict those available in my list box to only a few, and I'll also want to limit expressions in other objects to include just specific business units.
Thank you
 
					
				
		
 alexandros17
		
			alexandros17
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		If your field is for example the division (Ex. from 20 to 100 step 10) and I want to see only division from 10 to 50 then in your listbox use the expression (at the end of field's list) and write your condition
Ex. If(Division <=50, division, null())
let mne know
 
					
				
		
 simondachstr
		
			simondachstr
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Ideally, you should be doing that in the script/data model, but you can also add a calculated field in a listbox e.g.
=if(match(FIELD,'Key1','Key2' etc.), FIELD)
 
					
				
		
maybe hide excluded on the properties of your listbox
