Add concat formula - Id Row | Community
Skip to main content
Newcomer
January 14, 2025
Question

Add concat formula - Id Row

  • January 14, 2025
  • 1 reply
  • 3 views

Hi,

I have just implemented a formula to concatenate several columns of a table I have generated. 

 

Concat ( [Module],"_",[Type],"_",[Consecutive]) --> FI_R_001

 

The columne consecutive is a number of three characters like, 001, o 851. 

 

I would like to know, if it is possible instead of populating the consecutive column, use the row id that the table show me,  and add one or two zeros depending on whether the row id has one digit or two.

 

Anyone can help me?

 

1 reply

Newcomer
February 12, 2025

Hi fjav! Thank you for sharing your use case!


Unfortunately, we cannot auto-fill row_id in data table now. However, we will consider adding this formula to meet this need in the upcoming Formula v2.0. 
For now, maybe you can generate the [consecutive] list in spreadsheets/Excel and copy&paste into data table.

 

Thank you so much for your valuable input!