Erase all recorded data in an online form

Tommy De Notarpietro asked on January 6, 2017 15:56

Is there an easy way to erase all bizform recorded data ( not in code )? I want all data to be empty and new requests starting with 1.

I think there are many cases when users are testing a form and want all test-data to be erased afterwards.

Correct Answer

Zach Perry answered on January 6, 2017 16:07

If you want the ID to start with 1, you would have to truncate the table. The other option is to delete all the records and reseed the table.

Both options would have to be done through SQL. I don't think the bizfrom data is tied to any other table. Just do a backup before you do it.

1 votesVote for this answer Unmark Correct answer

Recent Answers

Tommy De Notarpietro answered on January 6, 2017 16:34

I already tested with an sql truncate. The records were gone, but in the overview it still showed the form has x entries. That is why I didn't feel sure about this solution. I also tried the "clear cache", but it still showed there were entries.

After the first form request has been done, the entries are shown right ( 1 entry ). So when there's no catch, this solution would be ok for me.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on January 6, 2017 17:18 (last edited on January 6, 2017 17:18)

As Zach stated, do a sql truncate to clean the records and start from 1 again. Easiest way to clean up the "X" entries, is to add a new record and delete it as that count is updated with each insert and delete. That count is stored in a different location with the actual definition of the form and not the form data.

2 votesVote for this answer Mark as a Correct answer