Hi Nant, we've purchased the Professional membership and have installed the CB Query plugin.
I have created a custom text field "Organization Name" on the registration form and I need this value to be validated against the database by checking to see if there is already an existing value. The requirement is that no registered members should have the same organization name entered in this text field. If there is, then it should prevent the user from registering, like the way the username field gets validated after entering the name on the CB registration form.
Not sure how to implement this to validate on another text field, , could you please advise?
Install and publish CB Query Field. Next edit your Text field and under Integrations > CB Query Field you can enable query validation. You'll then need to create a query to check if the value already exists. Example of this as follows.
Query Validation: Enabled
Query:
Code:
SELECT `id` FROM `#__comprofiler` WHERE `cb_text` = '[value]'
Validate On: Empty Results
Ajax Validation: Enabled
This would test the fields value against the "cb_text" field and if it returns no results the field will be valid. If it finds a match then "Error Message" will be shown to the user and the field would be marked as invalid. This can be used to ensure a CB field value is unique plus much more.
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.
Thanks, krileon, it's validating, but the error message doesn't seem to display the one that I've entered. The error message is showing "Not a valid input" for some reason.
There's a default language string that shouldn't be in the language file. I've removed it and re-released the package. Re-download and install and your message should work fine.
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
