Making sequence function calculator

[Endo]

Dear Yeeflow Team,

I am creating an invoice form in Yeeflow and need assistance with implementing a sequence calculator. Here’s the functionality I am looking for:

• When an invoice date is selected, the invoice number should automatically generate as follows:
  • Format: [Date] + [Sequence Number] (e.g., 20241205-0001, 20241205-0002, 20241205-0003).
  • The sequence should reset to 0001 on the next day and increment again for that date.

Could you please guide me on how to set this up?
Thank you in advance for your support!

[Renger]

Hi @Endo, for such case, you can create a “Autonumber” field in your data list. Then, set the prefix and starting number as needed. Please refer the following screenshot: