Skip to main content
Solved

Workaround for Concatenating Text into a 'Dimension' Type Column

  • October 14, 2025
  • 1 reply
  • 40 views
A
Author
Forum|alt.badge.img+1

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

Best answer by Benoit

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,

1 reply

Benoit
Community Manager
Forum|alt.badge.img+15
  • BenoitCommunity Manager
  • Community Manager
  • 232 replies
  • Answer
  • October 14, 2025

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,

Benoit - Pigment wizard


Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement