Difference between revisions of "XML Section Builder"

Revision as of 10:29, 6 November 2014

The XML Section Builder can be used to create XML templates without knowing advanced HTML or XML.

To enable:

• Select the Enable Builder checkbox on the custom field settings page and click Save.
• Click the Section Builder button at the top of the page to enter the builder.

Builder

• Node names must not be blank, must not contain spaces, parentheses, brackets, percent sign, and must not start with a number. (Disallowed initial characters for Names include digits, diacritics, the full stop and the hyphen.) If users try to build a section with these issues then they will receive an alert.

You cannot have the same node names across different sections levels in the xml. If there is a Section Node name called "Infrastructure" then it can't be used as a row node name or column node name for any other sections. I've renamed the row node names for the Summary section to something like "Infrastructure-Summary" right now and the budget xml will now save properly. Note: you have to re-enter the data and re-save in order for them to populate.

• CSS classes specified can either be the system defined classes, or you can create your own CSS classes and include them in the <style> tag on the Template. (See Adding Styles to XML Worksheets for instructions)
• The formula can refer to other cells within the section using the following syntax:

[row#,column#]

Example:

=[1,1]+[1,2]

• The formula can refer to fields in other sections using the following syntax:

[@section.yoursectionname.id@_rowname_colname]

Example:

=[@section.InternalFunding.id@_Total_Amount]/[@section.TotalFunding.id@_Total_Amount]*100

Click on a cell in the section for the Cell Properties, each cell has the following properties:

• Type: this is the type of cell, (Single Line Text, Multiple Line Text, Display Only Text, Select One Combo Box)
• Content: Text to display in the cell or formula for calculations (Examples: Total or =[1,2]+[2,2] or =[35_Total_Amount]+[36_Total_USD])
• Cell CSS Class: Add a CSS class to the table cell
• Input CSS Class: Add a CSS class to the input field
• Input Attributes: Add HTML attributes to the input field (Example: name, size)
• Validation Script: Script to validate the input field (Example: [this]>100 or [this]==[35_Total_Amount])

Note:

If the column on which you want to apply the validation on has a 'Currency' formatting, you will have to convert the data into a number before you perform the validation.

Example:

To check if the amount entered is always greater than 0 for a column which has a currency formatting, use the built in ssParseNum function to convert the amount to a number.
ssParseNum([this])>0

See ssParseNum for additional information.

• Validation Message: Alert when validation script is not true (Example: This value must be greater than 100)

Template

Within the XML Field template you can pull the sections you have created using the following syntax:

@section.sectionname@

Example

 <table>
    <tr><td>Revenue</td></tr>
    <tr><td>@section.Revenue@</td></tr>
    <tr><td><br>Expenses</td></tr>
    <tr><td>@section.Expenses@</td></tr>
 </table>

You can also indicate if the section should not be rebuilt by checking the box labelled Do Not Rebuild and then clicking Save.

If this is populated and someone tries to rebuild the section then that user will be presented with the alert below when they click on the Build button.

Dynamic Rows

With the Section Builder if you create a section and enter the Number of Rows as '0', the section will automatically put an ADD button on the page to add rows dynamically, one by one. Each row will also have a Delete (DEL) button to remove that specific row.

NOTE: The Add and Delete buttons will not appear when you access an XML worksheet from a record that is in view mode.

Enable Mapping

When a the Number of Rows for a Section is set to '0', the Enable Mapping option will be shown. When Enable Mapping is selected, you can choose one type of Level 2 activities to be referenced by the XML field. The Activity Status Filter setting will also become visible, which allows you to filter the Level 2 activities to be referenced by status.

See Managing Level 2 Activities with an XML Section for further information on activity mapping.

See Also

• Custom Field Type: Special - XML Data
• Managing Level 2 Activities with an XML Section