ProForms add-on issues

Permalink
A year ago I purchased the online forms add-on ProForms. I didn't realise at the time it was no longer supported by its developer. Its support forum looked active, but it was just a bunch of queries with auto-replies.

I've managed to install and use it successfully after considerable effort. The major thing it can't do is show a summary of submitted entries in the control panel interface. The page just doesn't display in any browser, so you can't browse and delete entries. I export the data and bring it into Excel for output.

I gather it was designed to be a static form, put it up and leave it, but I've been using it for events that we run every few months. You can only use one core template and its not practical to duplicate, so I've just added a radio button set on the page to select the current event from a list of this year's events. Clumsy but it works. If I remove the radio button list, all the events (and their submitted data) will revert to the latest event name.

Now its the new year and I want to erase the submitted data from last year, but how? It has no records interface to do it cleanly and I'm unsure how to isolate the records via MySQL.

I'm guessing erasing then reinstalling the add-on may be the only solution but that means rebuilding the complex template.

Any other ideas?

 
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
You need to create a form with a custom sql to truncate the table.
I don't have access to your addon, so I am unable to offer a full solution..
As this is only a 'once per year' action, I would learn to use phpMyAdmin to find and truncate the table..