Missing submission ID numbers

  • Resolved Franklin Seal

    (@franklin-seal)


    2 years, 2 months ago

    On the backend dashboard, Forminator > Submissions the list shows ID# in first column on the left. We have 7 forms, and I understand that the ID#s are issued sequentially without regard to which form of the 7 is used. (BTW, add to Feature Request List to 1. include Form ID # in export spread sheet 2. allow to turn off filtering all together so that you can view all submissions in a single list regardless of which form. Currently, you can only look at the list for each form, so the form ID# sequence is scattered and useless.) However, we had a situation occur where a user was trying to submit a form with a Stripe payment field. The submission would succeed, as would the Stripe authentication, but then, due to her credit card requiring a 3rd party authorization for the transaction, and her not completing it, the transaction was marked “incomplete” in Stripe, so the charge did not occur and hence, the form submission process did not complete. No Admin Notification email was sent to us, nor was the Acknowledgement email sent to the user. But the form ID# was issued, 13 times, since the client continued to refill out the form and submit 13 times. Those forms that used up those 13 form ID#s do not appear anywhere in the submission log. Is there a backend log somewhere that shows each and every form ID# issued and the corresponding data?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Williams – WPMU DEV Support

    (@wpmudev-support8)

    Hi @franklin-seal

    Thank you for your question and for improvement suggestions!

    As for the issue:

    If the submission was unsuccessful, there’ll be no data stored. Forminator “prepares” ID before fully storing data in DB (the ID is indeed from DB but it’s not all the data saved “before” submission) but unless there’s a successful submission, no data is stored.

    There’s no backlog for that, I’m afraid, and if the submission does not show on the list in plugin, it’s not expected to be there.

    That is, unless something else went a bit “off” and, for example, it wasn’t really Stripe blocking submission but rather something on site. It may be possible that some data got saved into DB (even though it’s unlikely).

    But to make sure, you can take a look into the database via phpMyAdmin. You would want to look for the table named wp_frmt_form_entry_meta (it may have a different prefix than default “wp_” on your site but the rest of the table name would be the same).

    Then you would search for “entry_id” records using those 13 IDs. If it doesn’t return anything, I’m afraid there’s nothing we can do to “recover” that data in any way because it wasn’t saved at all.

    If it returns some records, then you can get submitted data from the DB manually.

    Kind regards,
    Adam

    Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    Hello @franklin-seal ,

    We haven’t heard from you for a week now, so it looks like you don’t need our assistance anymore.
    Feel free to re-open this ticket if needed.
    Kind regards
    Kasia

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Missing submission ID numbers’ is closed to new replies.

Tags