I have a need to do a filter on a dropdown based on two columns so I can’t use a cascade and have to use a SPFilterDropdown, but it’s based on an input in the form, and since that’s not set when we open the “new” form we don’t get any values. Basically getFieldValue doesn’t update on change.
How can I make getFieldValue update on change in my function?
The scenario here is I need to select location(s) based on the Account and on the Type of Location. I pre-populate the Account based on the vLookup, but the user must select the type when they open the new item.