How to create unique ids for unique items

Shelaj

Hi,

I'm looking to create a unique ids using my process_id

and I want the unique ids to be start again once the process ids changes as shown below

Kindly help 🙂

Help

Accepted answers

DavidP

I like using the Tile tool for this kind of thing

All comments

Ladarthure

Hi @Shelaj,

You can use a multi-row formula:

and just tick the group by session. and have a formula like [row-1:id]+1

(find an example attached)

id.yxmd

AshleyL

Hi @Shelaj --

After you use the multi-row formula, you can convert the number into a string using a formula to add the S and 0 to the UID like described in your question.

I've attached a workflow with the multirow and formula configuration.

Best,

Ashley

MultiRow UID.yxmd

DavidP

I like using the Tile tool for this kind of thing

Shelaj

Hey AshleyL

Thank you very much, the solution worked well 🙂

Shelaj

Hey Arthur

Thank you very much for the solution, provided solution worked great 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703