Trigger cascading dropdown update

[liga]

Situation:

• A form is to be filled in by two different persons. When person A has filled in a number of fields, it is saved.
• Later, person B edits the record and fills in the remainder of the fields.
• All fields to be filled in by person A are in the same group, all fields to be filled in by person B are in a second group.
• Cascading dropdowns are used quite a lot: field A1 is a database join, field A2 is a cascading dropdown monitoring A1, field A3 is a cascading dropdown monitoring A2, field B1 is a cascading dropdown monitoring A3.

Problem:
When person B loads the partially filled-in form, the field B1 is not filled with the possible options, even though the field A3 (which it monitors) has a correct value.

Solution:
I added a JavaScript action to the field B1, to be run on load, with the code:

var x = form_18.formElements.get('mytable___fieldA3').getValue();
form_18.formElements.get('mytable___fieldB1').change(x, 'mytable___fieldA3');

Question:

• Shouldn't the field B1 be populated automatically?
• Is this the best solution?

 

[rob]

the change events should daisy chain, can you point us at the form so I can see what might be happening?

 

[liga]

Hi Rob, tx.
Access credentials and links have been sent.