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

From SmartWiki
Jump to: navigation, search
Line 7: Line 7:
 
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.
 
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>
+
<u>'''Field Options''' </u>
  
* '''Allow Empty''': N/A
+
* '''Display Order''': The order (relative to other fields) in which this field is displayed
* '''Default Text''': N/A
+
* '''Tab Name''': Displays the field under a given tab
* '''Options''': Aggregated Function
+
* '''Field Name''': The name of the field, used internally to reference the user's input
* '''Track Changes''': Yes
+
* '''[[Caption]]''': The leading question or prologue before the field
* '''Store To Value''': Yes
+
* '''Track Changes''': Keeps track of changes made to this field
 
 
 
<u>'''Special Options for Field'''</u>
 
<u>'''Special Options for Field'''</u>
  
* '''Grid Contracted''' – display the grid in a contracted format.
+
* '''Grid Contracted''' – Display the grid in a contracted format.
* '''Aggregated Function''' – displays a single summary value from the grid.
+
* '''Aggregated Function''' – Display a single summary value from the grid.
* '''Addition Custom fields''' – additional custom fields are added to the field.
+
 
+
<u>'''Services'''</u>
<u>'''Field Validation'''</u>
+
 
 +
* '''Enable Map Service''': displays the map icon next to the field name that will launch the user’s selected map service and display a map of the content of the field
 +
* '''Enable People Search Service''': displays the search Internet icon next to the field name that will launch a variety of search services and display the contact details from those services
 +
* '''Enable Organization Search Service''': displays the search Internet icon next to the field name that will launch a variety of search services and display the organisations details from those services
 +
 
 +
<u>'''Value Stores To'''</u>
  
* '''Type''': N/A
+
* '''Custom Field''': Enables linking two different custom fields to the same user data
* '''JavaScript Validation''': N/A
 
* '''Message''': N/A
 
* '''HTML Tag''': N/A
 
 
 
 
<u>'''Field Formatting Options'''</u>
 
<u>'''Field Formatting Options'''</u>
  
* '''Height''': Yes '''Measure''': Pixels '''Default''': 0 Pixels
+
* '''Width''': Determines the width of the field
* '''Width''': Yes '''Measure''': Pixels '''Default''': 0 Pixels
+
* '''Height''': Determines the height of the field
* '''Number Format''': Yes
+
* '''Number Format''': Formats any numbers entered into this field
* '''Style''': No
+
* '''Style''': '''Bold''', <u>Underline</u>, ''Italic'', <font color="red">Highlight</font>
* '''Tool Tip''': Yes
+
* '''[[Tool Tip]]''': Enter help text to be shown on mouse-over
+
* '''Read Only''': Checkbox
 +
* '''HTML Tag''': Additional attributes to the field HTML tag
 +
* '''[[Custom Fields – Detailed Descriptions#Visibility Condition|Visibility Condition]]''': Conditions upon which the field is visible
 +
 
 +
<u>'''Role - Field Permissions'''</u>
 +
 
 +
These [[Custom Fields UTA Status Permissions|fields]] allow you to control who is allowed and who is denied viewing and/or modifying the field.
 
<u>'''Notes'''</u>
 
<u>'''Notes'''</u>
  

Revision as of 14:37, 4 May 2009

Field Display

Cf21.png

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

  • Display Order: The order (relative to other fields) in which this field is displayed
  • Tab Name: Displays the field under a given tab
  • Field Name: The name of the field, used internally to reference the user's input
  • Caption: The leading question or prologue before the field
  • Track Changes: Keeps track of changes made to this field

Special Options for Field

  • Grid Contracted – Display the grid in a contracted format.
  • Aggregated Function – Display a single summary value from the grid.

Services

  • Enable Map Service: displays the map icon next to the field name that will launch the user’s selected map service and display a map of the content of the field
  • Enable People Search Service: displays the search Internet icon next to the field name that will launch a variety of search services and display the contact details from those services
  • Enable Organization Search Service: displays the search Internet icon next to the field name that will launch a variety of search services and display the organisations details from those services

Value Stores To

  • Custom Field: Enables linking two different custom fields to the same user data

Field Formatting Options

  • Width: Determines the width of the field
  • Height: Determines the height of the field
  • Number Format: Formats any numbers entered into this field
  • Style: Bold, Underline, Italic, Highlight
  • Tool Tip: Enter help text to be shown on mouse-over
  • Read Only: Checkbox
  • HTML Tag: Additional attributes to the field HTML tag
  • Visibility Condition: Conditions upon which the field is visible

Role - Field Permissions

These fields allow you to control who is allowed and who is denied viewing and/or modifying the field. 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.