Data types of Zoho Creator fields
The following table displays the data type of each Zoho Creator field:
| Field Type | Data Type |
| Name | TEXT |
| TEXT | |
| Address | TEXT |
| Phone | TEXT |
| Single Line | TEXT |
| Multi Line | TEXT |
| Number | NUMBER |
| Date | DATE-TIME |
| Time | TIME |
| Drop Down | TEXT |
| Radio | TEXT |
| Multi Select | LIST (containing only text elements) |
| Checkbox | LIST (containing only text elements) |
| Decision box | BOOLEAN |
| Rich Text | TEXT |
| URL | TEXT (containing HTML) |
| Image | LIST (containing HTML) |
| Percent | DECIMAL |
| Currency | DECIMAL |
| Decimal | DECIMAL |
| Date-Time | DATE-TIME |
| Lookup - Dropdown/Radio | NUMBER |
| Lookup - Multiselect/Checkbox | LIST (containing only number elements) |
| Signature | TEXT |
| File upload | TEXT |
| Audio | AUDIO |
| Video | VIDEO |
| Auto Number | NUMBER |
| Formula | TEXT/DECIMAL/NUMBER/BOOLEAN/DATE-TIME |
| Add Notes | TEXT |
| Users | TEXT |
| Integration | TEXT |
| Prediction | NUMBER/DECIMAL/LIST/TEXT/DATE-TIME |
| Keyword Extraction | TEXT |
| Sentiment Analysis | TEXT |
| Text Analysis (OCR) | TEXT |
| Object Detection | TEXT |
Note:
- Subform field is an advanced field type, which contains fields of varied data types. So, a subform field does not take any data type as such. However, we can refer to the fields in the SubForm as <SubForm_Name>.<SubForm_Field>.
- Section is not meant to collect data. So, it does not take any data type.
- Formula field can contain expressions which can resolve to any one of decimal, number, text, boolean, date-time or time values. Hence, the resultant expression's data type will be the data type of the formula field.