3 or more cascading list boxes

Permanently deleted user

27. Februar 2013 07:26

I am having a problem with making a proper query with 3 list boxes.

I need to run a query based on the item picked in listbox1 and listbox2

it seem like the forms program does not allow you to refer to a variable picked in a previous list box, other than the one just above you current box.

Township = '010-0N' and Range = '010-0W' and Section = '36'

the above is what  the query needs to look like as it comes out of the form

 

in the third list box i need to have something like this:

Township = '{0}' and Range = '{1}' and section = '%'

 

I cannot get this to work -- is there a trick to it? the program doesn't seem to like the {1} argument, is there a way to use the arguments defined in previous list boxes in the same form?

like this:

Township = 'myvar1' and Range = {0} and Section = '%'

 

any hints?

Jeff

 

 

0

• 

  Ryan Cooney

  27. Februar 2013 08:22

  Hi Jeff,

  Currently a cascading form element can only access the value from its cascading parent. This is the "{0}" value. There is not a "{1}" value passed in.

  We are doing some development right now that aims to provide a mechanism to access the value of any form element. This is probably a month or two away from release though.

  --Ryan

  0
• 

  Permanently deleted user

  27. Februar 2013 23:52

  Can you suggest a work-around? - (i guess i could run the first query on the first two boxes, get the variable values, bring up another form, do a realtime calculation with the new query for the 3rd box)

  J

  0
• 

  Ryan Cooney

  28. Februar 2013 00:35

  Hi Jeff,

  Right now you will probably need multiple forms to accomplish this.

  There are some cases where the structure of your data can make this possible. You would need the values that get populated into the second dropdown to also contain the information from the first dropdown. In your case it would be something like a concatenated TownshipRange section. This is often awkwark to do and not always possible.

  --Ryan 

  0
• 

  Permanently deleted user

  20. August 2013 01:47

  Hi All,

   

  The cascading combobox function displaying values depending on two previous input selections is in Geocortex Essentials 3.14 (or later.)

   

  If you had 3 comboboxes cascaded and you wanted the values selected in the third box to be dependent on the selections made in the first two, use a where clause in the third combobox's arguments that looks like this example: 

   

  attribute1 = '{1:ComboBox1}' AND attribute2 = '{1:ComboBox2}'

  regards,

  Edmond

   

   

  0
• 

  Permanently deleted user

  28. August 2013 08:13

  Hi,

   

  I've posted a simple example in this post - https://support.geocortex.com/SupportForums/Thread.aspx?thread=46438&mid=2&pageid=0&ItemID=20&pagenumber=1#post146331

   

  regards,

  Edmond

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.