Hi everyone, hope you’re all doing fine!!
I'm having issues with my form related to cascading LOVs (List of Values) and a dynamic action that fills in the value of a field based on it. As you can see in the image, I have LOV1 that fills in the other fields, including LOV2 and LOV3 (LOV3 based on the value from Lov2). However, the user can manually change the city via LOV2, and the neighborhood via LOV3 according to the values in LOV2. LOV2 and LOV3 are storing the city and neighborhood codes respectively and displaying the names on the screen. But when doing it this way, LOV3, which depends on LOV2, display the code instead the neighborhood description. I want it to save and return the code in the field and display the neighborhood name in the selection. The figure below shows what's happening in this case. I already tested lov 3 without using cascade and it worked normally.
I'm trying another alternative in which the 'city code' and 'neighborhood code' fields are changed based on the values in LOV2 and LOV3 through dynamic action set value. In some cases, I can successfully acquire the neighborhood code (First image below), but in other cases, the field is not filled (Second image below).
In the developer tools, under 'Network' > 'Fetch/XHR', I noticed that the AJAX executes asynchronous functions as shown in the image bellow. Sometimes, the first function takes longer to return, and the dynamic action that changes the value of the 'neighborhood code' field sets the value through AJAX 2 and then removes it because of AJAX 1. I want to set it up so that AJAX 1 is executed before AJAX 2.
