Jump to content

Tracking individual Field Changes


chzboi
 Share

This topic is 5685 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a value list field called "Project Status" that has various values ("Graphic Dev", "At Customer", "Prepress", etc). I would like to track when this field changes and the time it's in each status or value. Id like the data to look something like this...

Graphic Dev: 3 hrs

At Customer: 48 hrs

Graphic Dev 2 hrs

At Customer: 24hrs

Prepress: 3 hrs

Is this possible?

Any suggestions are much appreciated!

Tom

Link to comment
Share on other sites

The easiest way to do this would be to track the changes in a field would be to use a technique I use logging changes to a field:

http://www.filemakerpros.com/CHANGELOG.zip

However, this will make producing reports on the project more difficult. I would recommend tracking the change to status in a separate table and entering the changes into a portal. This will create a record each time the status changes so you can report on your data in ways you may not have imagined. For instance, you could find the total amount of time spent on Graphic Dev in a 2 week period regardless of the project.

So, I put together a sample file showing how this might be done.

projects.fp7.zip

Link to comment
Share on other sites

This topic is 5685 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.