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.
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
-
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
