Hi There,
I have a list with invoice numbers, for example (1, 2, 3, 4, 5)
When I create a new record that needs to be in sequence, it should be the last or biggest from the list +1.
Would be great to get some direction, thanks for your time.
//JP
Hi There,
I have a list with invoice numbers, for example (1, 2, 3, 4, 5)
When I create a new record that needs to be in sequence, it should be the last or biggest from the list +1.
Would be great to get some direction, thanks for your time.
//JP
Welcome to the forum!
You can do that using the mathematical function max
to get the max of the list of invoice numbers as shown in the snippet.
{note}
{invoice_numbers=[1,2,3,4,5]}
{new_invoice_number=max(invoice_numbers)+1}
{endnote: trim=right}
New Invoice Number: {=new_invoice_number}
Dear @Ashwin_Mittal1,
Thanks a lot for your kind support and yes this is exactly what I was looking for