---
title: "Data Types in Tulip"
slug: "data-types-in-tulip-1"
tags: ["App Editor (Route)", "Variable", "Variables"]
updated: 2025-09-22T18:04:27Z
published: 2025-09-22T18:04:27Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.tulip.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Data types

Tulip supports several different data types across the platform. These types are important to understand as they can have implications in how you store data, usability within {{glossary.Analytics}}, and how you convert between data types.


## List of data types

The table below provides information about each data type including descriptions and supported areas, as well as any specific formats or limits.

| Type | Description  | Format  | Limits  | Area Supported |
|------|-----|------|-----|------|
| Boolean      | True or false   | True, false, yes, no   |   | Analytics, app variables, connector functions, machine activity fields, machine attributes, table fields |
| Color        | Color values that can be used to set widget coloring dynamically            | `rgb(0, 0, 0),` `rgba(0, 0, 0, 0),` `#FFFF00`    |   | App variables, machine activity fields, table fields     |
| Datetime     | Timestamp consisting of a date, time, and timestamp         | `MM/DD/YYYY HH:MM:SS` <br> See also: [custom datetime formats](/r230/docs/supported-custom-datetime-formats)         |       | Analytics, app variables, connector functions, machine activity fields, table fields       |
| Enum         | Selection of predefined constants (i.e. Machine States)        |           |       | Analytics, machine downtime, reasons, machine states   |
| File         | Link to a file, stored on cloud provider                                    | csv, doc, docx, gif, jpeg, mp4, nc, pdf, png, qif, stl, stp, svg, txt, xlsx, xls         | Max file size: `200MB` (mp4), `50MB` (others) <br> Max URL length: `2048 characters`       | App variables, table fields    |
| Image URL    | Link to an image in Tulip, stored by cloud provider   | png, jpeg, gif, svg  | Max file size: `20MB` <br> Max URL length: `2048 characters`   | App variables, table fields, connector functions, machine activity fields      |
| Integer      | Integer - a number without a fractional component      | 1, 6780, 43      | Max value: `9007199254740991`   | Analytics, App Variables, Connector Functions, Machine Activity Fields, Machine Attributes, Table Columns |
| Interval     | Amount of time in seconds, displayed as `HH:MM:SS`     | 120059     | Max value: `7730941132799 seconds`   | Analytics, app variables, machine activity fields, table fields    |
| Linked Record| Logical link between two Tables   |     |    | Table fields     |
| Machine    | Machine object in Tulip from the machine library    |    |     | Analytics, app variables, table fields                                                             |
| Number       | Real numbers, including trailing zeros    | 1, 7.4, 8.005, 419.38910     | Max value: `9007199254740991`     | Analytics, app variables, connector functions, machine activity fields, machine attributes, table fields |
| Object       | Configurable object structure with child attributes     |   |    | App variables, connector functions   |
| Station      | Station object in Tulip from the Shop Floor    |      |    | Analytics, app variables    |
| Text         | Sequence of characters    | Max size: `2.5kB` (Tulip tables; stored in UTF-8), `50kB` (others) <br> Truncated to `600 characters` for analytics             | Analytics, app variables, connector functions, machine activity fields, machine attributes, table fields |
| User     | User object in Tulip from account / workspace settings   |     |    | Analytics, app variables, table fields, machine activity fields     |
| Video        | Link to a video in Tulip, stored by cloud provider                          | mp4     | Max size: `200MB` <br> Max URL length: `2048 characters`       | Table fields    |


## Arrays


In several areas of the platform, you can toggle these data types to display as a list. This list represents an {{glossary.Array}} - a collection of elements matching a particular data type. Below is an overview of where to assess lists:


* App {{glossary.Variable}}s
* Connector Outputs


	+ For SQL connectors, check **Return Multiple Rows** - this format the output as an array.
	+ For HTTP connectors, select the output data type and toggle **List**.
* {{glossary.Linked Record}}s

	+ For one-to-many, many-to-one, and many-to-many, multiple linked records are stored as a list of linked records.

---

Did you find what you were looking for?

You can also head to [community.tulip.co](https://community.tulip.co) to post your question or see if others have faced a similar question!