Field Sets & Templates: Field Type Options

In Field Sets, Administrators can create the fields to be used in the Submission Table, define each field's data type, and add governance, formatting, and restrictions.

Field Type: List

Lists allow a defined list of allowable entries the user can select from. Select the Pick List from the drop-down menu either by scrolling or begin typing the Pick List name.

If the list you want to use has more than one column, you must specify which column you want the list to populate from.

Check the box Select Multiple Values if the user should be allowed to select more than one value from the pick list in the Submission Table. Define the delimiter.

For more information, refer to the Pick Lists Overview article, or, for more detailed instructions on each of the pick list types, read their respective articles: Pick List - Drop Down, Pick List - Dependent, Pick List - Drill Down.

Field Type: Autonumber

The Autonumber field generates a sequential number managed by Claravine. Designate the starting number and minimum width. Claravine will increase by one across all templates this field is used in.

Field Type: Auto Fill

Select the field you want to automatically duplicate. Transform the metadata from the autofilled field.

Convert Case:

None: For no transformation.
Uppercase: To have all text display in capital letters
Lowercase: To have all text display in lowercase letters

Spaces:

None: For no transformation.
Replace Spaces: Replaces all spaces the user enters with a character you determine. (Summer_Bash)
Remove Spaces: Removes all spaces from the text the user enters. (SummerBash)

Field Type: Concatenation

Combine the values from two or more fields into a single field. Concatenated fields can use all field types: text, pick lists, constant, autofill, and date. You can specify the separator character/delimiter or to not use a separator between fields.

If you add a new field to include in the concatenation, you must save the Field Set first.

Field Type: Constant

Specify a constant value that you want to always be populated in this template in the Submission Table:
.

Field Type: Date

The Date field will populate in the submission table as a pop-up calendar widget. Specify the following date parameters:

Name: Enter the name of the date.
Order: Select the order the date displays (M/D/Y, Y/D/M, D/M/Y, or Y/M/D).
Month Format: Select the format of the month to display: single-digit (M), double-digit (MM), abbreviated (Jan), full name (January), or None to exclude the month from the date field.
Day Format: Select the format of the day to display: single-digit (D), double-digit (DD), or None to exclude the day from the date field.
Year Format: Select the format of the year to display double-digit (YY), 4-digit year (YYYY), or None to exclude the day from the year field.
Separator: Enter the delimiter between the month, day, and year values.
Auto Populate: Check the box to auto-populate the current date upon submission.

Field Type: Text

Text fields allow users to manually enter values in the user's Submission Table. Specify the following parameters for text fields:

Show Previous Values: Select this option if you want a new value to be added to a dynamic list gathering values entered through a submission.
Flag New Values: Select this option if you want users to be alerted that the value they entered has not been used in that field before. Users have the option to continue and submit the value. If they proceed the new value will not be flagged next time.
Use list to provide suggestions: You can specify a drop-down (single column) pick list to populate suggestions for users to choose from, or they can enter their own text.

Rules

Options in this section establish governance over text entered in this field. If the text does not match any of the governance, the user will receive an error and must correct the text to match the requirement before proceeding.

Begins/Ends With: Enter the prefix or suffix you want text fields to be required to begin and/or end with. *Case sensitive
Must Contain: Enter the value you want text fields to always include. *Case sensitive
Exclude: Use the drop-down menu to select the appropriate checkboxes to exclude all letters, all numbers, all symbols (special characters and punctuation), or spaces from the value.
Custom Exclusion: Enter a custom value you want to exclude from the field. *Case sensitive
Exclude as term: Check this box to exclude the Custom Exclusion combination of characters entered above. This makes the text field act as a "Must not include". For example, if we have set Toy as an exclude term, Toyota would receive a warning.

Transform (Letter Case, Spaces, Split & Extract)

Use the options in this section to automatically apply transformations to values entered into this field. You can configure multiple text transformations on the same field (for example, convert case and split & extract).

Convert Case

Select uppercase to have all text display in capital letters; select lowercase to have all text display in lowercase.

Replace or Remove Spaces

Select how spaces should be auto-transformed.

Options are:

None: For no transformation.
Replace Spaces: Replaces all spaces the user enters with a character you determine. (Summer_Bash)
Remove Spaces: Removes all spaces from the text the user enters. (SummerBash)

Split & Extract #

Split & Extract is useful for auditing and validating existing campaign data against naming conventions and marketing taxonomies and helps you quickly convert coded dimensions into readable formats.

Use this transformation split text based on preset or custom delimiters:

To apply the Split & Extract transformation:

You can apply Split & Extract transformations to Text, List, or Date field types. Apply the transformation to the field into which you’re placing the parsed value.

Navigate to the field where you want to apply logic and scroll down to the Transform section of the field configuration drawer.
In the Extract Data field, select Split and Extract on Delimiter.
Set configuration options for the transformation:
- Extract Data From: Select the source field from which to extract data. Source fields must be of type Text or Date, and must be saved to the field set prior to appearing in the dropdown.
- Delimiter: This is the character the text will be split on, and it is required. Either select it from a list of common delimiter options, or enter a custom value.
- Position: Specify the position of the of the data as parsed by the delimiter.
Optionally paste the example text from which you want to extract the data (your source field value) in to the Preview field to help verify your logic. This preview field will highlight the position number you entered when you specified the Delimiter and desired Position.

You can apply multiple levels of naming conventions. Use multiple Split & Extract transforms in combination to split apart text containing multiple levels of conventions. For example, you can first split the value value1-value2a_value2b-value3 into value1, value2a_value2b , and value3. You can then split value2a_value2b into value2a and value2b in the same template.

Length

Define the minimum and maximum length of characters a user is allowed to enter in open text fields. If the field is optional, set the minimum length to 0. If the length of characters is an exact number, set the minimum and maximum to the same number.