Smartstaff, administrator
4,478
edits
Changes
no edit summary
The is configured by entering '''0''' for the number of rows, which in turn exposes the following configuration options:
* '''Maximum Number of Rows''': if the '''Maximum Number of Rows''' this option is left as 0 then the user can add as many rows as needed. If the '''Maximum Number of Rows''' option is populated with a numeric value then the user can only add as many rows as specified. * '''Maximum Reached Message''': message to be displayed if user tries to add more that the specific maximum number of rows, . A default message is displayed if left blank. '''Has Total''': will appear when clicking into the column headers. Check '''Has Total''' to automatically sum and display all the items in that column.
Even though you set the number of rows is set to '''0''' you still need to configure one row of data still needs to which will be configured, used to format the dynamically created rows. When creating You may also set a maximum number of rows for a dynamic XML if you click into any column header, you will notice a property called '''Has Total'''. Check '''Has Total''' if you want to automatically sum and display all the items in that columnsection.
=== Display XML sections ===
The XML Data custom field has an XSL Template option within the overall XML Data custom field settings. The XSL Template is used to define how the XML will be displayed. XSL stands for Extensible Style Sheet Language.
The XSL Template includes a sample template option. If the template is used then all that is left to do is to specify what sections should appear included and where they should appear.
[[File:xml-xsl.png|The XSL template|500px|border]]
The syntax '''@section.''SectionNodeName''@''' will display the section we created using the section builder.
Note: you must replace '''SectionNodeName''' with the name you gave your section (e.g. '''@section.''expense''@'''), the section node name is case sensitive, and you must remove the html comments.
== Configuring the XML - Advanced ==
=== Creating formulas (calculations) in XML ===
[[File:xml-formula.png|Adding a formula|500px|border]]
In the section builder you declare the formatting such as currency or numeric for specific columns as well as settings like precision. If you are collecting numeric or currency data you will likely want to do calculations on this information found within your XML (e.g. to sum the contents of column one, over two rows, enter '''=[1,1]+[2,1]''').
=== Adding a formula to a XML cell (working with data in the same section) ===
