Sequencing Fields

This topic describes the fields and buttons that are available when building a sequence format from the Sequences subtab of the Foundations Setup page.

When you create a sequence format from the Sequences subtab, Foundations stores the data in several custom metadata records:

• Sequence
• Sequence Field
• Sequence Part

Tip:

We recommend that you use the features on the Sequences subtab to create and edit sequences, rather than editing custom metadata records directly.

Full details about custom metadata fields is available in the Sequencing Custom Metadata Types section.

Sequences Subtab Fields

Here is a description of the fields that are displayed when building a sequence format from the Sequences subtab. For information about the fields available in the Sequences table on the Sequencing page, see FDN Sequences Table Lightning Component Fields.

Key: * – Mandatory field; Descriptions of checkbox settings describe the selected (true) case.

Sequences Subtab Fields

Field		Description
Label	*	The name of the sequence format.
Unique Name	*	The unique name of the sequence format. Notes: Foundations automatically generates the unique name when you enter a label and click out of the Label field. You can change the unique name, but the following conditions apply: It must begin with a letter and contain only alphanumeric characters and underscores. The name cannot contain two consecutive underscores or end with an underscore. If the label begins with a number, Foundations prefixes the unique name with X. If required, you can change the prefix to another letter.
Text		Static text to separate the parts of the number sequence. By default, the value for the text part is a hyphen (-).
Number Length		The number of digits in the sequence. By default, the number length is 5. Tip: When you generate sequence numbers, the length of the number sequence part automatically increases to accommodate larger values. For example, if you specify a number sequence part length of four, its length remains four digits until the sequence number reaches 9999. The next number Foundations generates is 10000, automatically expanding to five digits.
Starting Number		The starting number of the number sequence part. By default, the starting number is 0.
Object	*	The object that contains the target field.
Target Field	*	The text field that stores the generated sequence number.
Filter Field		The checkbox field that determines whether or not to generate a sequence for particular records. If you specify a filter field, Foundations only generates sequence numbers when the value for the specified checkbox is selected on the record. For example, if you have specified Sales Invoice as the object, you can specify Approved as a filter to ensure Foundations only generates sequence numbers for approved sales invoices.
Enabled		Indicates that the sequence format is enabled. Foundations only generates sequence numbers when the sequence format is enabled.
Select the placeholder fields		The field that provides the source data that replaces the field placeholder part in the generated sequence number.

Sequences Subtab Buttons

The following buttons are available on the Sequences subtab of the Foundations Setup page.

Sequences Subtab Buttons

Button Name	Description
New	Creates a new sequence format.
	Deletes a sequence format.

The following buttons are available when creating or editing a sequence format from the Sequences subtab.

Sequences Subtab Buttons When Creating or Editing a Sequence Format

Button Name	Description
Add Part	Opens the sequence format menu. From this menu, you can add a field placeholder, text, or number sequence part.
	Displays the part menu, which enables you to move or remove parts.
Reset Sequence Number	Resets the generated sequence number when the field related to the field placeholder part contains a unique value.
Hide	Hides the field placeholder part that resets the sequence number.
Move Left	Moves the selected part one position to the left.
Move Right	Moves the selected part one position to the right.
Remove	Removes the part from the sequence format.
Add	Adds a new sequence field to the sequence.
Save	Saves any changes made to a sequence format.
Cancel	Closes the Sequence Edit popup and discards any unsaved changes.

Sequencing Custom Metadata Types

This section provides information about the fields on the custom metadata types that make up a sequence format. Where a field directly correlates to one or more labels on the Sequences subtab of the Foundations Setup page, this is listed.