You need to completely reconfigure your conditional if you delete the field. The values are stored within the params column of the field row. When you delete it then all those values are lost. Is there a particular reason you're deleting and recreating fields repeatedly?
The conditions are tied to field id and in some cases field name depending on the conditions needs. So if you're conditioning a field, you delete it, then the condition no longer matches a field that exists and you need to update the condition to point to the correct field.
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.
There is a possibility with CB Query 3 to create a SQL string which is able to populate a dropdown and at the same time to update a second field with the selected value? If I want to update a field Example: UPDATE `my field` SET `my field` = "value" works perfectly. If I want to read and write values ​​as I do? Example: UPDATE `my field` SET `my field` = (SELECT DISTINCT `field` FROM `table` WHERE `field` = "value")
Thank you.
CB Query Field does not do update queries or anything of the sort. It's for pulling data from the database and not adding data. No such feature is planned as it's out of the scope of the plugins purpose. For what you're wanting I suggest using CB Auto Actions and doing a Field or Query action on the after profile update and after registration triggers to update database values or field values.
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.
Before leaving my project again explain my need to see if there is a way to make it work. I need to create a series of dropdown in cascade related to each other where the user (in this case a student) during the registration process must be able to select: the university --> the type of course --> the faculty --> the course. I can not use CB Conditional because there are many lines so too much data to handle and should create more than 100 fields with the conditions making the database would become unmanageable (attach the file of my database). Is there any way to do it? I hope so otherwise thank you very much for your dedication.
CB Conditional can show your Type of Course field after selecting a value for University. It can also show/hide its options to an extend as well. It can not change the values of Type of Course based off University though, such a feature doesn't exist.
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.