cancel
Showing results for 
Search instead for 
Did you mean: 
Important updates from Zoom Support:
  • Starting February 3, 2025, Zoom Phone customers must add their phone numbers to an approved 10DLC campaign in order to use SMS/MMS capabilities on their numbers.

  • Introducing more live support options! More Zoom customers now have access to live agent chat support. Sign in and visit our Contact Support page to see all your available support options. We’re here to help!

Add concat formula - Id Row

fjav
Newcomer
Newcomer

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 1

ahrenhan
Newcomer
Newcomer

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!