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; } } }

Trying to create a user report counter field

Eran Sandman

Hi everyone.

When we open a bug ticket we have a table in the description that states information about the user who reported this issue. When another report is coming we add a new row to the user report table and add information and this can happen multiple times of course.

I would like to create a field that counts the number of rows in this table using automation. One of the challenges is that having multiple rows in a certain cell can give a wrong calculation.

Another method that I thought using but have no clue how is somehow to use JIRA forms.

Can anyone help me with this?

Accepted answers

All comments

Vishal Biyani_2pr07j

@Eran Sandman

Few questions

Is the table having 1 column?
Does it have a header?
Can you share a sample data to better understand your scenario of multiple rows in certain cell?

Table is stored in markdown syntax format. I am thinking this can be used for parsing and calculating the number of rows in the table.

Eran Sandman

I managed to count rows, but if for example in the info header somebody entered a long sentence and pressed enter to create a link break, it will be considered as another user report.

Screenshot 2025-01-29 at 13.02.24.png

Vishal Biyani_2pr07j

Can you share the rule that you have used?

Using regular expression Lines breaks can be handled.

Eran Sandman

Oh this is difficult. I tried to use ChatGPT and he gave me every time something else. Do you have a suggestion?

mike mike_ha34rn

You can use Jira automation with a smart value to count the number of rows in the user report table. One way is to use a regex pattern in a smart value to count line breaks (\n) within the table and adjust for headers. However, if a single cell contains multiple lines, this can lead to inaccuracies. An alternative is using Jira Forms, where each report submission updates a structured form, making it easier to count entries accurately. If Forms support automation triggers, you can increment a custom field whenever a new row is added. Let me know which approach you prefer!

Download YouTube Premium APK

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud