Select a field type based on the purpose of the new field. The following table lists the available field types and describes when to use each one.
Create an address field that consists of:
Street
City
State or Province
Zip or Postal Code
Country (optional).
The labels of these field components are fixed and cannot
be changed.
Additional properties for Address fields:
Include Country: Indicates whether or not to display the Country as part of the address. Turning off this option hides the Country in the Address field. If Country information already exists, the information is preserved in the database; it is just not displayed.
Create a calculated field. A calculated field displays the resulting value of the formula you entered for computation of fields in the record.
Additional properties for Calculated fields:
Display As: Choose a format that will be used to display the result of the calculation. The possibilities are Currency, Date, Number, and Text
Currency Type: When displaying as Currency, choose the currency symbol display.
Decimal Places: When displaying as Currency or Number, choose the number of decimal places to display.
Thousand Separator: When displaying as Currency or Number, specify the symbol to use for the thousands grouping, for example the commas in $3,125,000.
Decimal Separator: When displaying as Currency or Number, specify the symbol to use as the decimal place indicator, for example the period in $27.32.
Date Format: When displaying as Date, specify the date format.
Learn more about how to write formulas for calculated fields.
Create a checkbox. You can specify whether the checkbox is checked by default and what the label next to it says.
Additional properties for Checkbox fields:
Checkbox Text: Specify text to appear to the right of the checkbox (optional).
Tip: If you want to create a filter based on a checkbox field, keep in mind that the value of a checkbox field is either True, if the box is checked, or False, if it is not. When you create the filter, select the operation is equal to. For example, suppose your team has an issue-tracking database that contains a checkbox field called Urgent. When a user enters a new issue in the database, they check the Urgent field if the issue must get resolved quickly. You can create a view that displays all issues marked Urgent by including the filter Urgent is equal to True. Learn more about view filters.
Display a list of names from your site's Contacts application.
Additional properties for Contact List fields:
Link to Profile: Indicates whether the contact's name appears as a link to the Detail page for that contact.
Note: Because it is derived from the Contacts application, this field type is not available when defining fields for the Contacts application.
Create a field where members can enter a currency amount, such as for goods or services.
Additional properties for Currency fields:
Currency Type: Choose a currency format, such as U.S. Dollars.
Decimal Places: Choose the number of decimal places to display.
Thousand Separator: Specify the symbol to use for the thousands grouping, for example the commas in $3,125,000.
Decimal Separator: Specify the symbol to use as the decimal place indicator, for example the period in $27.32.
Min & Max Values: Specify the minimum and maximum values that users can enter into this field (optional). The Min & Max Values must be between -999,999,9999 and 999,999,9999.
Tip: If you wish to filter on a Currency field using a negative currency value, use the negative sign. For example, "Loss Amount is less than -$100.00". You cannot use parentheses, "($100.00)", to indicate negative amounts in a filter.
Learn more about view filters.
Create a link to another database. This will allow you to include fields from another database in your views, or to include a drop-down list from another database on your data entry form. Learn More.
Additional properties for Database Relation fields:
Source Database: Specify the database you want to link to.
Field: Choose the field that you want to link to in the Source Database. Not all fields are available for linking; for example, you cannot link to a File or Checkbox field. If a field does not appear in the Field list, it is not available for linking.
Link to Record: Choose whether to display this field as a clickable link to the record in the Source Database or as just text.
Create a field where users can select a date. Dates are not adjusted for a member's local time zone; they are always displayed as entered.
Additional properties for Date fields:
Date Format: Choose a display format for the date. There are nine date formats to choose from.
Format----------------------->Example
mm/dd/yy-------------------->01/25/99
dd/mm/yy-------------------->25/1/99
mm/dd/yyyy----------------->01/25/1999
dd/mm/yyyy----------------->25/1/1999
dd Mon yyyy---------------->25 Jan 1999
dd Mon------------------------>25 Jan
Month dd, yyyy------------->January 25, 1999
Day, dd Mon yyyy--------->Monday, 25 Jan 1999
Day, Month dd, yyyy----->Monday, January 25, 1999
Tip: While you can use any of the formats above to display a Date field, when using a comparison operator (such as "greater than," "less than," "is equal to"), you must use the mm/dd/yyyy date format in the filter. For example, to create a view that shows all sales in November of 2003:
Create a filter that says: Sales Date is greater than 10/31/2003.
Then use And to combine it with a filter that says: Sales Date is less than 12/01/2003.
When using the "contains" and "does not contain" operators, you enter your dates differently. These filters work by converting date values to strings, using the Mon dd yyyy format. The value you provide in the filter is compared to the converted string. With containment filters, you do not have to enter an entire date; you can specify just the month or just the year. For example, Birthday contains Aug will show all birthdays in the month of August. For more information about creating date filters, click here.
Tip: You can filter Date fields by using the filter constant Today to create views that display only records with today's dates, or dates that are in the future or the past. Just set up a view filter by picking the Date field you wish to use, then choosing the appropriate operator such as "equals" or "greater than", and then selecting Today from the dropdown. For example, "Birthday equals Today", would create a view that showed only those people whose birthdays occur today, no matter what day today actually is.
Learn more about view filters.
Create a field where users can select a date and time. Date and times are not adjusted for a member's local time zone; they are always displayed as entered.
Additional properties for Date and Time fields:
Date Format: Choose a display format for the date. There are nine date formats to choose from.
Format----------------------->Example
mm/dd/yy-------------------->01/25/99
dd/mm/yy-------------------->25/1/99
mm/dd/yyyy----------------->01/25/1999
dd/mm/yyyy----------------->25/1/1999
dd Mon yyyy---------------->25 Jan 1999
dd Mon------------------------>25 Jan
Month dd, yyyy------------->January 25, 1999
Day, dd Mon yyyy--------->Monday, 25 Jan 1999
Day, Month dd, yyyy----->Monday, January 25, 1999
Time Format: Choose a display format for the time. There are two time formats to choose from:
12-hour (10:22 PM)
24-hour (22:22)
Tip: While you can use any of the formats above to display a Date and Time field, when using a comparison operator (such as "greater than," "less than," "is equal to"), you must use the mm/dd/yyyy date format and the 24-hour time format in a view filter. For example, to create a view that shows all meetings that start at 1:00 pm, create a filter "Meeting Start is equal to 01/25/2003 13:00".
When using the "contains" and "does not contain" operators, you enter your dates and times differently. These filters work by converting date and time values to strings; the date is converted to the Mon dd yyyy format and the time section is converted to 12-hour time format. The value you provide in the filter is compared to the converted string. With containment filters, you do not have to enter an entire date and time. You could specify just the month, for example Birthday contains Aug shows all birthdays in the month of August. For more information about creating containment filters, click here.
Tip: You can filter Date and Time fields by using the filter constant Today to create views that display only records with today's dates, or dates that are in the future or the past. Just set up a view filter by picking the Date and Time field you wish to use, then choosing the appropriate operator such as "is equal to" or "is greater than", and then entering just the word Today in the text box. For example, "Task Due is equal to Today", would create a view that showed only those tasks that are due today, no matter what day today actually is. Note that the Today constant is only compared against the date portion of the Date and Time field; the time portion is ignored.
Learn more about view filters.
Create an email address input box. Members must enter values that are in the format of a valid email address, for example, myname@mycompany.com. Values entered into this field appear as a link for sending email.
Create a field where members can upload files of any type. This field is displayed as a link to the file. Users can click this link to either open or download the file. This field is not searchable.
Display a list of all the groups in your site.
Create a field where users can upload image files. If you specify a height and/or width, any images uploaded in this field will be sized to your settings.
Additional properties for Image fields:
Set Height To: Sizes the image to this height in pixels (optional).
Set Width To: Sizes the image to this width in pixels (optional).
Create a list of options for users to choose from. You can use a list that's already in your site, such as Task Projects or Task Categories, or you can create a new one.
Additional properties for List fields:
Choices: Specify whether to use an existing list or create a new list. To create a new list, type the list choices in the box provided. Be sure to put each choice on a separate line.
Options: Share list with other databases indicates whether to make the list accessible to other databases. When a list is available to other databases, it will appear in the set of existing lists for List fields.
Display Format: Indicate whether to display this field as a drop-down list or as a group of radio buttons. If this field is displayed as a group of radio buttons, the field must be required.
To edit items in an existing list:
Click Databases in the Menu.
Click the Manage
icon 
for the database that contains the list field.
On the Manage Database page, click Fields to display the Modify Fields page.
Click the name of the list field you want to edit.
In the List Properties section, click Modify List Choices.
To add a new item to the list, type the item into the text box and then click Add to List.
To delete an existing item, click the Delete
icon 
in the same row as the item you want to delete, then
click OK to confirm that you are
sure you want to delete the list item.
To rename an existing item, click the pencil icon in the same row as the item you want to rename. Change the item name in the text box, and then click Save in the Command Bar.
After finishing your edits, click Done in the Command Bar.
Display a list of names from your site's Members directory.
Additional properties for Member List fields:
Link to Profile: Indicates whether a member's name will appear as a clickable link to the Detail page for that member.
Create a field that consists of:
First name
Middle name (optional)
Last name
Additional properties for Name fields:
Include Middle: Indicates whether to include a text box for a middle name or initial. Turning off this option hides the display of the middle name in the Name field. If the middle name already exists, the information is preserved in the database; it is just not displayed.
Create a field where users can enter a number.
Additional properties for Number fields:
Decimal Places: Choose the number of decimal places to display.
Thousand Separator: Specify the symbol to use for the thousands grouping, for example the commas in 3,125,000.
Decimal Separator: Specify the symbol to use as the decimal place indicator, for example the period in 27.32.
Min & Max Values: Specify the minimum and maximum values that can be entered into this field (optional). The Min & Max Values must be between -999,999,9999 and 999,999,9999.
Create a field where users can enter a phone number.
Additional properties for Phone Number fields:
Format:
U.S. phone numbers only (no extensions):
Ensures that all phone numbers have a valid U.S. phone number format:
Example:
(781) 555-1212
Accept any phone numbers: Allows users to
enter any characters. Example:
011-89-229-9999 x288
International phone numbers: Allows users
to enter a country code and an extension. Example:
1 1-666-555-6566 x288
Create a single-line text field. If you need to allow users to enter a large amount of text, or want to allow them to enter text on multiple lines, use the Text Multi-Line field type instead.
Additional properties for Text fields:
Maximum # of Characters: Specify the maximum number of characters that users can enter in this field. The maximum must be 256 or less.
Create a text field where users can enter a large amount of text. The maximum length cannot exceed 8,192 characters.
Additional properties for Text Multi-Line fields:
Number of Lines: Specify the size of the input box by indicating the number of lines to display. This does not affect the amount of text that users can enter, just the height of the input box.
Create a field where users can select a time. Times are not adjusted for a member's local time zone; they are always displayed as entered.
Additional properties for Time fields:
Time Format: Choose a display format for the time. There are two time formats to choose from:
12-hour (10:22 PM)
24-hour (22:22)
Create a unique identifier for each record. This causes the Database application to generate a unique ID for each new database record. This field type can be useful in databases where you want to search for a particular record by ID, such as in issue tracking databases. Unique ID's are unique across all databases. You will not find the same Unique ID value in more than one database. This field cannot be edited; it can only be displayed.
Create a field where users can enter a Web address. When users enter values into this field, the Database application formats them into web links. For example, "www.mysite.com" appears as http://www.mysite.com.
Additional properties for Web Link fields:
Launch Options: Specify whether to open the link in a new browser window or in the same window as your site.
Tip: The Database application formats Web Link values using "http://". To use another protocol, such as "https://" or "ftp://", simply enter the full URL. For example, link to an SSL-protected webexone.com site by entering "https://mysite.webexone.com".