New to the community? Start here

[Forminator Pro] Form entries not showing correctly

Hej,
I have different forms set up. For whatever reasons in some of thef form not all of the required data is shown neither in the admin email nor in the admin backend. Only way for me to see the details for some fields is direct access to the database. Any idea?

Thanks
jochen

Mon, 9 Sep 2024 6:17:54
More Forminator Pro discussions
Forminator Pro
  • Shamser Suzon
    • Staff

    Hi jochen ,

    Thank you for reaching out to us!

    Could you please, mention the form names where you are facing the issue?

    Also, Could you please grant Support Access for your site, so that I can check the back end? Please, check this out to learn more about how to enable Support Access: https://wpmudev.com/docs/getting-started/getting-support/#enabling-support-access

    Please do reply here when access is granted because the support team doesn’t get a notification when support access is granted.

    Looking forward to hearing from you soon!

    Kind Regards,
    Shamser.

  • jochen
    • New Recruit

    Hej,
    thanks a lot for the quick reply! Support access has been granted. It is about the forms “vorbestellung Avocado August 2024”, “vorbstellung Orangen November 2024” & “Vorbestellung Granatäpfel 10-2024”.

    Best,
    jochen

  • Adam
    • Support Gorilla

    Hi jochen

    Thanks for response and granting access.

    I checked the forms but we’ll need some additional information.

    1. I don’t see any form with “Vorbestellung Granatäpfel 10-2024” name but I see the “Vorbestellung Grapefruit 10-2024” one – is this the one you mean or did you remove the other one?

    2. None of those forms have e-mail notifications set

    You mentioned that there’s data missing in e-mails but without notifications form wouldn’t set any e-mails on its own, unless they have some 3rd-party integration configured for that – but they don’t have it.

    So in order to get data sent to e-mail, you would need to first configure e-mail notifications for those forms:

    https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#email-notifications-forms

    3. More importantly – what data exactly is missing? I mean:

    – is it about some specific fields data only (if yes which ones)?
    – or entire submissions are missing and showing up only in DB?
    – if it’s the latter – can you check such submission in DB and see if in the “is_spam” column in wp_frmt_from_entry table?

    Or is it, by any chance, about the “numbering’? For example, the fact that for the “Avocado August 2024” form in entries there are “gaps” in numbering, like after entry 960 the next one is 964 instead of 961?

    Kind regards,
    Adam

  • jochen
    • New Recruit

    Hej,
    I disabled the email notification. However, I realised it is missing in the emails.

    The issue is regarding some specific fields. In the form “Orangen Vorbestellung November 2024” you may see some entries. These are missing the name and email fields, even though those are required within the form. I only can lookup name and email in the DB directly.

    Does this help?

  • Adam
    • Support Gorilla

    Hi jochen

    Thanks for response!

    I’ve tested it and I could replicate it. Even when I imported that form to my own setup and tested there – it’s the same. Initially, I thought it may be related to specific setting of the “Auto-fill” option but even with it disabled – those fields’ data is only visible in the database.

    I admit that’s quite a strange issue and we’ll need a bit of help from our developers with it. I’ve asked our Second Line Support to look closer into this issue.

    They’ll investigate it and we’ll update you here soon with more information.

    Kind regards,
    Adam

  • Prashant
    • Staff

    Hi jochen

    I hope you are doing well.

    We have worked on your issue and found a solution. Please add a must-use plugin to your site’s wp-content/mu-plugins folder like this https://wpmudev.com/docs/using-wordpress/installing-wordpress-plugins/#installing-mu-plugins, then add the following code to the plugin’s php file:

    <?php
add_action(
	'wp_ajax_forminator_save_builder',
	function () {
		if ( ! isset( $_POST['data'] ) ) {
			return;
		}

		$data = json_decode( wp_unslash( $_POST['data'] ), true );
		if ( ! isset( $data['wrappers'] ) || empty( $data['wrappers'] ) ) {
			return;
		}

		if ( 46603 !== intval( $data['settings']['form_id'] ) ) { // Please change 46603 to your form ID.
			return;
		}

		$changed = false;
		foreach ( $data['wrappers'] as $wrapper_key => $wrapper ) {
			foreach ( $wrapper['fields'] as $k => $field ) {
				if ( $field['parent_group'] !== $wrapper['parent_group'] ) {
					$data['wrappers'][ $wrapper_key ]['fields'][ $k ]['parent_group'] = $wrapper['parent_group'];
					$changed = true;
				}
			}
		}
		if ( $changed ) {
			$_POST['data'] = addslashes( json_encode( $data ) );
		}
	},
	8
);

    Note: In the code please change 46603 to your form’s ID.

    After adding this snippet please update the form and after updating the form please remove the snippet.

    We recommend to test this on the dev/staging version first before putting it on the live site.

    Hope it will solve your problem.

    Kind Regards
    Prashant