Customizing and multi-dimensionalizing Unique IDs

  • 29 November 2023
  • 5 replies

Userlevel 2
Badge +3
  • Budding Pigmenteer
  • 6 replies

Hi Pigment Community, 

We have a dimension list that generates unique IDs for potential hires before they go through our formal requisition process. Curious to know:

1.  Is there a way to customize unique IDs so they follow a specific nomenclature (i.e. TBH - 001)? Would concatenating them be the best approach? 

2.  Is it possible to generate unique IDs based on a dimension? For example, if we created a “to-be-hired” role under Department A, it would generate unique ID #1. If we created a “to-be-hired” role under Department B, it would generate unique ID #2 since unique ID #1 is already in use elsewhere. Currently, both roles are tied to unique ID #1. Ideally, we would want to associate properties to these unique IDs as well.


Best answer by Nathan 29 November 2023, 21:35

View original

5 replies

Userlevel 6
Badge +11



you can certainly do that !

In a dimension list, there is an option to make a property an auto generated unique Integer (as below)

You can use this to concatenate anything:


In this case I’ve used the Month Dimension but you can put any other. Every dimension has a property Name by default but you can use any other text property.



Userlevel 2
Badge +3

Thanks for confirming, @Nathan! Any thoughts on the second question? 

Userlevel 6
Badge +11

Makes me think you are using our standard app which uses the same item across dimensions.

I’m not sure you can make it fully sequential as it is not by design, but you can add a number before the ID count to make sure the number is unique.

Ideally by concatenating with a unique number that you put as a property of the Department Dimension

Userlevel 5
Badge +8

Hey @Kyla ,


Have you managed to get forward with the second question? :)



Userlevel 2
Badge +3

Squared away, thanks all!