I'm trying to trigger a calculated field contingent on a select2 field or a hidden calculated field and I can't make it work.
This is what I have:
Field1(Cascading Dropdown Field for value: Field_ID) (converted into a select2 element using $('select[name="InsertRecordField1"]').select2();)
VirtualField1 (Calculated Field) (Using the following sql SELECT Field_Name FROM Table WHERE [@field:Field1] = Field_ID)
The SQL doesn't notice the changes made to Field1 nor its initial value on page load.
I tried using JavaScript and SQL to give Field1's value to a another hidde