Add concat formula - Id Row

[fjav]

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?

[ahrenhan]

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!