A FMT Preferred FileMaker Consultant - Developer
Log in
Hot & Trending on FMT

FileMaker and Accidental Deletes

I have a FileMaker database with 4000+ records and an intern is deleting records by mistake pretty frequently. Do you know of a way to prevent accidental deletions (I read your validation solution) and still be able to edit the record easily?

DWAYNE RESPONDS
My first reaction would be to introduce record level access privileges to the database system. Record Level Security is the method of controlling a users access privileges on a record by record basis. I've written about it in the past, here is just one of those posts (click here).

Although I really like this FileMaker feature, it may not be the solution that best fits your needs. You might want to adopt a delete flag system. Remove the ability to delete records from the interns password but add a delete button / delete flag field. When a user wants to delete a record, they click the button, which then sets the flag. They could also set the flag directly but nothing beats a big old red delete button.

Anyway, at the end of the day or so, a user with delete access can find all the flagged records. After doing the find, you may want to export that found set to an archive (or not) or you might want to make a backup of the database for storage (or not). The idea is that you might have a way to rollback deleted records.

Then the user with delete access can review the found set of delete flagged records (or not) before deleting them. The review process can be used to unflag records you know shouldn’t be deleted. It also will give you a chance to see if you can detect any patterns in the accidental deletes. If you detect a pattern, then you can educate the intern/user or build in programming to sidestep accidental deletes going forward.
=
More info about the author and FileMaker in general, contact me at This email address is being protected from spambots. You need JavaScript enabled to view it..

© 2008 - Dwayne Wright - dwaynewright.com

 

 

Read more

Dwayne Wright

Dwayne Wright is quite simply put one of favorite authors. Dwanye has been around with us since the days of AOL. No matter what FileMaker subject you are looking for Dwayne has wriiten something on it.

Be sure and visit his blog listed below.

Website: www.dwaynewright.com/