Zoho spend logo Help Docs

Custom Field Data Types

Depending on the module, you can create custom fields using the following data types. These are the data types available for custom fields in Zoho Spend:

Text Box (Single Line)

Select the Text Box (Single Line) data type to record any additional information. You can enter a short text, numerical value, or a combination of both up to 255 characters. Only A-Z, 0-9, and special characters are supported.

Email

You can record additional email addresses using this field. For example, patricia.boyle@zylker.com.

URL

You can record and save website URLs using this field. For example, https://www.zoho.com/spend.

Fill in the following additional fields:

  • Hyperlink Label: Instead of simply displaying the URL, you can provide a label which will be hyperlinked using the URL and displayed. For example, if the URL is www.example.com and the Hyperlink Label is Visit the Example Website, then it’ll be displayed as Visit the Example Website.

Phone

You can use the Phone data type to store additional phone numbers. For example, (123)-456-7890.

Number

The Number field can be used to store whole numbers and negative numbers. For example, 7 or -7.

Decimal

This field allows you to record decimal values that are positive or negative. For example, 12.90 or -94.53.

Amount

This field allows you to record the amount along with the default currency code set for your organisation. For example, USD50, GBP76, AUD30 etc.

Percent

You can use this data type to record values in percentage. For example, 100%.

Date

In this field, you can record custom as well as relative date values. For example, Custom Date: 19 Dec 2025, Relative Date: Today, Tomorrow, Starting Date of Month etc.

Date and Time

The Date and Time data type is used when you have to display both the date and time values. It displays the value in YYYY-MM-DD HH:MM format. For example, 2025/12/20 13:00.

Check Box

Using the Check Box data type, you can confirm an action or a fact, or enable an option. Here, you can also choose to have the check box ticked by default, if required.

Auto-Generate Number

You can auto-generate values with prefixes or suffixes, and a starting number of your choice. For example, PR-00001.

Fill in the following additional fields:

  • Starting Number: Enter the starting number of the series (for example, 00001). The first record will use this starting number, and the subsequent records will increase by 1.
  • Prefix: Enter the text or number to place at the beginning of each value in the series. This field is optional.
  • Suffix: Enter the text or number to appear at the end of each value in the series. This field is optional.
  • Add to existing records: Check Add this custom field to all the existing records and auto-generate the number in all of them if you want the numbers to be generated for all existing invoices as well. This is a one-time setup, and this setting cannot be changed later.

You can use the Dropdown data type in scenarios where you have to select one option from the list of options provided.

Fill in the following additional fields:

  • Dropdown Options: Add the required options in the text boxes in this section. The following are the methods by which you can add more options.
  • Add Individual Options: Hover over an options and click the + icon.
  • Add Options in Bulk: Click + Add Options and select Add options in bulk. Enter the required options. Each line will be considered as separate options. Click Add Options.
  • Add Predefined Options: Click + Add Options and select Use Predefined Options. You can choose from Days of the Week, Months of the Year, and Countries. Click Add Options.

Note: You can delete or mark an option as active or inactive by hovering over it, clicking the More icon, and selecting the required action.

  • Add Color to Options: Enable this option to add color to the dropdown options. Once enabled, you can choose a color for each option from the dropdown next to it.
  • Color Placement: Choose how the color should appear. You can select Next to Option or Wrap Option.

Multi-Select

The Multi-Select data type is similar to the dropdown data type. Using multi-select, you can select up to 30 options from the list of options available.

Fill in the following additional fields:

  • Dropdown Options: Add the required options in the text boxes in this section. The following are the methods by which you can add more options.
  • Add Individual Options: Hover over an options and click the + icon.
  • Add Options in Bulk: Click + Add Options and select Add options in bulk. Enter the required options. Each line will be considered as separate options. Click Add Options.
  • Add Predefined Options: Click + Add Options and select Use Predefined Options. You can choose from Days of the Week, Months of the Year, and Countries. Click Add Options.

Note: You can delete or mark an option as active or inactive by hovering over it, clicking the More icon, and selecting the required action.

  • Add Color to Options: Enable this option to add color to the dropdown options. Once enabled, you can choose a color for each option from the dropdown next to it.
  • Color Placement: Choose how the color should appear. You can select Next to Option or Wrap Option.

Lookup

The Lookup data type allows you to pull data from one module and display it inside another module.

The Text Box (Multi-line) data type also lets you to record any additional information of your choice. You can enter text, numerical value, or a combination of both up to 36000 characters. Only A-Z, 0-9, and special characters are supported.

Attachment

You can use the Attachment data type to add files such as documents, PDFs, and images. The formats supported for each file type are listed below:

  • Images: GIF, PNG, JPG, JPEG, BMP, TIF, and TIFF types.
  • Documents: XLS, XLSX, DOC, DOCX, XML, CSV, PDF and TXT types. You can attach one file whose size limit is less than 7 MB.

Formula

Formula data type in a custom field enables you to build a formula that performs calculations using predefined functions, fields, and operators. This formula will then be executed and the output will be displayed in the custom field.

The formula data type consists of three elements:

  • Function: A function performs a specific action based on the values that you provide as input and generates a new value as output. To create a function, enter the function name followed by a set of parenthesis. For example: Abs(), Ceiling(), etc.
  • Argument: An argument is the value given within the parenthesis of a function. It can be a number, text, or other function. If there is more than one argument, you can separate them using commas. For example: Max(20, 5, 45), etc.
  • Operator: An operator is the mathematical symbol using which arguments in the function perform calculations. For example: If(2==2), etc.

Fill in the following additional fields:

  • Service: Click the text box next to External Field to view this field. Next, select one of the available Zoho apps from the dropdown.

External Lookup

Select one of the available Zoho apps and lookup data from one of its fields.

Image

Use the Image data type to upload an image to a record.

  • Maximum Size: 5 MB.
  • Supported Formats: JPG, JPEG, PNG, and BMP.

To display the Image custom field in PDFs, you need to add the placeholder for the custom field in the required section of the PDF template. To do this, open the required PDF template, navigate to the Header & Footer section, expand the Footer tab, click Customise your footer content, and then click Insert Placeholders. Select the Image custom field’s name from the dropdown and click Preview.

Note: Unlike the Attachment data type, an image added using the Image data type will be visible directly on the record’s Details page. In the Attachment data type, only the file name is displayed, and you must click the file name to view the image.

ON THIS PAGE