XForm num_of_submissons value is occasionally out of sync

[kelvin-muchiri]

Environmental Information

• Onadata version: <= v4.8.0

Problem description

The submissions count goes out of sync occasionally

Expected behavior

The submissions count should match the number of submissions after the forms receives submissions, submissions are soft deleted or hard deleted.

Steps to reproduce the behavior

Make multiple submissions to a form. Compare the value in XForm.num_of_submissions and the results of XForm.instances.filter(deleted_at__isnull=True).count()
Import multiple submissions to a form. Compare the value in XForm.num_of_submissions and the results of XForm.instances.filter(deleted_at__isnull=True).count()

Additional Information

Possible approach to resolving this an approach used to update the value for Entity.num_entities field