I was able t get the state working but the ZIP and City are not working at all. I configured the field as per the following parameters in the instructions. Can anyone advise what is missing?
City Configuration Select the 'Query Drop Down (Single Select)' type for your new field
Query: SELECT DISTINCT `city` FROM `usa_zips` WHERE `state` = '[cb_usastate]' ORDER BY `city`
Set the 'Value Column' parameter to city
Set the 'Label Coumn' parameter to city
Keep the 'Group Column' parameter empty
State Configuration
Create a new CB Field from CB Field Management area Query
SELECT `zip` FROM `usa_zips` WHERE `city`='[cb_usacity]' AND `state`='[cb_usastate]' ORDER BY `zip`
Configure the Update On parameter in the Query Tab to your previously created cb_usastate and cb_usazip fields
Set the 'Value Column' parameter to zip
Set the 'Label Coumn' parameter to zip
Keep the 'Group Column' parameter empty
Never mind, I found the answer. It requires the query plugin to be installed. It would be nice to insert this info in the instructions.
It says "The CB Query field plugin (version 5.0.2 or better) supports 5 additional field types that get their select values from a database query." directly as the fist sentence.
I was able t get the state working but the ZIP and City are not working at all. I configured the field as per the following parameters in the instructions. Can anyone advise what is missing?
What's not working? They're not displaying any values? Your queries are dependent on previous fields. This means you need to configure "Update On" so they update their values when the previous field changes value.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
krileon
