Difference between revisions of "Deprecated - Custom Field Type: Dynamic Data – Data Grid"
From SmartWiki
| Line 29: | Line 29: | ||
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. | 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 | + | The [[SmartSimple]] reporting engine cannot report on this field type, but the values can be displayed in a [[Web Page View]] field. |
{{CustomFieldPageFooter}} | {{CustomFieldPageFooter}} | ||
Revision as of 08:28, 19 July 2013
Click here to peruse our selection of custom fields.
Field Display
General Description
Displays sets of additional custom fields as records in a grid layout. A summary value for example a sum or a count can be displayed.
Field Options
| Option | Description | Format |
|---|---|---|
| Custom Field ID | The unique ID number associated with the custom field. | Not Applicable |
| Field Type | The list of available Field Types. | @fieldtype@ |
| Field Name | The name of the field, used internally to reference the user's input; | @fieldname@ |
| Caption | The leading question or prologue before the field. | @caption@ |
| Display Order | The order (relative to other fields) in which this field is displayed. | @displayorder@ |
| Description | Definition and general description of the custom field. Will not be displayed. | @description@ |
- Track Changes: Keeps track of changes made to this field.
Special Options for Field
- Aggregated Function – Display a single summary value from the grid. See notes below.
- Visibility Condition: See the Visibility Condition Wiki page.
- Field Permission Matrix: See the Field Permission Matrix Wiki page.
- Field Formatting Options: See the Field Formatting Options Wiki page.
- Role - Field Permissions: These settings allow you to control by Role who is allowed to view and/or modify the field.
- Status - Field Permissions: These settings allow you to control by the Status of the record whether or not the field can be viewed and/or modified. (Only present within the Universal Tracking Application)
- Type - Field Permissions: These settings allow you to control by the template of the record whether or not the field can be viewed and/or modified. (Only present within the Universal Tracking Application)
Notes
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.
