Page Comparison

Before creating a dataform, consider:

• The type of data you need to track
• How that data will be used in ClientSpace and other systems
• The relationship between the new dataform and others in your system

Advanced planning can save time after you publish the dataform and start to collect data. 

After you have determined how you would like to build out your new dataforms, you can begin the process. The first step is to add the dataform. This process creates a new table in the SQL database with the pre-determined system columns.

Form properties control the basic properties of the SQL table, such as Table Name. After saving the initial dataform, you cannot change the basic properties of the SQL table. Therefore, be sure to plan carefully before you save. Consider the name of a dataform carefully because the only way to change a table name is to delete the dataform and any data you may have stored in it and start over.

The field Dataform Name is simply a label and can be changed after the initial save to provide a more descriptive title of the dataform. However, the best practice is to make the table name as short as possible while still being descriptive. For example, you may want the title of the dataform to read as Family Medical and Leave Act Data. A better table name would be gen_zFMLA.

To accomplish this:

• Save the form initially with a dataform name of FMLA.
• Change the Dataform Name field to the more descriptive Family Medical and Leave Act Data.

Dataform Configuration 

Anchor
NextFormAdmin NextFormAdmin

The Dataform Properties form presents the fields in groups. The first step is to configure the general properties such as name, type, field, group, and description.

To customize your dataform:

1. Use the following image and field descriptions as a guide.
   • Dataform Name: The name of the dataform that is displayed within the application such as in lists where you select a dataform.
   • Dataform Type: Select the type: Standard, Organization, or Contact.
   • Dataform Group: Use grouping to organize dataforms into tiles on the Workspace Landing page. You can use the group as a search parameter when modifying a dataform or adding a new dataform to a workspace.
   • Description: Provide a brief description of the dataform and its purpose.
     
     
     
     
     
     
2. After you configure this first section, click Apply.

  After you Apply changes, then you will see the Table Name and Default Field fields. 

• Table Name: Displays the generated table name that is stored in the database. This can be useful for reporting. You cannot edit this field.
• Default Field: When you associate one dataform with another through linked fields, the default attribute is displayed in the select list. It is a best practice to make the default attribute field of the form Required, so any linked forms will have something to display.

Action Center

The next step is to secure the form, add and configure fields, and add and configure tabs. These actions are performed in the Action Center pane (on the right side of the screen).

To continue with the configuration:

1. In the Action Center, select Secured, Fields, or Tabbed Forms.
   
   
   
   
2. Use the following field descriptions to guide you through the configuration.
   • Secured : Secures the form and generates a security entity for the field in the format of gen_TableName. For more details about using security entities in Role security, review Organization and Workspace Security Configuration.
   • Fields: This is where you add and configure fields for this dataform (see Fields Configuration).
   • Tabbed Forms: This is where you add and configure tabs for any foreign key related child forms of this dataform. (Child forms have a Parent form field that uses this dataform as the Parent Form. See Adding Tabbed dataforms.) 
3.  Apply your changes as you navigate the various panels for Secured, Fields, and Tabbed Forms.

Actions and Developer Settings

The next step is to configure the actions for your dataform. The following fields are in the Actions and Developer Settings of Dataform Properties.

To further customize your dataform:

1. On the Dataform Properties form, locate the Actions area, where you will find an array of checkboxes.
2. Use the following field descriptions to guide you through the configuration.

• Can Have Multiple: Single vs. Multiform. Dataforms come in two basic flavors:
• The Single form (such as the Client Master) has a one-to-one relationship with the Workspace. This is great for recording specifics about an individual or client where there is only ever one item, and if it changes you need to update it.
• The Multiform (such as locations) has a one-to-many relationship with the workspace. This is great for recording multiple instances of something, such as physical locations for a client, or paycheck records for an employee.
• Search On Load: Multiforms present as a list of records, whether this list is populated automatically when you land on the dataform or have to click Search to populate the list is a function of search on load.
• Secure Attachments: Secures attachments for this dataform.
• Show on Landing Page: Indicates the dataform will be available at the bottom of the various types of Landing pages in our Next application under dataform search. Leave this unchecked if you only want to display the form in Next as a tabbed or linked dataform.
• Exclude from BI: Checking this box removes the dataform from the list of available tables in the Datasources section of Business Intelligence, effectively hiding the dataform from reporting.
• BI Name: If completed, the "friendly name" stored in this field will display in Business Intelligence reporting.
• Task Category: On creation of a task record from this dataform, the category field of the task defaults to the selected value.
• Time Category: On creation of a time tracking record from this dataform, the category field of the record defaults to the selected value.

Developer Settings

• Time Category Function: This option requires custom development and allows you to override the default Time Tracking Category.
• Icon CSS Class: This field defines the type of icon that will be displayed for this form on the workspace landing page.
• Include Activities in Notifications: Specifies if Activities (CRM Notes) are included in dataform notifications.

Features

Next, customize the Features areas.

To further customize your dataform:

1. On the Dataform Properties form, locate the Features area, where you will find an array of checkboxes.
2. Use the following field descriptions to guide you through the configuration.

• Enable Tasks: Adds the My Tasks action item to the dataform . Tasks added from this dataform are linked to this dataform.
• Enable Attachments: Adds the Attachment Action Item to the dataform, providing the ability to attach files to the dataform.
• Enable Subscribers: Adds the Subscribers Action Item to the dataform, which allows you to automatically notify system users via email of changes to the form.
• Enable Subscription Emails: This field sets which notification system is used when producing dataform subscription emails. If checked, a core system notification is produced when the record is changed. If checked and a published Email Template has been configured for this dataform, that template is used. If unchecked and no template exists, subscription emails are not sent.
• Enable Activities: Determines whether Activities may be attached to and displayed on this dataform.
• Enable Time Tracking: Adds the Time Tracker action item  to the dataform. Time tracked from this icon is linked to this dataform.
• Enable WFC Cloning: Used by Workflow Channels to determine whether dataforms are available as "Triggered Forms" during workflow dataform cloning.
• Enabled Triggering: Used by Workflow Channels to determine whether dataforms are available as "Triggering Forms" during the initial channel configuration.

Adding Dataform Tabs 

Create the tabbed dataform(s) in Dataform Administration, ensuring that you include a Parent Form datatype field, configured to point at the Parent form where you would like the tab to appear.

To add dataform tabs:

1. Go to System Admin  > Advanced > Dataform Admin.
   The Dataform Admin list is displayed.
2. Search for the Parent Dataform and click  Form Properties.
   The Dataform Properties form is displayed.
3. In the Action Center, click Tabbed Forms.
   The Tabbed Forms list is displayed.
4. Click Add.
   The Tabbed Form dialog opens.
   
   
5. In the Dataform list, select the tab dataform.
6. Provide a Display Order (this is the order in which the tabs will appear at the top of the dataform). The display order is numeric.
7. Click Ok.

To add fields for storing information that you want to track:

1. Go to System Admin  > Advanced > Dataform Admin.
   The Dataform Admin list is displayed.
2. From the list, select an entry and click Edit or click  (Jump).
   The Dataform Properties form opens.
3. In the Action Center, click Fields.
   The Fields list of the dataform is displayed. From here you can Open, Delete, and Add (New) fields.
4. Click  (New).
   The New Field form opens.
   
   
   
5. Use the following field descriptions to continue the configuration. 
6. Click Apply when you are done.
   • Element Type: Determines the type of data you will store in this field. In the example, we selected the Lookup (core) datatype, but ClientSpace has a full array of different datatypes. The most commonly used datatypes can be found in the section Configuring your Dataform - Datatypes. For an in-depth look at the Lookup datatype used in our example, see Adding Or Configuring Lookups.
   • Field Set: Outlines that hold and organize other fields. No actual SQL field is created and no data can be stored in a fieldset.
   • Field Label: The field label is displayed on the dataform. By default, the underlying field name is set to the field name with any spaces or special characters removed. Click on the field name to open the field properties page.
   • Field Name: The name of the field that is created on the SQL table. By default, the field label is stripped of its spaces and special characters and used as the Field Name. The field name can be overridden as needed and can be set to anything that is accepted by SQL Server as a valid field name. Duplicate field names are not accepted. Field labels are often duplicated in developing large dataforms. As duplicate fields are created, you must modify the field name to make it unique in order to save the field. After the field is saved the first time, the field name CANNOT be changed. Carefully map out your field naming standards before creating dataforms. ClientSpace utilizes a standard naming convention when naming a field based on the datatype of the field. It is a recommended best practice to utilize these same conventions in your own field names. To discover the best practice for your field type read Dataform Field Naming Standards.
   • Row: The row property determines the vertical ordering of fields and fieldsets. Fields that are within a fieldset are ordered within that field set. Though the sort uses a standard numeric order, it is recommended that rows are initially set in increments of ten. This allows for re-ordering fields or adding fields between rows without re-ordering the entire form.
   • Column: The column property is hardcoded to dictate a two-column format. Technically, you are able to select the same row and column for more than one field and they will align alphabetically. This will generally cause problems in the presentation of the dataform to the user.
   • Field Behavior 
     • ReadOnly: This field cannot be edited. Normally these fields are set automatically by business logic.
     • Required: This property can only be set from within the field properties page. When selected, the field must be completed for the dataform to be saved. **This function is overridden if the field is contained in a hidden field set.** 
   • Length: Defines the maximum length of the field entry. This property is valid for text and integer data types.
   • Comment: The text in Comment provides contextual help for dataform users. When comments are added to any dataform field, the info bubble next to the field label is enabled and on hover, the info bubble displays the comment text in a popup.
   • Quick Search: Selecting a value in this dropdown adds the field to the Quick Search on multi from searches. Available options (quick search types) include Starts With, Equals, Contains (% search).
   • Form Searchable: Is this one of the Search parameters available in a multiform list? This property can be set from the form list page or from within the field property page.
   • Secured: Secures the field and generates a security entity for the field in the format of gen_TableName_FieldName. For more in-depth documentation about using security entities in Role security, review ClientSpace Organization and Workspace Security Configuration.
   • Active: Determines if the field appears on the dataform. De-Activating a field is preferential to deleting it because deleting the field removes it from the underlying SQL table and erases the data. When you de-activate or hide a field, you retain the data for later use.
   • Hidden: This property is only available for Field Sets. When selected, the field and its children are hidden when a dataform record is viewed.
   • Index this field: Marks the field for addition to the SQL table index; you can make searches based on this field faster.
   • Audit this field: Marks the field auditable and is configured in System Admin > Advanced > Tables.
   • Cloneable: Marks the field as configurable when this dataform is created by Workflow and Email templates.
   • Triggerable: Marks the field as available for use as a Triggering Field or as one of the Triggering Conditions when configuring Workflow Channels and Email Templates. When a field is marked as Triggerable, it displays in the field list on Email Templates and Workflow Channels.
   • Allow Dataform Notification: If selected, this field is included in a dataform notification when dataform subscribers are emailed. Updated fields appear in bold in this email. 

Available field actions

When viewing the list of dataform fields, note the available actions:

Action	Action label	Description
	Open	Opens the field properties for the highlighted field.
	Delete	Deletes the highlighted field.  For system fields, the Delete action is not available and displays as disabled. System fields can be easily identified because their field names do not begin with z_.
	New	Adds a new field.
	Save	Saves changes to the dataform fields list.

Deleting a dataform field

A few situations can exist that prevent a field from being deleted:

1. The field is a system field.
2. Other system configurations depend on the field.

For system fields, the Delete action is not available and displays as disabled. System fields can be easily identified since their field names do not begin with z_.

Dataform fields that are referenced by system functions, e.g., rules, links, or field display conditions, cannot be deleted until their dependencies are removed. If you try to delete a field that has a dependency, an error message is displayed in the delete dialog: "This field is used by the following System functions and cannot be deleted while these dependencies are in place: System Function". From the delete dialog, you can open the dependency.

After you Save the configuration, you can then view the form from Admin Workspace.

1. Go to System Admin  > Administrative Data > <groupname>.

   Where <groupname> matches the Dataform Group value you selected during the initial Dataform Properties add process.

2. Alternatively, click Admin Workspace from your modules bar (if you added to your modules bar).

3. In Admin Workspace, open the group, and within the group open the form.

4. Click Add.

   The form is displayed.

The following images illustrate:

• Dataform field mapping during the Add process

• The completed form, viewable through Admin Workspace