AnsweredAssumed Answered

Results based on an optional parameter

Question asked by jackmac on Apr 28, 2017
Latest reply on Apr 28, 2017 by Jason Wood

Hi all,

 

I have a script I use on three different buttons - economy of scripting on my part which seems to work.  It basically extracts information from a table.  On two of the buttons I use an optional parameter which changes direction the script as in

 

1)     Country = 'UK'

 

2)     Active = 'Yes'

 

Both of these parameters work perfectly well.  I want to add a parameter to another button which effectively says 'filter on whatever county shows in the county search box'. (I have a drop-down box with all counties listed, I want the result of the drop down to be the parameter result.)

 

I have tried

County = CountySearch

County = 'CountySearch'

County = "CountySearch"

 

with no effect.  Can anyone advise how I can get the parameter to filter based on whatever is found in the CountySearch box?

 

TIA

 

Jackmac

Outcomes