Take submission OFFLINE with out deleting.

[bwaye]

I use form tools as a CMS. Can I take a submission/post off line without deleting?

[Ben]

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.

[bwaye]

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.

GREAT - will give a try a post back.

[bwaye]

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.

GREAT - will give a try a post back.

THANKS BEN!

work like a charm -

Here is the code i used to filter the results:

mysql_select_db($database_database, $database);
$query_coupons = "SELECT * FROM ft_form_2 WHERE `online` = 'online' ORDER BY name ASC";
$query_limit_coupons = sprintf("%s LIMIT %d, %d", $query_coupons, $startRow_coupons, $maxRows_coupons);
$coupons = mysql_query($query_limit_coupons, $database) or die(mysql_error());
$row_coupons = mysql_fetch_assoc($coupons);