Question about CB Query Field (5.0.4)

1 year 10 months ago #303441 by ontarget
Hi I have a db table with 3 columns
Col1 = id
Col2 = regNumber
Col3 = schoolName

I wish to have a CB registration form containing amongst others 2 fields:
Registration Number cb_regnumber
School Name cb_schoolname

If the user enters a Registration Number it should validate against "regNumber"
if the match is true then the School Name field is autopopulated with the value of "schoolName"

Select schoolName FROM table WHERE regNumber = [query]
return [query]

Is this possible with CB Query Field (5.0.4)? Please let me know asap for a quick purchase.
1 year 10 months ago #303448 by ontarget
Hi I need to move on with this project so please let me know if CB has this capability prior to purchase
1 year 10 months ago #303454 by krileon

Is this possible with CB Query Field (5.0.4)? Please let me know asap for a quick purchase.

Yes, the query validation can query against your custom database to validate a fields value against the columns of your table. Using CB Query Field you can query for the name based off the number.

However, the query field isn't going to update its value dynamically when you change your number field. For that you need CB Core Fields Ajax and its Update On functionality, which basically refreshes a field when another field changes its value.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Templates - CBSubs - Hosting - Forge - Incubator - GroupJive
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 EST to 4:00 PM EST. 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.
Moderators: beatnantkrileon
Time to create page: 0.430 seconds

Facebook Twitter LinkedIn