How do I clear forms?

Permalink 1 user found helpful
I have forms on my concrete website that users have filled out. I want to clear these entries but so far haven't been able to figure out how. Could someone point me in the right direction?

 
cannonf700 replied on at Permalink Reply
cannonf700
Go to Dashboard > Reports > Form Results. Choose the form you want to view. When you choose to view the form results you can delete them from here.
atconcrete5 replied on at Permalink Reply
Thank you for responding to my question. Yes I have looked there and am there now, but I just don't see any place in the "form results" where I can delete entries. I have tried clicking on everything I see but don't come up an option anywhere to delete the entries of my forms...
agedman replied on at Permalink Reply
agedman
Underneath the "Form Results" summary, you should see a section called "Responses to 'MyForm'" that should list each response. If you don't see that, you may need to click the link "View Responses".

Below each response, you should see a link "Delete Response" at the right side. If you have a lot of responses, it may be easier to delete them from the database directly.

I'd back up your database first, but you could try substituting your form name in these two SELECT statments. If the results look right, just replace "SELECT *" with "DELETE"

1. SELECT * FROM btformanswers WHERE asID IN (
SELECT fas.asID FROM btformanswerset fas INNER JOIN btform f ON fas.questionSetID = f.questionSetID WHERE f.surveyName = 'MyForm' )

2. SELECT * FROM btformanswerset WHERE questionSetID IN (SELECT f.questionSetID from btform f WHERE f.surveyName = 'MyForm' )

It might be a reasonable feature request to have a link or button in the "Form Results" area to perform this sort of bulk delete.
atconcrete5 replied on at Permalink Reply
Thanks very much for responding.

It's strange, but here's what I have:

Reports

View Responses

View All Fields (under each form result)

And that's it. At that level the only optin under the results is "Hide Fields"

Nowhere along the way is there any link anywhere on the page that says delete, or anything like it. I've looked all over, clicked every possible button but it simply isn't there.

I don't know what to do? Is this a bug in the program?

I'm using version 5.3.2

I don't have the know how to remove them from the database...
agedman replied on at Permalink Reply
agedman
I'm attaching a screenshot. If you hover over the text "View Responses" it should appear as a link. Click it and you should see all the responses with a delete link for each.

I'm not familiar with the version you're running. If you don't see the link, maybe you can post a screenshot?

Hmm... not sure if either of us will be able to attach. Tried a few times - not working.
atconcrete5 replied on at Permalink Reply
Thank you for responding to my post. Nope there aren't any delete links where you say. Believe me I've looked at least a dozen times thinking somehow I magically missed them. The only links are view responses, and then view all fields, and when I click view all fields the link changes to hide fields. There must be a bug in my version. I'm going to try upgrading as another responder suggested and see if that does it.
cannonf700 replied on at Permalink Reply
cannonf700
I would consider upgrading to 5.4 . It's a great release and would solve your problem immediately.
atconcrete5 replied on at Permalink Reply
Thanks for your help. I'm going to upgrade in October, after I have run a course I'm currently advertising on my site.
peter17 replied on at Permalink Reply
I'm using version 5.5.2.1 core Form block and I cannot find a way to just click a button to purge all the entries in a single form. I have a form with over 300 entries.

Is there one?

The person looking after the site now does not have any experience other than updating the site content and I need a simple solution.

This would be a great enhancement if it is not available now.

Thank you for any help.

I have revised the code below to work in 5.5

I'd back up your database first, but you could try substituting your form name 'MyForm' in these two SELECT statments. If the results look right, just replace "SELECT *" with "DELETE"

1. SELECT * FROM btFormAnswers WHERE asID IN (
SELECT fas.asID FROM btFormAnswerSet fas INNER JOIN btForm f ON fas.questionSetID = f.questionSetID WHERE f.surveyName = 'MyForm' )

2. SELECT * FROM btFormAnswerSet WHERE questionSetID IN (SELECT f.questionSetID from btForm f WHERE f.surveyName = 'MyForm' )