0
edits
Changes
→Builder: - added some Cell Properties info
* The formula can refer to other cells within the section using the following syntax:
* <font size="2">'''[row#,column#]'''</font>
Example:
[1,1]+[1,2]
* The formula can refer to fields in other sections using the following syntax:
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 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]'')
* ''Validation Message:'' Alert when validation script is not true (Example: ''This value must be greater than 100'')
==Template==
