Data in AUTTO is held in [square_brackets]. Each [square bracket] has a Data Type that reflects the kind of information held within it - for example, a piece of Text or a Date. Different Data Types have different types of functionality associated with them in the Condition Editor and you can only map information from one common Data Type to another.
This article discusses data types in more detail.
Table of Contents
- What are Data Types?
- The Different Data Types in AUTTO
- How Data Types Work in the Condition Editor
- How Data Types Work in Data Tables, API Responses, and Elsewhere in AUTTO
- Related Articles
What are Data Types?
Data types in AUTTO hold data from various sources, including the following:
- Answers to questions in Actions, including those asked in Form actions
- IF-ELSE statements in Conditions, including those defined in a Condition Editor, and Condition and Conditional [] actions
- Columns in data tables
- Responses to API calls
Data types are used throughout AUTTO. They can be called from data tables or square brackets for use elsewhere in a workflow.
The Different Data Types in AUTTO
Data types may offer a choice between several values, accept string inputs, and be saved into square brackets. The different data types in AUTTO and their defining characteristics are seen in the table below.
| DATA TYPE | CHOICE? | ALLOWS STRING INPUT? | ALLOWS SAVING INTO SQUARE BRACKET? |
| Text | No | Yes | Yes |
| Number (including Rating and Calculator) | No | Yes | Yes |
| No | Yes | Yes | |
| Yes/No | Yes | No | Yes |
| Date | No | From Date Picker | Yes |
| Time | No | From Time Setter | Yes |
| Address | N/A | N/A | N/A |
| Value (Multiple Choice, Dropdown, and Country Questions WITHOUT Multiple answers) | Yes | No | Yes |
| List (Multiple Choice, Dropdown, and Country Questions WITH Multiple answers) | Yes | No | Yes |
| Number List | No | No | No |
| @Record_id | No | No | No |
| Table | No | No | No |
| !Data Table | No | No | No |
| File | No | No | No |
NOTE: The Value and List data types will only accept the range of values defined within them. Anything outside the defined range will not be saved in AUTTO.
How Data Types Work in the Condition Editor
Data types may have different operators when called from the Condition Editor, which runs anywhere in AUTTO where conditional statements are used. For example, in a Condition Action, the Condition Editor allows creation of IF-ELSE statements applicable to the condition.
The table below shows the different data types and their operators when used in the Condition Editor.
| DATA TYPE | OPERATORS |
| Text |
IS INCLUDES, for any matching text string, including punctuation, spaces, and special characters INCLUDES (SENSITIVE) for case-sensitive text INCLUDES (WHOLE WORD) for whole words |
| Number (including Rating and Calculator) |
MORE THAN, LESS THAN, EQUAL TO, IS NODATA INCLUDES, for any matching text string, including punctuation, spaces, and special characters INCLUDES (SENSITIVE) for case-sensitive text INCLUDES (WHOLE WORD) for whole words |
|
IS INCLUDES, for any matching text string, including punctuation, spaces, and special characters INCLUDES (SENSITIVE) for case-sensitive text INCLUDES (WHOLE WORD) for whole words |
|
| Yes/No | IS, IS NOT, IS NODATA |
| Date | BEFORE, AFTER, IS NODATA, need to add IS/EQUAL TO |
| Time | IS |
| Address |
INCLUDES, for any matching text string, including punctuation, spaces, and special characters INCLUDES (SENSITIVE), for case-sensitive text INCLUDES (WHOLE WORD), for whole words. |
| Value (including Multiple Choice, Dropdown, and Country Questions WITHOUT Multiple Answers) |
IS, IS NOT, IS NODATA |
|
List (including Multiple Choice, Dropdown, and Country Questions WITH Multiple Answers) |
INCLUDES ONE OF, INCLUDES ALL OF |
|
Attachment |
IS |
As seen from the above table, AUTTO allows looking for specific words or phrases within certain data types through the use of INCLUDE operators.
How Data Types Work in Data Tables, API Responses, and Elsewhere in AUTTO
Data types correspond to the column types in data tables (see Managing Data Tables). When used in actions that update a data table (for example, the Update Data Table action), the data type that will be used in adding a new row or editing an existing one in the data table must match the column type.
For example, in a Data Table with an Email column, the data type used in updating the Email column must also be an Email data type. If this requirement is not met, an error will be displayed and the data table will not be updated.
Data types in API responses (see Using the Autto API Manager) and elsewhere generally follow this same rule.
Comments
0 comments
Please sign in to leave a comment.