Creating a complex membership ID

Hi I am trying to create a complex membership ID.

Equation: NNNN - NNNN

N - Number from 0 to 9
The first 4 digits are taken from a database of municipality IDs that is created.
The last 4 digits are supposed to be unique generated numbers.

Example: 0134 - 0001

How should the workflow look like?

To generate the random numbers, you can use Calculate Formula.

Let’s say you’re on the step where you’re saving the Id, you’d go member id = current user’s Municipality id - Calculate Formula. And in the Calculate Formula you can dictate the conditions.

2 Likes

Thank you! I noticed I couldnt do it before because the fieldtype was a number and not a text, it must be text for it to work. :slight_smile: