Forum Replies Created
-
AuthorPosts
-
March 19, 2024 at 18:12 in reply to: vLookup Callback Functions with Multiple vLookup Columns #37551
This works perfectly. Thanks so much Alexander! Really appreciate your help.
Thanks for the response! I added the code to remove the cascading dropdown directly above the “arrOfFieldsToPrefill.forEach(fin => {…” code and put the code to reapply the cascading dropdown immediately after the forEach loop. These two fields are both configured as multiselect cascading dropdowns, which I accounted for in the spjs.casc.init() function by appending “:multi” to the FINs for thisListFields array.
The result (after all values are copied over) is that the “Selected options” boxes contain all of the originally selected values concatenated in a single line, delimited by a semicolon and space. The fields get outlined in red with error “The selection “{concatenated string of selected options}” is not valid”.
For example, if the original record had two selected options for cascDDField1: “Apple” and “Banana”, when the values are copied over to the new item, the selected options box contains “Apple; Banana” and is highlighted in red as an error. The available options box still contains both “Apple” and “Banana”.
Is there a way to copy over the selected options so that they are registered as valid selections (moved from available box to selected box and displayed on separate lines without the semicolons)?
Related question: since I reapplied the cascading dropdown via customJS, should I remove the configuration from the Cascading Dropdowns tab in backend? Not sure if it being invoked via the tab and also in the custom code is causing the issue.
Hi Alexander,
Quick follow up question related to this code – if 2 of the multi line text fields we want to copy over are configured as cascading drop downs (via the cascading dropdowns tab in DFFS backend), how do we handle the copying over of those fields? Currently they are not getting set. I logged the values to the console and can see the correct values there but those values are not selected in the actual form – the ‘selected options’ boxes for both fields remain blank after autocomplete executes.
-
AuthorPosts