If you have done the data binding in the fields, then using the somExpression of the fields you can set data of any field across the form.

In FDM, you can test your services after creating the FDM. Have you tested your service there? If yes, is it fetching the expected data?

Here is the code to check for empty field and revert the color of field to normal if not null.   var oNodes = xfa.resolveNodes("DesignDesignation.Designation[*]");  var nNodesLength = oNodes.length;    for (var nNodeCount = 0; nNodeCount < nNodesLength; nNodeCount++) {      var cItem = oNodes.item(n...

I have taken a button in your form and added below script in the click event:   This is the code to change the color of fields in parent and child subform. I have added for one field in parent form, you can add for other like I did for "DesignDesignationSR". You can also write your rest of logic.  T...

Below are the currently available certifications for AEM product.  

Vkatoch07@gmail.com

Share your form, need to look into the form layout and script

this.resolveNode("headersubform.childsubform.child2subform[" + sprec +"]." + "DDS[" + i + "]").ui.oneOfChild.border.fill.color.value = "255, 255, 153";

For DDS[i], use it like the same you are using [" + sprec + "].". It should work then.

I think the Document of record can be an option for this.   https://experienceleague.adobe.com/docs/experience-manager-65/content/forms/adaptive-forms-advanced-authoring/generate-document-of-record-for-non-xfa-based-adaptive-forms.html?lang=en