Why does Forminator store form views?

  • Resolved Olaf Lederer

    (@finalwebsites)


    3 years, 7 months ago

    Hi,
    I’m using one form on thousands of pages as kind of small contact form.
    Today I see in my slow error log that this query takes more time than normal:

    SELECTview_idFROM wp_frmt_form_views WHEREform_id= 74646 ANDpage_id= 12008 ANDipIS NULL ANDdate_createdBETWEEN DATE_SUB(utc_timestamp(), INTERVAL 1 DAY) AND utc_timestamp();

    After checking the database I see that the table wp_frmt_form_views has almost 500K of records. Why all these form view logs and is there a way to disable this function. I don’t need to know hoe often a form was viewed (only a submission counts).

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Nebu John – WPMU DEV Support

    (@wpmudevsupport14)

    3 years, 7 months ago

    Hi @finalwebsites,

    Trust you are keeping well, and thank you are asking this question.

    I am afraid it is not possible to disable only the view count out of the box. This data is used to calculate the conversion percentage.

    I understand your concern and have already pinged our developers to check if we can help you with disabling the view count only. We’ll update you here once we have more feedback on this.

    Kind Regards,
    Nebu John

    Plugin Support Nebu John – WPMU DEV Support

    (@wpmudevsupport14)

    3 years, 7 months ago

    Hi @finalwebsites,

    As mentioned, we do not have any settings to help you with this. To disable the same, you need to edit the following file.

    forminator\library\render\class-render-form.php

    At line number 62, you need to set $track_views to false.

    protected $track_views = false;

    I hope that helps.

    Kind Regards,
    Nebu John

    Thread Starter Olaf Lederer

    (@finalwebsites)

    3 years, 7 months ago

    Hi Nebu,
    I think I will create a cron job that will empty the table once a week.
    Please make this an option, most people track the performance of a form in Google Analytics

    Plugin Support Laura – WPMU DEV Support

    (@wpmudev-support8)

    3 years, 7 months ago

    Hi @finalwebsites

    Thanks for response!

    You can also manually do such clean up “on demand” by simply clicking on “Reset tracking data” item in drop-down menu under the “gear” icon on “Formiantor -> Forms” page, next to the form in question.

    That’s still not “scheduled” clean up but if necessary, it can be done at any time and it will reset views and conversion rate but won’t reset submission counter.

    However, I understand how it would be useful to be able to just disable that tracking or be able to set it to be cleared/reset automatically on a schedule.

    I’ve already suggested it to our Forminator Team. I’m not able to give ETA but I hope we’ll be able to add this in one of future releases of the plugin.

    Best regards,
    Adam

    Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    3 years, 7 months ago

    Hello @finalwebsites ,

    We haven’t heard from you for some time now, so it looks like you don’t have any more questions for us.

    Feel free to re-open this ticket if needed.

    Kind regards
    Kasia

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Why does Forminator store form views?’ is closed to new replies.