Variables in Tulip
- 19 Jan 2023
- 5 Minutes to read
- Contributors
- Print
Variables in Tulip
- Updated on 19 Jan 2023
- 5 Minutes to read
- Contributors
- Print
Article summary
Did you find this summary helpful?
Thank you for your feedback
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.
Overview of Data Types
| Type | Description | Area Supported |
| Boolean | True or false | Analytics, App Variables, Connector Functions, Machine Activity Fields, Machine Attributes, Table Columns |
| Color | Color that can be used to dynamically set widget coloring | App Variables, Machine Activity Fields, Table Columns |
| Datetime | Timestamp consisting of a date, time, and timestamp | Analytics, App Variables, Connector Functions, Machine Activity Fields, Table Columns |
| Enum | Selection of predefined constants (i.e. Machine States) | Analytics, Machine Downtime, Reasons, Machine States |
| File | Link to a file, which can be stored on our cloud provider Max file size: 200MB for mp4 videos, 50MB for all other file types Max URL length: 2048 characters. | App Variables, Table Columns |
| Image URL | Link to an image in Tulip, which is stored by cloud provider Max file size: 20MB Max URL length: 2048 characters. | App Variables, Table Columns, Connector Functions, Machine Activity Fields |
| Integer | Integer - a number without a fractional component 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 Max value : 7730941132799 seconds | Analytics, App Variables, Machine Activity Fields, Table Columns |
| Linked Record | Logical link between two Tables, can be one-to-one, one-to-many, or many-to-many. | Table Columns |
| Machine | Machine object in Tulip from the Machine Library | Analytics, App Variables, Table Columns |
| Number | Real numbers Max value: 9007199254740991 | Analytics, App Variables, Connector Functions, Machine Activity Fields, Machine Attributes, Table Columns |
| Object | Configurable object structure with child attributes, which have their own data type. | App Variables, Connector Functions |
| Station | Station object in Tulip from the Shop Floor | Analytics, App Variables |
| Text | Sequence of characters Max size: 2.5kB in Tulip Tables; 50kB in other case. Truncated to 600 characters for analytics. | Analytics, App Variables, Connector Functions, Machine Activity Fields, Machine Attributes, Table Columns |
| User | User object in Tulip from Account / Workspace Settings | Analytics, App Variables, Table Columns, Machine Activity Fields |
| Video | Link to a video in Tulip, which is stored by cloud provider Max size: 200MB Max URL length: 2048 characters. | Table Columns |
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 to post your question or see if others have faced a similar question!
.gif)
.gif)
Was this article helpful?
