Data types
Selecting the correct type for your data is key to easily organising and using it in formulas. Let's take some examples:
- If you need to perform calculations or compare values, it's best to choose the Number data type. This allows you to work with numeric data effectively.
- Similarly, if you're dealing with dates or times, it's recommended to use the Date, Time or Date/Time data types. These data types provide specific functions for working with dates and times.
- For more general-purpose information, such as text, you should choose the Text data type. This allows you to format, combine, and extract parts of text as needed.
Finally, you may need to handle multiple values of the same kind of information. To achieve this, you can specify that your data item should be capable of holding multiple values when you create it. By doing this, you gain access to a variety of functions that enable you to combine values together, retrieve and manipulate specific positions within the collection of values. We call this an Array of values.
Data types
GoAutomate supports the following data types:
| Data type | Description | Example |
|---|---|---|
| Text | The Text data type refers to any information that can be presented as written or typed words. This can include common things like sentences, words, email addresses, and even numbers like telephone numbers. Essentially, it covers any content that can be expressed using text characters. | “What a wonderful day!” “+1-241-435-6550” “jake2938@acme.com” |
| Number | The Number data type is used to represent numerical values, such as whole numbers (like 1, 5, or 100) and decimal numbers (like 3.14 or 1892.5). | 12 1892.5 -13 -1893.5 |
| Logical | The Logical data type is a way to represent information that can only be either 'true' or 'false'. | TRUE FALSE |
| Date | The Date data type is a way to represent specific dates. | 23/05/2022 |
| Time | The Time data type is a way to represent specific times. | 3:27 PM |
| Date/Time | The Date/Time data type is a way to represent specific dates and times combined. | 23/05/2022 3:27 PM |
| Choice | The Choice data type is a way to define a limited set of options or values that can be used. It allows you to specify and work with a specific range of acceptable values. | ("Accept”, “Reject”) (“Red”, “Blue”, “Green”) (“Email”, “Mobile”, “Postal”) |
| File | The File data type represents a file, including name, type and size | StarbucksReceipt2022_05_12.png |
| Person | The Person data type is used to represent an individual. It contains two important pieces of information: the person's name and their email address. | Fred Blogs, fred.blogs@acme.com |
ON THIS PAGE