Support » Plugin: Ninja Forms - The Easy and Powerful Forms Builder » Need to renumber submissions

  • Resolved vask

    (@vask)


    Hello,

    I need to renumber the submissions after testing. Could I just edit the _seq_num meta_key on the postmeta table, for each submission?

    Is there anywhere else that the current submission number is stored?

    Thanks in advance

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author krmoorhouse

    (@krmoorhouse)

    Hey,

    Do you need to re-order them, or just re-sort them by date created (minus your test submissions)?

    -KR

    Hello,

    I deleted the tests, and now I need the numbering (“#”) to start from 1. For example, my first real submission is #35, I need it to be #1, the next one (#36) to be #2 etc.

    Plugin Author krmoorhouse

    (@krmoorhouse)

    Hey,

    Unfortunately, there isn’t currently a feature to do this within the plugin. You would need to make some database modifications to correct the submission IDs.

    Aside from the _seq_num meta_key on the postmeta table for each submission, there is also a _seq_num key on the nf3_form_meta table for each form. This value determines what the next submission will be numbered as. So, if you regroup the submissions, you’ll probably want to set this value to 1 higher than the new most recent submission. That way, it doesn’t leave a huge gap between your reconstructed group and any new submissions.

    -KR

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Need to renumber submissions’ is closed to new replies.