Difference between revisions of "Deprecated - Custom Field Type: Dynamic Data – Data Grid"

Revision as of 12:39, 14 September 2007

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

• Allow Empty: N/A
• Default Text: N/A
• Options: Aggregated Function
• Track Changes: Yes
• Store To Value: Yes

Special Options for Field

• 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.

Field Validation

• Type: N/A
• JavaScript Validation: N/A
• Message: N/A
• HTML Tag: N/A

Field Formatting Options

• Height: Yes Measure: Pixels Default: 0 Pixels
• Width: Yes Measure: Pixels Default: 0 Pixels
• Number Format: Yes
• Style: No
• Tool Tip: Yes

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.