How to generate index number on database?

I have page where user can send order by form. It generates new row on database. How to make a column with order number looks like: increasing number - month
orders in December:
1 - 12
2 - 12

orders in March
1 - 3
2 - 3
3 - 3

1 Like

Hello @Maciej

You can add a number field to the order and perhaps call it 2index". Each time you create a new order you can set its new index by counting all the month’s orders (via a search) +1

In a text element of the row in the rg you can use:

“parent group order index” … space … “parent group order creation date: extract month”

This topic was automatically closed after 70 days. New replies are no longer allowed.