Field options for the Base Tool

The data in a field can be one of ten different types. Select the expander to see the full list of field options.

Text

Enter text strings. By default, the maximum length for a string is 50. You can change the maximum length in Length. Minitab Connect stores text objects as strings, which can use a lot of memory if the string is large. If your text strings are larger than 2,000 characters, consider using a Long Text field.

Long Text

Long text fields are stored as a blob and use less memory than a text field. Use this option when you pull in objects that are larger than several thousand characters, such as JSON files.

Number

Enter any kind of numeric data.

Date

Enter date/time data. Minitab Connect looks for date formats with the day, month and year. If you import data with incomplete information (for example, no year), the data imports as a text field and may not display correctly in a visualization.

List

Enter data from on a specific list of values. Specify the values under Values.

File

Upload a file for the field.

Link

Enter a link as a basic URL string or a JSON object. Connect processes a basic URL string as a hyperlink with the URL string as the HREF value and the column name as the link text. Connect processes a JSON object with a title attribute and a URL attribute and uses the title attribute as the link text. The names of both attributes must be lowercase.

{
	"title": "Minitab Home Page",
	"url": "http://www.minitab.com"
}

ID

Create unique identifiers (custom or auto-generated) for use in indexing, joining, or assuring unique records.

Sparkline

Enter data that is an inline visualization type that displays in the row of a table. All Sparkline formats require data to be set up as comma-separate-values. For example, Field value = "13,12,43,12".

User

Populate the field with the user who entered the data.