AnsweredAssumed Answered

Counters for every time a layout is accessed?

Question asked by AmberFlanagan on Aug 16, 2010
Latest reply on Aug 16, 2010 by philmodjunk

Title

Counters for every time a layout is accessed?

Post

Hello all!

I have been given the lovely task of pruning our current FileMaker database.  To give you a snapshot of what it is, it spans five .fp7 files with over 500 layouts between them and at least 100 of them are completely blank.  There are probably about 100 tables, with some of our larger tables being duplicates of each other and wasting space.

At this point in time, I do know what our utility screens are and only some of our "menu" screens that are used.  But there are many layouts that have been made into reports (some are the exact same reports but have just been sorted differently).  Needless to say, this is a wee bit of a disaster area since this database has gone through at least 5 to 6 different developers, me being probably lucky number 7.  

I was wondering if there was some sort of counter that I can make to put on these layouts that still have something on them so after like a week or so, I would be able to make a fast summary of what layouts have been accessed over the last week.  I might run it for longer if I don't get any satisfying results since I do know some of them are only accessed monthly.

My main goal after this is done is to be able to prune all layouts we don't need out (starting with the blank ones), and to implement these counters on all new layouts here on out.

EDIT: I am using FileMaker Pro Advanced 11 on a Windows 7 OS. I always forget this part.

Outcomes