nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confluence Cloud : Auto assign id to the column

Ashish_10js00

Hello team,

I have table created with diff columns for requirements.

Once such table is called Sys id and i want to auto assign the values like 001, 002 ,003 and 0004, automatically.. is there any way to achieve this using macro ..native or 3rd part

Regards
Ashish

Accepted answers

Ashish_10js00

@Katerina Kovriga _Stiltsoft_ : Any suggestion please

Katerina Rudkovskaya _Stiltsoft_

Hello Ashish,

I advise you using Table Filter and Chart for Confluence app in this case.
Please wrap your table with our Table Transformer macro and use the following SQL query:

SELECT 'Subsystem',
'Sys Req id'::string->padStart(3, "0") AS 'Sys Req id',
'Summary',
'Description'
FROM
(SELECT *, ROWNUM() AS 'Sys Req id' FROM T1)

Katerina
Stiltsoft