Hi bwaye,
Sure! I should really write a tutorial on how to do this - it's a handy trick to do all sorts of things.
Here's the gist of it: add a new field to your database table (not form) called "Status". In your case, This would be a radio button with two options "online", "offline".
Then, for your form View(s), just add a new Standard Filter that only shows results that are set to "Online". For more info on Views and the filters, see:
http://docs.formtools.org/userdoc/index....ew_filters
Then, instead of deleting the submissions, you would just mark them as "offline". They would then disappear from view - but still be in the database.
- Ben
P.S. I'm about half-way through a new module called "Submission History". This may help as well. What it does is track all changes made to your submissions - who made them, when, and what changed between each edit. The module also keeps track of submissions that were deleted from the main form, so you always have a paper trail of deleted submissions.
Sure! I should really write a tutorial on how to do this - it's a handy trick to do all sorts of things.
Here's the gist of it: add a new field to your database table (not form) called "Status". In your case, This would be a radio button with two options "online", "offline".
Then, for your form View(s), just add a new Standard Filter that only shows results that are set to "Online". For more info on Views and the filters, see:
http://docs.formtools.org/userdoc/index....ew_filters
Then, instead of deleting the submissions, you would just mark them as "offline". They would then disappear from view - but still be in the database.
- Ben
P.S. I'm about half-way through a new module called "Submission History". This may help as well. What it does is track all changes made to your submissions - who made them, when, and what changed between each edit. The module also keeps track of submissions that were deleted from the main form, so you always have a paper trail of deleted submissions.