Skip to main content

Hey Pigment community, 

I need to create a unique ID in a list by concatenating text values from several other properties. This works perfectly when my new unique ID column is set to the Text type.

However, my requirement is for this unique ID to be of the Dimension type. As soon as I switch the column type to Dimension, the concatenation formula stos working, citing a type incompatibility.

I've been trying to find a workaround for a while without any luck. Has anyone run into this before or have any ideas on how to solve this?

Thanks in advance for your help!

Andy

Hi, 

It’s normal and intended because Pigment can’t find a match in your new dimension since the item does not exist yet.

You’d need another workaround to automatically create the dimension items based on your unique IDs.

And to do that, you’d need another ID.

There are two solutions explained here:

 

Please let us know if you’ve find a way using this.

Best,

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement