Knowledge Base
Setting up Global Rolling Columns
Browse Common Categories
Getting Started with SmartConnect.com
Installing and Configuring SmartConnect 21
Creating an Integration Process
- 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
Importing and Exporting Integrations
Maintaining Setup Options
- Setting Up Translation Tables
- Setting up Global Rolling Columns
- Setting up Global Variables
Navigating the Dashboard
Setting Up Additional Functionality
Working with Dynamics 365 Business Central
Working with Dynamics 365 Sales
- 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
Working with Dynamics CRM
- 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
Working with Dynamics NAV
Working with File Options
Working with Generic Connections
Working with Salesforce
Working with SQL Server
Working with the REST Connector
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