incrediBILL - 1:33 am on Jun 7, 2010 (gmt 0)

While we're at it, here's another tip to improve the ADMIN experience - add a TRASH CAN to your database!

How many people delete something just to go "Awww, I didn't mean to do that!" which I do that a lot less than other people do that work on my database.

Additionally, deleting 1 record at a time from a rather large database is much slower than a simple record update.

Recently I decided to address both issues so I added an ACTIVE/INACTIVE field to several large databases which get a lot of updates and removals.

Then I changed the DELETE function to merely update the record to inactive, and changed the main list view to only show ACTIVE records.

Not deleting in real-time saves a lot of time previously just waiting for the action to complete and being able to simply reactivate inadvertently deleted information can often be a life saver when it happens.

BTW, don't forget to create an "EMPTY TRASH" function so you can purge all your inactive records with a single click later.