Field Types
AI field types
Zoho Tables understands, interprets, and generates human language with its AI field types. These field types can often make work management easier by doing things like extracting quick information from lengthy text data, interpreting customer ...
Formula
A formula is an expression used to perform an operation by computing values between different fields in a table.The Formula Field in Zoho Tables allows you to compute the results of the formula entered and displays those results in that field. It ...
URL
The URL field is designed to accommodate URL, the link to a website or webpage. It hyperlinks the text and opens up in a browser when we click on it. How does it work? Select the URL field, by clicking the + icon from the field header. Your URL field ...
Text
The text field is intended to accommodate any character, including symbols and numbers, besides text. How does it work? Select Text field. By clicking on the + icon from the field header, your text field is now created. To customize the text field ...
Rating
The Rating field is to rate your records based on the priority or quality of the task. How does it work? Select the Rating field, by clicking the + icon from the field header. Your field is now created. To customize the rating field Click the ...
Phone Number
The phone number field type identifies the numbers in the field as phone numbers and hyperlinks it. How does it work? Select phone number from the list of field types, by clicking the + icon from the field header. The field is now ready for phone ...
Percentage
Percentage fields display numbers as percentages. You can also input negative numbers. How does it work? Select the Percentage field from the list of fields available. Choose the Precision value ranges from 1.0,1.00, 1.000 and None. Enable/Disable ...
Number
The Number field is exclusive to accommodate only numbers. You can also input negative numbers. How does it work? Select Number from the list of field types, by clicking the +icon from the field header. Choose the Precision value ranges from 1.0, ...
Modified Time
The Modified Time field type displays the date and time when the user most recently modified the record. How does it work? Select Modified Time from the list of field types, by clicking the + icon from the field header. You can choose between four ...
Modified By
The modified by field type displays the name of the collaborator who has made changes in the record most recently. It gets updated whenever a record is created or edited in your table. How does it work? Select Modified By from the list of field ...
Multi Select
Multiselect works the same as the single select field. You can select options from the predefined list, except that you can choose more than one option in a record. How does it work? Choose Multi Select from the list of fields available. This opens ...
Single Select
When there is a repetitive appearance of certain expressions in a field, you can prefer a single select field rather than manually entering the terms repeatedly. You can choose only one option from a drop-down menu with multiple predefined choices. ...
Email
The Email field type marks a field exclusive to email addresses and hyperlinks it, so you will be routed to your system's default mail client to draft an email. This field type is mainly used for tracking your leads, and clients by entering their ...
Date
Entering a date in a cell is easy with a date field. You get to choose a specific date, and time format for display. You can choose between 4 different date formats, and 2 time formats to display. Upon selecting the date field, you can choose a ...
Currency
The currency field type customizes a field with international currencies. The currency types supported are: US Dollar European Euro British Pound Japanese Yen Canadian Dollar Australian / New Zealand Dollar Chinese Yuan Fr. Swiss Franc Singapore ...
Created Time
The Created Time field populates the records with the date and time of its creation. There are four different date formats and two time formats to choose from. By default, the 12 hr time format is selected. Note: Since the date and time of record ...
Created By
The Created By field type will automatically display the name of the collaborator who originally created the record. How does it work? From the list of field types, select the Created By option. Each record of the table now displays the names of ...
Collaborator
The collaborator field allows you to add one or more people to the record, from the dropdown list of collaborators with whom the base is shared. How does it work? Select the collaborator field from the list of field types To add more collaborators to ...
Checkbox
The Checkbox field type can be used when you want to add an affirmation indicating the completion of a task. Checkboxes are available in several styles, based on your needs. The Style drop-down list allows you to select the style of the ...
Autonumber
Autonumber fields automatically assign a unique, incremental number to each record, making identification easy. Note: The Autonumber field is not intended to count the number of records in a table. When a record is deleted in between, the rest of the ...
Attachment
The attachment field type allows you to add one or more files to individual records in the below formats. Documents Images Spreadsheets Presentations Videos & Audios Emails PDFs Developer file formats You can even preview the attached files and also ...