Resetting or Customizing Submission ID

  • Resolved rpalex

    (@rpalex)


    1 year, 8 months ago

    Is it possible to reset the Submission ID for a form. We have more than one form for different purpose.

    One of the forms is used for collecting Sponsorship information. For accounting integrity we are required to maintain the Submission ID sequential with no missing numbers in between. Otherwise, if a number is missing in between (if used by another form) there is no way for the Auditor to know whether it was a legitimate entry that was deleted or not.

    Therefore, is there a way to reset the Submission ID for one form and keep it incrementing for just that form.

    The idea of have just one Submission ID for ALL forms is bit confusing. That is not something that we have seen in any other form applications. Is there any plans to change that approach and make it unique to each form?

    Any help would be greatly appreciated.

    Secondly, we like to also create a unique idea with some text appended from field values, such as <lastname><firstname>_,submissionID> or something like that. Is that possible?

    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    Hello @rpalex ,

    We have this custom code snippet which you can use as a guide here :
    https://gist.github.com/wpmudev-sls/b607c860225b0b6bde502bcdec0184fa

    You can download a zip, unzip it and upload the file forminator-custom-submission-number-for-custom-form.php to your wp-content/mu-plugins folder. If that folder doesn’t exist you can simply create it.
    If you want to reset the order number of a form, please log in to the admin and then try to access this URL:
    yoursite.com/wp-admin?wpmudev-fm-reset-order-number-by-form-id=[form_id]

    If you are not familiar with mu-plugins you can read about them here:
    https://wpmudev.com/docs/getting-started/download-wpmu-dev-plugins-themes/#installing-mu-plugins
    or you can paste it into your child theme’s functions.php file.

    Secondly, we like to also create a unique idea with some text appended from field values, such as <lastname><firstname>_,submissionID> or something like that. Is that possible?

    Can you tell me more about that where you want to display this created string? Like in confirmation email?

    kind regards,
    Kasia

    Thread Starter rpalex

    (@rpalex)

    Okay I will try that code.

    The Unique ID is something that we like to save with the User record in the Database AND ALSO display that on the form when the User start entering their basic information.

    For example, as soon as they enter their first name and last name, then we should display YOUR CUSTOMER ID is: <firstname><lastname>-<sequential_next_number>

    But if the User does not complete the Submission that <sequential _next_number> should be released back in to the system, so that there are no gaps in the numbers.

    Plugin Support Kris – WPMU DEV Support

    (@wpmudevsupport13)

    Hi @rpalex

    I pinged our SLS Team to review your second query and see what will be possible in this case. Please note if case will be to complex it can be out of scope of ou support.

    Kind Regards,
    Kris

    Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    Hello @rpalex ,

    Our developer checked your query and I’m afraid it is out of the scope of this forum.

    kind regards,
    Kasia

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Resetting or Customizing Submission ID’ is closed to new replies.