Data Field Types and Field Type Conversions

Follow

Data Field Types

Several different types of data fields can be added to a Form. When you are adding a field, use the dropdown list to select the one best suited for the type of data you wish to collect. The table below lists the available Data Field Types and gives a short description of each.

Field Type Conversions

Once you create a data field, the types of fields into which you can convert it are limited. For example, you can easily convert a Checkbox to a Dropdown List. However, to convert a Dropdown list to a Checkbox, the Dropdown list (Original Field) must be a Yes/No list.

The table below lists the Original Field Type, the Conversion Field Type (the type of field it can be changed to) and the Original Field Requirements (the way the original field must be set up in order for it to be converted).

TABLE OF CONTENTS

 

Data Field Types and Descriptions

Data Field Type

Description

CEEB Lookup - College

Allows users to look up their College CEEB code.

CEEB Lookup – High School

Allows users to lookup their High School CEEB code.

Check Box

Allows users to select a True (checked) or False (unchecked) value. Includes the option to Customize Values:  Select the desired Import/Export Values and Display Values from the dropdowns.

Check Box Series

Allows users to select one or more True/False options. The values are stored by a required delimiter (a single character, like a comma) that divides the data.

Commerce Amount Field

This is an open amount commerce field.

Commerce Dropdown Displays a list of options in a dropdown format. (Fair Market Value setting is only available on events.)

Commerce Item Field

This is a combination item amount / price field.

Country Drop Down List Allows users to select a Country value from a pre-defined list that cannot be changed.   This is the Country field that is required for use with Address Validation.

Date Box

A text box pre-formatted to accept only data in M/D/YYYY format.

Date Time Box

A text box set, one of which is formatted to accept M/D/YYYY dates and the other which is formatted to accept H:MM AM or H:MM PM.

Drop Down List

Allows users to select a value from a list you define. You will specify the options and associated data values.

Email Forwarding Address Email forwarding must be configured for your site by iModules before you can use this data field type.  Contact your Acct. Mgr. for more information.

Email Text Box

Pre-formatted to accept an email address (text in a name@domain.com style format).

Email Text Box Confirm

Requires a user to repeat the information they entered into an email textbox and then checks that data against the original data to make sure both entries are identical. This insures that good information is collected.

File Upload

Allows a user to search his / her hard drive for a file and submit it to the server. File size must be less than 10MB. If you have multiple File Upload fields on a form, the total of all the files must be under 10MB.

Hidden Value

A value that is automatically set upon a member completing a given step or form.

Data Field Type

Description

Label

A static area to display text to the user.

ListBox

An open box showing several items from which a user may select only one. You will specify the options and associated data values.

MultiSelect Box

Allows users to select multiple values from a list you define. You must specify the Field Delimiter Character (such as a , or ;) that will divide the data options.

Password Box

A text input box that displays asterisks (*) in place of the actual characters a user types.

Radio Button Series

Provides users with a list of items from which they may select only one. You will specify the options and associated data values.

Rich Text

A text entry area that allows the users limited data formatting (such as bolding or italicizing the text).

State Drop Down List Allows users to select a State value from a pre-defined list that cannot be changed. This is the State field that is required for use with Address Validation.

Text Box

Allows users to enter any combination of letters and numbers (99 character limit).

Text Box Confirm

Requires users to repeat the information they entered and checks that data against the original data to make sure both entries are identical. This insures that good information is collected.

Text Box – Currency Decimal

Requires users to enter a numerical, decimal amount

Text Box Distinct

This requires a value to be entered that has not been used by other members of the online community.

Text Area

A text entry box that can accommodate multiple lines of text. (Character limit is over 2 billion; however, the default character export will be limited to 1,000 characters.  NOTE:  Support can increase this to 4,000 if needed.)

Text Area Large

A large text entry box that can accommodate longer entries. (Character limit is over 2 billion; however, the default character export will be limited to 1,000 characters.  NOTE:  Support can increase this to 4,000 if needed.)

Time Zone Drop Down

A dropdown box that lists time zones (such as Eastern, Central, Mountain or Pacific Standard / Daylight time).

Time Box

A text box that is pre-formatted to accept text in an H:MM AM or H:MM PM format.

 

Field Type Conversions

Original Data Field Type

Conversion Field Types

Original Field Requirements

Check Box

Drop Down List

List Box

Radio Button Series

 

Check Box Series

MultiSelect Box

 

Commerce Amount Field

Cannot be converted

 

Commerce Item Field

Cannot be converted

 

Date Box

Date Time Box

 

Date Time Box

Date Box

Time Box

 

Drop Down List

List Box

Radio Button Series

Checkbox

Label

Hidden Value

 

 

Must be Yes/No

Must be Alphanumeric

Must be Alphanumeric

Email Text Box

Email Text Box Confirm

Input Box

Input Box Confirm

Label

Password Box

Hidden Value

 

Email Text Box Confirm

Email Text Box

Input Box

Input Box Confirm

Label

Password Box

Hidden Value

 

File Upload

Cannot be converted

 

Hidden Value

Email Text Box

Input Box

Input Box Confirm

Label

Password Box

Email Text Box Confirm

 

Input Box

Email Text Box

Hidden Value

Input Box Confirm

Label

Password Box

Email Text Box Confirm

 

Input Box Confirm

Email Text Box

Hidden Value

Input Box

Label

Password Box

Email Text Box Confirm

 

 

 

 

Original Data Field Type

Conversion Field Types

Original Field Requirements

Label

Email Text Box

Hidden Value

Input Box

Input Box Confirm

Password Box

Email Text Box Confirm

 

List Box

Drop Down List

Radio Button Series

Check Box

Label

Hidden Value

 

MultiSelect Box

Checkbox Series

 

Password Box

Email Text Box

Hidden Value

Input Box

Input Box Confirm

Label

Email Text Box Confirm

 

Radio Button Series

Drop Down List

List Box

Check Box

Label

Hidden Value

 

 

Must be Yes/No

Must be Alphanumeric

Must be Alphanumeric

Rich Text

N/A

 

Text Area

Text Area Large

 

Text Area Large

Text Area

 

Time Zone

Cannot be converted

 

Text Box – Currency Decimal

Cannot be converted

 

Time Date Box

Cannot be converted

 

Have more questions? Submit a request