Cascading DropDown element

Introduction​

Options​

• Hidden - is the element hidden
• Eval - Do you want to evaluate (PHP) the default value Element default examples.
• Default - The default value to use when adding a record. Note - this is only evaluated on record creation. Use calc, if you need ongoing evaluation.

Data​

• Render as - How to render the cascading dropdown.
• Connection The Fabrik connection containing the list we will use as the element's data. Note: Fabrik can not join across Connections, so the selected connection must be the same as the list's connection!
• List - the Fabrik table that we want to use for the dropdown's data
• ID - the Fabrik list element that contains the value we want to use for each dropdown option - this is the data that is recorded in the database and should normally be the Lists' primary key. The primary key field is suffixed with "[Recommended]" (as shown in the screen shot above)
• Label - the Fabrik table element that contains the data used for the option label - this is the text that the user sees for each of the drop down Options.
• Or Concat label - OPTIONAL MySQL CONCAT statement to use instead of individual element, such as `{thistable}.last_name, ', ', {thistable}.first_name`. Leave blank to use the element selected in the 'Label' dropdown. Use the {thistable} placeholder to ensure correct table name is used (which might have a _N suffix if more than one join is used to the same table)

(SELECT `column_containing_desired_value` FROM other_table WHERE `id` = {thistable}.field_containing_foreign_key)

• Placeholder - if using 'Render as => auto-complete' then you can specify the HTML5 placeholder text to use when no value is selected
• Max width - If using 'Render as => dropdown' then you can state the max-width for the element. Useful to truncate very long option labels.

Watch​

• Watch element - The element name to watch. When this element's value changes the Options in the cascading drop down will be updated.
• Foreign key - The dropdown's table's field that must contain the same value as the selected 'watch Elements' value.

• Where query - filter the drop down Options with an additional where query. Don't include 'where' in the text you enter here - e.g "active = 1"
• Show please select - Add a "please select" option to the top of the drop down's Options
• Please select label - text to show for the "please select" option
• Eval options - PHP code to run to alter the element Options. Each option is an object and can be referenced in the eval code with the variable $opt. It has two properties $opt->value and $opt->text. The array $data is available which contains the values of element/field values currently on the form. These Elements are referenced thusly:

$myVar= $data[tableName___elementName_raw'] ?? ''; // for Fabrik 3 and 4

Front end​

• Link to joined record - If the element is read only and this option turned on the the read only text is turned into a link which points to a detailed view of the joined record. In the front end example above this would take you through to a detailed view of a region record.
• Description field - In addtion you can select a field from the selected 'Table' which contains additional information about the selected option. This addtional information will be displayed alongside the dropdown and changes as different selections are made.

Additional Tip for CDD Radiobutton​

jQuery("input:radio[name*='tablename___elementname[]']").click(function() {

    jQuery(this).parent().parent().css('opacity','1');

    jQuery(this).parent().parent().siblings().css('opacity','0.4');

    //this is needed when Options are in more than one row

    jQuery(this).closest(".row-fluid").siblings().children().css('opacity','0.4');

});