How to generate index number on database?

[Maciej]

Hi,
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
i.e.
orders in December:
1 - 12
2 - 12

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

[cmarchan]

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”