Unique IDs & filtering by day of month

Unknown

Unique IDs & filtering by day of month

Unknown

I have two questions:
1. let say I want to have table contain id, name, and for id, I want to build this as auto-increment number generated from a 6 digit number so

how to make column id as unique and auto-increment for a 6 digit number?
sample 111111,111112,111113 and etc for every object created
2. I have a scenario where I need to make payroll for every month depending on the chosen date
For example, how would I filter items based on this chosen date if it were the 25th of any month?

Unknown

Decisions has at least two ways to handle the generation of unique six-digit numbers. The first and simplest way to create an ID Generation Key, which can be used to get the next number in series within your flows. You can create a subflow with a Get Next ID step to populate the field in your data structure for the new ID use inputs from the flow itself to populate the rest of the necessary data for the entity. This flow can be placed in any other flow as a step to ensure that whenever an object of your data structures type is created, the next ID from your ID Generation Key is used to populate your custom ID field. Flow Execution Extensions are also capable of this, however, they have a Unique Process ID instead.
[ul][li][url=https://documentation.decisions.com/docs/id-generation]ID Generation[/url][/li][li][url=https://documentation.decisions.com/docs/creating-flow-execution-extension-data-structure]Flow Execution Extensions[/url][/li][/ul]To check the value of a date and divert a flows execution along a different path for a true or false outcome, you can use the default Equals (Number) rule with one of its inputs set to MyDate.Day and the other set to a constant value of 25. Each DateTime value in Decisions has a subset of properties from the DateTime including Day which is an integer value. I have attached two screenshots showing how this might be configured in a flow.

[img]att1[/img]
[img]att2[/img]
[i]edited by james.hartzell@decisions.com on 5/7/2020[/i]