We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum

Forum

Thread tagged as: Question, Forms

Clearing form responses from database.

Hi there,

I need to clear out roughly 400 form responses stored in Perch.

I don't think there's a way to delete them all at once through the admin but is it safe to just remove the rows in the 'perch2_forms_responses' table using something like Sequel Pro?

Thanks,

John.

John Robinson

John Robinson 7 points

  • 8 months ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

You can't delete all at once, but you can delete a page at a time using the checkbox in the top left, and then "Deleted Selected" at the bottom.

The site is using Perch 2, is that functionality only in Perch 3 as I've never seen it? Is it veasible just to delete the rows in the table instead without breaking anything?

Drew McLellan

Drew McLellan 2638 points
Perch Support

Right, that's only in Perch 3. You should be ok to delete those directly, but make a backup first.

Marvellous, thanks Drew. I've tried it locally and all seems fine.