Chained Select

Version 2.2.0b1: - Change: exported CSV files are quoted the standard way (embedded quotes doubled) and include options that have no options below them, so an export can be imported again - Change: Import a Set reads files as real CSV - quoted values may contain commas and quotes, a "key|label" label may contain "|", and a UTF-8 byte order mark is skipped - Change: the next select is loaded with a POST request (set, level and the keys above it), so option keys can contain any character; the old URL form still works - Change: choosing a new option clears and disables every select below it, and options keep their stored order when the keys are numbers - Change: submitted chained select values must be options of the set that belong to the choice above them - Change: new level 2 options keep their key as entered (like levels 0 and 1) - existing level 2 keys are not changed - Change: Manage Sets pages show set names, keys and labels as text, and the Rename and option Update forms explain that forms store the set name and option keys - Change: the Manage Sets and Import save views now check the form token and the form field rules like other Jamroom forms - Bug Fix: the option editor (Manage Sets) returned an empty "500" page on PHP 8 when an option had no options below it yet, which is always the case for 2-level sets - Bug Fix: a chained select field showed one select too few (or none at all) after building a set in Manage Sets, after creating a set and then importing into it, or after importing a 3-column CSV into a 2-column set - the stored level count was saved before the change - Bug Fix: Export a Set always returned "Invalid set_id"; with that fixed it exported nothing for 2-level sets and wrote broken level 2 values for options with a "key|label" - Bug Fix: 68 lines of the European_Union_Cities_By_Country.csv library file were missing their closing quote - Bug Fix: a saved option with an apostrophe (i.e. "Lincoln's New Salem" in the US library file) broke the form's JavaScript the next time it was edited, and the second select came up empty - Bug Fix: options containing "&" (i.e. "Dumfries & Galloway" in the EU library file) showed no options in the next select - Bug Fix: a required chained select field could be saved with only the first select chosen - Bug Fix: adding a level 1 or level 2 option with a key that already existed silently replaced the existing option instead of showing "Key(s) need to be unique" - Bug Fix: renaming a set to a name that already exists showed a database error; the new name now follows the same rules as a new set (letters, numbers and _) - Bug Fix: changing an option key to a key that already exists replaced that option (and its sub options) without a message Version 2.1.0: - Change: Updated view structure to support new updates in Jamroom Core 6.5.12+ - Bug Fix: Updates and fixes when running on PHP 8.1+ Version 2.0.0: - Change: A new, more reliable user interface to create sets of options has been added - Bug Fix: Multiple reloads of the page may not load previously saved values in select fields Version 1.1.8: - Bug Fix: Square brackets "[]" could show as only select option in 2nd and 3rd sets in some cases Version 1.1.7: - Change: Updated with support for new version of Custom Forms (1.3.0+) Version 1.1.6: - Bug Fix: Possible Activity Log SQL query error when viewing the "Manage Sets" tool Version 1.1.5: - Bug Fix: Chained Select fields in Form Designer set to "required" could be saved without a selection Version 1.1.4: - Bug Fix: Ordering for chanined select Form Designer fields not displaying in correct position Version 1.1.3: - New: Added new UK Country/County CSV file that can be imported - Change: Redundent function removed Version 1.1.2: - Bug Fix: Option sets with only numeric values are not using the correct value when saved Version 1.1.1: - New: "Option Label" setting for level 2 and 3 option sets to have a different Form label than the parent Version 1.1.0: - Change: All new interface for creating Option sets - not backwards compatable! Version 1.0.3 - New: Added default Country/State/City CSV files that can be imported Version 1.0.2 - Bug Fix: Import can now handle comma and tab seperated files Version 1.0.1 - Bug Fix: now works reliably with three or more chained fields Version 1.0.0: - Initial Release