Cascading Selects in Form

What version are you running. Have you turned on debugging to see what is rendered or executed?

Kentico 8. With that SQL query, the following SQL is executed according to the debugger:

SELECT PlatformName, PlatformName FROM Table_Product_Platform T WHERE T.ProductName = ''

So it appears the macro is finding no value for ProductDropDownList on load

The macro evaluated to null in the logs: EditedObject.GetValue("ProductDropDownList") null The question might be how to get the value of the ProductDropDownList after it has been loaded or refreshed.

I was able to create a form with 2 custom tables providing values for 2 fields in the form which are dropdowns. The custom tables were "group" and "sub group". Sub group has a parent group field in it. So when you create a sub group you select a parent.

In the form the my fields are as follows: Product, GroupID, SubGroupID.

GroupID is a dropdown field with a select statement below and has the "Has depending fields" box checked.

SELECT ITEMID AS Value, GroupName AS Name FROM customtable_MyTestGroups ORDER BY GroupName

SubGroupID is a dropdown field with a select statement below and has the "Depends on another field" box checked.

SELECT ItemID As Value, SubGroupName AS Name FROM customtable_MyTestSubGroup WHERE ParentGroup = {% GroupID @%} ORDER BY SubGroupName

When I create a new form record and select a different group, the sub group populates with correct items.

That syntax works well, for the first load of the form. The first item in Group is selected and the Subgroups for first item appear. On change of Group though, the Subgroups do not change. The "Depends on another field" (Subgroup) and "Has depending fields" (Group) boxes are both checked. The page does a refresh, but no changes to the Subgroups.

Created a new form with just these values, same effect, both using form on page or using "New record" option in the Form editor.

This is odd. If there are no Subgroups for the first value, onChange the Subgroup will update correctly with the proper subgroups for the selected Group. After the Subgroup is populated though, it will no longer update onChange.

For example:

Group1 > No subgroups. Group2 > Sub1, Sub2. Group3 > No subgroups. Group4 > Sub3, Sub4.

On form load, no data in Subgroup.

Scenario 1: Initial Group 1 = no data Select Group 4 = Sub3, Sub4 Select Group 2 = still Sub3, Sub4

Scenario 2: Initial Group 1 = no data Select Group 3 = no data Select Group 2 = Sub1, Sub2 Select Group 4 = still Sub1, Sub2

You can repeat in any number of patterns, after Subgroup has its first data set (not null), it does not change on future onchange/select events.

Brendon, did you come up with any solution? I'm having a similar issue here.

Thanks.

Juan

I am looking for the same solution so can you please let us know if the below is possible with Custom Table New Item Form. Where I have tried to create cascading feature to the form control where I have used two dropdown form controls with "Has Dependent Field and Depends on another Field" relation and set "SQL Query" as data source. The SubCategory SQL Query needs to be build with ParentCategory dropdown value. So can we use the below SQL Code with Macro to populate Sub Category ?

        SELECT ItemID, SubCategoryName FROM SubCategoryTable 
        WHERE ParentCategoryID= {%EditedObject.CategoryID|(identity)GlobalAdministrator%}