I'm using a form to display the output document we send to customers. Some of the products have serial numbers and some do not have serial numbers, so when we enter the line items on a form, perhaps 10 items, only 5 of them will have serial numbers. When this displays on the form, it bumps all 5 serial numbers to display in rows 1-5 of the table, even though they might be for line item 1,3,4,6 and 10. Below is the XML schema for the serial number field, as I'm hoping there is something simple that I am forgetting.
<field minH="4.282mm" name="colSerialNumber_4WBK44MW54WDAT7CJDFSCMSH0_35495" w="24.594mm">
<font size="9pt" typeface="Arial"/>
<margin bottomInset="1mm" leftInset="1mm" rightInset="1mm" topInset="1mm"/>
<bind match="dataRef" ref="$.ServiceOrder.Item[*].SerialNumber_4WBK44MW54WDAT7CJDFSCMSH0"/>
Any help would be appreciated.
You should bind the repeating element in your form (probably the Row object if a table) to the repeating element in the XML, so $.ServiceOrder.Item[*] then the field above should have a relative binding to Item, so just $.SerialNumber_4WBK44MW54WDAT7CJDFSCMSH0. That way the columns will stay in sync.
I sort of have the same problem. I have a table which lists out a row for each product (fertilizer). Each different fertilizer has different values for the nutrient columns such as Nitrogen, Phosphate, Potassium.
The XML file sends these values over, however if a product doesn't have any of a particular nutrient in it, such as Nitrogen, it leaves the field blank. If the next row in the table does have a value for that field, it's sliding it up into the wrong row.
I believe the problem I am having is that the XML file does not carry over the field at all if it's a null value.
the below is a cut out of my XML and as you can see it's got a value for Sulfur and a value for Nitrogen...but nothing comes across for the Phosphate and Potassium.
Make sure you have the object in the form bound to the repeating item in the XML. So the binding expression should end with a "[*]". It sounds like the column fields have a binding expression which includes the "[*]".
Looks like the forum mucked up you XML, maybe a screen shot and maybe one of the form structure as well.