DocumentationUser The Base ToolWhat are the different Types of Fields available?

What are the different Types of Fields available?

Here are the Field selections available in the Base Tool:

TMMData - my.tmmlog.in - Google Chrome

1. Name - Name of the Field (limited to 46 characters in length).

2. Field Type (look further down to see more information about the options):
         - Text
         - Long Text
         - Number
         - Date
         - List
         - File
         - HTML
         - ID
         - Sparkline

3. Description - General descriptive text for meta data catalog and overall documentation.

4. Format - Sub-Type Format of each Field Type (described in greater detail later in this same article).

5. Length - This allows you to set Field length, be sure to make it long enough that it will cover your data entries.

6. Custom SQL - This allows you to create this Field as a mashup Field, which means you can use custom SQL to manipulate this Field.

7. Default Value - This allows you to set a default value in this Field, it can be changed, but if nothing is entered it will stay the default value.

8. Index Field - This allows you to set this Field as an indexed Field in the database for faster loading.

9. Required - This allows you to set the Field to a mandated completed Field in the Table and in Forms.

10. Readonly - This allows you to set this Field to Read Only to allow only automated process or Custom SQL to update the value.

11. Hidden - This allows you to have a Field that is not seen in Prep, but can be utilized for calculations and processing.

12. Disable on Export - This allows you to set this Field to not show data on export.

 

Here is a bit more information about the Field Type(s):

1. Type: Text

Allows limited entries in a Form.  50 characters is the default length of characters (but this can be manually adjusted).  If you expect to need longer entries submitted for a Field you are setting up, then the Long Text option would be a better option.

TMMData - my.tmmlog.in - Google Chrome

The Text Type has several Format options available:

1. Format: Non Formatted

Allows text, numbers, and special characters to be entered into a Form.

TMMData - my.tmmlog.in - Google Chrome
2. Format: URL

Allows you to type or paste a URL location into a Form.

TMMData - my.tmmlog.in - Google Chrome
3. Format: Account #

Allows you to enter an Account Number (using an alpha numeric Format) into a Form.

TMMData - my.tmmlog.in - Google Chrome
4. Format: Phone Number

Allows you to enter a Phone Number.

TMMData - my.tmmlog.in - Google Chrome
5. Format: International Phone Number

Allows you to enter an International Phone Number.

TMMData - my.tmmlog.in - Google Chrome
6. Format: Zip

Allows you to enter a Zip Code.

TMMData - my.tmmlog.in - Google Chrome
7. Format: Postal Code

Allows you to enter an International Postal Code.

TMMData - my.tmmlog.in - Google Chrome
8. Format: State

Provides you a list to enter a State name or abbreviation.

TMMData - my.tmmlog.in - Google Chrome
9. Format: Image

Allows you to enter a full URL path to an Image.

TMMData - my.tmmlog.in - Google Chrome
10. Format: Short URL

Allows you to create a Minitab Connect managed custom Shortened URL.

TMMData - my.tmmlog.in - Google Chrome
11. Format: Tagged URL

Allows you to setup a Field that creates a unique URL based upon other Fields in your Table.

TMMData - my.tmmlog.in - Google Chrome

Options under the Tagged URL Format:

  1. Update Value On Record Update - lets the platform know if ONLY new records have this URL generated or any row level update.
  2. Collision Handling - lets the platform know what to do if a collision of 2 or more duplicate URLs are created (use new, old, or ignore).
  3. URL Field - What other Field in the table is to be used for the base URL (not parameters).
  4. Parameter(s) - 1 or more Fields (and associated parameter names) to create the unique URL.
  5. Add Parameter - ability to add as many parameters as needed.
TMMData - my.tmmlog.in - Google Chrome
12. Format: QR Code

Allows you to generate and store a QR Code based upon whatever data (normally URL) is stored in that Field.

TMMData - my.tmmlog.in - Google Chrome
13. Format: Bar Code

Allows Bar Code entries in a Form.

- patch.tmmlog.in - Google Chrome
2. Type: Long Text

Allows Long Text entries in a Form.

TMMData - my.tmmlog.in - Google Chrome
3. Type: Number

Allows Number entries into a Form.

TMMData - my.tmmlog.in - Google Chrome

The Number Type has several Format options available:

1. Format: Non Formatted

Allows you to enter and displays numbers and "." only.

TMMData - my.tmmlog.in - Google Chrome
2. Format: Formatted

Allows you to enter and display numbers, "," and "." only.

TMMData - my.tmmlog.in - Google Chrome
3. Format: Currency

Allows you to enter and display numbers, ",", "$", and "." only.

TMMData - my.tmmlog.in - Google Chrome
4. Format: Percent

Allows you to enter and display numbers, ",", "%", and "." only (in appropriate percentage values to the nearest 100th).

TMMData - my.tmmlog.in - Google Chrome
5. Format: Scientific Notation

Allows you to enter and display numbers in Scientific Notation Format.

TMMData - my.tmmlog.in - Google Chrome
6. Format: Percent (No rounding)

Allows you to enter and display numbers, ",", "%", and "." only (in appropriate percentage values).

TMMData - my.tmmlog.in - Google Chrome
4. Type: Date

Allows Date entries in a Form.

Select a Date Type as well:

  • User Entered
  • Insert Date
  • Update Date
TMMData - my.tmmlog.in - Google Chrome

Select a Format:

1. Format: Date

Allows you to enter a date in YYYY-MM-DD Format.

Remember, this can be applied to the Date Types:

  • User Entered
  • Insert Date
  • Update Date
TMMData - my.tmmlog.in - Google Chrome
2. Format: Date/Time

Allows you to enter a Date in YYYY-MM-DD and hh:mm:ss Format.

Remember, this can be applied to the Date Types:

  • User Entered
  • Insert Date
  • Update Date
TMMData - my.tmmlog.in - Google Chrome
3. Format: Time

Allows you to enter a Date in hh:mm:ss Format.

Remember, this can be applied to the Date Types:

  • User Entered
  • Insert Date
  • Update Date
TMMData - my.tmmlog.in - Google Chrome
6. Type: File

This Type of Field allows you to store 1 or more File(s) of any type.

TMMData - my.tmmlog.in - Google Chrome
7. Type: HTML

This Field Type allows you to enter and/or store any HTML in a Field in a Table.

TMMData - my.tmmlog.in - Google Chrome
8. Type: ID
TMMData - my.tmmlog.in - Google Chrome

In addition to the standard Field options, the ID Type provides three Formats for its Field Type:

1. Format: Numeric ID

This Format provides a unique Numeric ID per record for every row of data (tied to the System: ID that is generated).

TMMData - my.tmmlog.in - Google Chrome
2. Format: Alphanumeric

This Format provides a unique identifier in Alphanumeric Format (example: 2845edbd-fe15-11ea-93ae-0e13ba927133).

Additionally, it will allow the selection of upper or lower for the case of the alpha characters.

TMMData - my.tmmlog.in - Google Chrome
3. Format: Custom

This Format provides an extensive set of options to generate a Custom, unique, and specialized ID for you.

TMMData - my.tmmlog.in - Google Chrome

The following additional options are available:

TMMData - my.tmmlog.in - Google Chrome
  1. Update Value on Record Update - Allows you to select the option to update only on new record inserts or change every row update.
  2. Case - Allows the setting of case for your identifiers (lower or upper case).
  3. Separator - Allows you to select the separator(s) between values (if any) in your ID.
  4. Fields or values to be included in your ID which can also include unique system ID or even other ID Fields that you have created.
  5. Add Field - Allows you to add additional Fields.

 

 

9. Type: Sparkline

A Sparkline is an inline visualization type (it displays in the row of a Table).  All Sparkline Formats require data to be setup as comma-separate-values in the Field (example: 1 Field value = "13,12,43,12") for the Field to function correctly.

Note: Additional options can be configured using the Custom Options text box (it is available via the Base Tool, if Sparkline is selected).  Please contact support for more information.

TMMData - my.tmmlog.in - Google Chrome

There are several Formats available:

1. Format: Line
TMMData - my.tmmlog.in - Google Chrome

Here is an example of what the Line Format looks like in a Table.

Note: All Sparkline Formats require data to be setup as comma-separate-values in the Field (example: 1 Field value = "13,12,43,12") for the Field to function correctly.

Note: Additional options can be configured using the Custom Options text box (it is available via the Base Tool, if Sparkline is selected).  Please contact support for more information.

2. Format: Spline
TMMData - my.tmmlog.in - Google Chrome

Here is an example of what the Spline Format looks like in a Table.

Note: All Sparkline Formats require data to be setup as comma-separate-values in the Field (example: 1 Field value = "13,12,43,12") for the Field to function correctly.

Note: Additional options can be configured using the Custom Options text box (it is available via the Base Tool, if Sparkline is selected).  Please contact support for more information.

3. Format: Area (example)
TMMData - my.tmmlog.in - Google Chrome

Here is an example of what the Area Format looks like in a Table.

Note: All Sparkline Formats require data to be setup as comma-separate-values in the Field (example: 1 Field value = "13,12,43,12") for the Field to function correctly.

Note: Additional options can be configured using the Custom Options text box (it is available via the Base Tool, if Sparkline is selected).  Please contact support for more information.

4. Format: Area Spline (example)
TMMData - my.tmmlog.in - Google Chrome

Here is an example of what the Area Spline Format looks like in a Table.

Note: All Sparkline Formats require data to be setup as comma-separate-values in the Field (example: 1 Field value = "13,12,43,12") for the Field to function correctly.

Note: Additional options can be configured using the Custom Options text box (it is available via the Base Tool, if Sparkline is selected).  Please contact support for more information.

5. Format: Column (example)
TMMData - my.tmmlog.in - Google Chrome

Here is an example of what the Column Format looks like in a Table.

Note: All Sparkline Formats require data to be setup as comma-separate-values in the Field (example: 1 Field value = "13,12,43,12") for the Field to function correctly.

Note: Additional options can be configured using the Custom Options text box (it is available via the Base Tool, if Sparkline is selected).  Please contact support for more information.