--- title: "Data types" slug: "data-types" tags: ["App Editor (Route)", "Variable", "Variables"] updated: 2025-09-22T18:04:27Z published: 2025-09-22T18:04:27Z canonical: "support.tulip.co/data-types" --- > ## 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 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` 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) 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` 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) 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` 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 Array - a collection of elements matching a particular data type. Below is an overview of where to assess lists: - App Variables - 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**. - Linked Records - 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! **Analytics** **Analytics** are live updating graphs and metrics calculated based on app data, Table data, and machine data. Analytics can be embedded and dynamically filtered within an application. ![](https://cdn.document360.io/7c6ff534-cad3-4fc8-9583-912c4016362f/Images/Documentation/image-1662410510869.png) **Array** **Arrays**are a Tulip Datatype. Arrays are a list of other variables. Every element in an array must be the same type. Arrays are very useful when managing multiple values that represent the same information. *ex. The measurements of 10 quality checks can be stored in an Array of Numbers, as opposed to 10 Number variables.* **Variable** **Variables**are a location to store app information. Variables have a specific type that must match the contents they can store. Variables are only accessible within a single application and are cleared when the app is restarted or completed. **Linked Records** **Linked Records**are interconnections between multiple **Tulip Tables.**Fields in one Table can be mapped to another table. Linked records simplify traceability, genealogy, and data association for more advanced Tulip apps and app suites.