Knowledge Base
Setting up Global Rolling Columns
Browse Common Categories
- Adding a Run Map Task
- Adding an Email Task
- Defining Remaining Options
- Using a Custom Rolling Column
- Using a Translation
- Using a Date Calculation
- Using a Calculation
- Performing the Field Mapping
- Determining Source Grouping
- Defining an Integration Target
- Defining an Integration Source
- Populating the Integration Details
- Setting Up Translation Tables
- Setting up Global Rolling Columns
- Setting up Global Variables
- Connecting to Dynamics 365 Customer Engagement using an OAuth Token
- Using a Relationship
- Using a List Option Lookup
- Using a Multi Lookup
- Using an Entity Reference
- Using an Activity Party
- Using an Entity Lookup
- Setting up an Integration to Dynamics 365 Sales
- Creating a Dynamics 365 Sales Real-Time Data Source
- Creating a Dynamics 365 Sales Change Data Source
- Creating a Dynamics 365 Sales Bulk Data Source
- Setting up a Dynamics 365 Sales Connection
- Setting up an Integration to Dynamics CRM
- Creating a Dynamics CRM Real-Time Data Source
- Creating a Dynamics CRM Change Data Source
- Creating a Dynamics CRM Bulk Data Source
- Setting up a Dynamics CRM Connection
- Using a Relationship
- Using a List Option Lookup
- Using a Multi Lookup
- Using an Entity Reference
- Using an Activity Party
- Using an Entity Lookup
Setting up Global Rolling Columns
Setting up Global Rolling Columns
-
From the main Navigation Menu, select Maintenance>>Global Rolling Columns.
-
To create a new Global Rolling Column, click the Create Global Rolling Column button.
- Enter a unique Name for the global rolling column.
- Enter a Description.
-
Enter a starting value for the Next Number field. When an integration process uses the global rolling column, this is the value that will be retrieved and incremented.
- IMPORTANT: The value used in the global rolling column will never expand beyond the number of characters that it is created with. For example, the value of SC01 will only work for 99 records, once the rolling column is incremented to SC99 – it has no room to increment to the next value as the total number of characters will not change during use. A much more appropriate starting value in this scenario would be SC0000001.
- Click Save to complete the creation of the new global rolling column.
Support