Changes

=Overview=

This field type can be used to create worksheets or tables such as budget sheets, and lists of information. A wide range of complexity is supported from very simple tables to multi-section, multi-year budgets. This is accomplished through the ability to configure sub-sections within the same worksheet, and also define automatic cell calculations. This all adds up to a very robust, and flexible field.

Using the XML '''Section Builder''' you can create sections and define the attributes of each section and the cells within them. You can define the number of rows and columns, the display format, calculation formulas, and style your XML.

# While editing the custom field click on the '''Section Builder''' button (the four square icon) in the action bar.

== Create a Table with a Dynamic Number of Rows ==

In addition to defining a set number of columns and rows, you can also configure a section to handle a dynamic number of rows. The user entering the data can add rows as necessary at time of entry. This is done by entering '''0''' for the '''Number of Rows''', which in turn exposes the following configuration options:

The presentation of the XML Data custom field is configured in the general settings page of the field. This is defined in the XSL Template (Extensible Style Sheet Language) option. The XSL Template includes a sample template option. Once you have inserted sample template you will need to specify which sections should appear and where they should appear.

# While editing the custom field locate the '''XSL Template''' option and insert the '''Sample Template'''.

<pre>if("<ssEscape>@level1.xml.fieldname.sectionnodename.rownodename.columnnodename.nodevalue@</ssEscape>"=="")

{result.isPassed=false;

var saveFunc=saveXML;

saveXML=function() {

function checkdupeval() {

var result = 0;

if( a == b)

{

}

}

if(result==0)

}

</pre>

<pre><?xml version="1.0" encoding="UTF-8"?>

<worksheet>

</worksheet></pre>

{{CustomFieldPageFooter}}

[[Category:XML]]