Data type |
Use to represent |
Combination |
Combinations of values of fields and text in a column (table) or row (card). You can specify whether to show each field or show only the first non-empty field. You can also combine text with fields without the use of quotation marks. For examples of combination fields you can create, click . |
Currency |
Numeric data as currency or mathematical calculations that involve money. |
Date/Time |
Date and time data. |
Duration |
Numeric data. You can enter a duration as minutes, hours, or days. Values are saved as minutes. |
Formula |
Calculations based on standard and custom fields. You can use any appropriate functions and operators to complete the formula. For examples of formula fields that you can create, click . |
Integer |
Non-decimal numeric data. |
Keywords |
When filled in, this user-defined field is used to group and find related items similar to the way the Categories field is used in Outlook. Text with multiple values to be separated by commas. Each value can be grouped individually in a view. |
Number |
Numeric data or mathematical calculations except those that involve money. (For money, use Currency data type.) |
Percent |
Numeric data as a percentage. |
Text |
Text or combinations of text and numbers, such as addresses. Can be up to 255 characters long. |
Yes/No |
Data that contains only one of two values, such as Yes/No, True/False, On/Off. Yes/No fields can also be displayed as or . |