4,401
edits
Changes
no edit summary
<u>'''Field Display'''</u>
[[Image:Cf21.png]]
<u>'''General Description'''</u>
Displays sets of additional [[Custom Field|custom fields]] as records in a grid layout. A summary value for example a sum or a count can be displayed.
<u>'''Field Options'''</u>
* '''Allow Empty''': N/A
* '''Default Text''': N/A
* '''Options''': Aggregated Function
* '''Track Changes''': Yes
* '''Store To Value''': Yes
<u>'''Special Options for Field'''</u>
* '''Grid Contracted''' – display the grid in a contracted format.
* '''Aggregated Function''' – displays a single summary value from the grid.
* '''Addition Custom fields''' – additional custom fields are added to the field.
<u>'''Field Validation'''</u>
* '''Type''': N/A
* '''JavaScript Validation''': N/A
* '''Message''': N/A
* '''HTML Tag''': N/A
<u>'''Field Formatting Options'''</u>
* '''Height''': Yes '''Measure''': Pixels '''Default''': 0 Pixels
* '''Width''': Yes '''Measure''': Pixels '''Default''': 0 Pixels
* '''Number Format''': Yes
* '''Style''': No
* '''Tool Tip''': Yes
<u>'''Notes'''</u>
The following syntax is used to display an aggregate function:
* '''Count(*)''' – counts the rows in the grid.
* '''Sum(fieldname)''' – sums a numeric field.
* '''Avg(fieldname)''' – averages a numeric field.
Only one aggregate function can be used. The aggregate function result will be displayed when the field is collapsed. This value can be reported on, but you cannot currently create a report based on the individual records.
The [[SmartSimple]] reporting engine cannot report on this field type, but the values can be displayed in a web page view field.
[[Category:Custom Fields]]
[[Image:Cf21.png]]
<u>'''General Description'''</u>
Displays sets of additional [[Custom Field|custom fields]] as records in a grid layout. A summary value for example a sum or a count can be displayed.
<u>'''Field Options'''</u>
* '''Allow Empty''': N/A
* '''Default Text''': N/A
* '''Options''': Aggregated Function
* '''Track Changes''': Yes
* '''Store To Value''': Yes
<u>'''Special Options for Field'''</u>
* '''Grid Contracted''' – display the grid in a contracted format.
* '''Aggregated Function''' – displays a single summary value from the grid.
* '''Addition Custom fields''' – additional custom fields are added to the field.
<u>'''Field Validation'''</u>
* '''Type''': N/A
* '''JavaScript Validation''': N/A
* '''Message''': N/A
* '''HTML Tag''': N/A
<u>'''Field Formatting Options'''</u>
* '''Height''': Yes '''Measure''': Pixels '''Default''': 0 Pixels
* '''Width''': Yes '''Measure''': Pixels '''Default''': 0 Pixels
* '''Number Format''': Yes
* '''Style''': No
* '''Tool Tip''': Yes
<u>'''Notes'''</u>
The following syntax is used to display an aggregate function:
* '''Count(*)''' – counts the rows in the grid.
* '''Sum(fieldname)''' – sums a numeric field.
* '''Avg(fieldname)''' – averages a numeric field.
Only one aggregate function can be used. The aggregate function result will be displayed when the field is collapsed. This value can be reported on, but you cannot currently create a report based on the individual records.
The [[SmartSimple]] reporting engine cannot report on this field type, but the values can be displayed in a web page view field.
[[Category:Custom Fields]]
