New to the community? Start here

[Forminator Pro] Please add the feature “Serial Number” with advanced formatting

1

We are in need of a Serial Number.

We imagine the following options (borrowed from calculation field):
– simple integer: 202350010000+1 – With each submission the count goes +1
– simple integer alt: 202350010000+{submission_id} – With each submission the count goes +1 result 202350010001
– concatenate with current year: {YYYY}{50010000}+1 – With each submission the count goes +1 result = 202350010001
– concatenate with date and formatting : {YYMMDD}” | “{500}”.”{10000}+1 result = 23.06.07 | 500.10001
– concatenate with date and formatting alternative: {DDMMMYY}”; “{500}”;”{10000}+1 result = 07.Jun.23; 500;10001 (The semicolon insert would allow using semicolon separation when exported to CSV.

In the meantime, an alternative mu-plugin with this functionality would be awesome. ;-)
Thank you for consideration

Wed, 7 Jun 2023 10:20:39
More Forminator Pro discussions
Forminator Pro
  • Luis Soriano
    • Ex Staff

    Hi Winfried Obermüller

    Hope you are doing fine!

    This could be implemented using the current fields features or can also require some custom coding depending on how the serial numbers may be changing. Could you help us answer a few questions about this request?

    1. The “500” part will always be the same?

    2. The “10000” part will be the only one increasing, so after each submission it should turn to 10001, 10002, 10003, 10004…. and so on?

    3. Will the information be submitted by a single user? If so, the last number can be included in the form and add the “+1” to save in the database (this may be possible using the calculation fields). Otherwise, it will have to be saved until the form is submitted, since it needs to verify if other users are also saving records so you don’t end up with duplicated numbers. For instance, 2 users open the form, and they get, for instance “202350010001” as the last number, when they both submit the form, the serial number will be “202350010002” (after adding “+1”) for both of them. In this type of scenario, it is more convenient to generate the serial number after the form is submitted (take into account the serial number will be visible only after submitting the form).

    4. After explaining point 3, could you also consider another option where random code or number is added based on the current datetime to reduce the risk of duplicated values?
    For instance, you could have something like : 202350010000+{random number/code} . Some examples: 2023500100001343555, 20235001000034454545, etc. They won’t be sequential, but you can reduce the possibility of getting same serial numbers.

    We’ll wait for your response to provide the best solution possible. Feel free to let us know if there are any additional questions or concerns.

    Kind regards

    Luis

  • Winfried Obermüller
    • New Recruit

    Dear Luis,
    sorry for the late reply. We really appreciate your interest in this topic.
    I realized, I’ve written a functional request. I’d rather not post that in public, because it might tell to much about our unique process and is basically the advantage over our competitors. We choose Forminator over a shop system for specific reasons.
    Is there a way that I could convey my reply in a private way with email?

    Thank you
    Winni