Changelog / Timestamps
Hi all - I'm trying to create a changelog that shows timestamps when a record's status has changed (i.e. pending, in progress, completed, etc.) I was able to create timestamps for all the different s...
Forum Discussion
Bob,
This is a common issue and I always solve it with this architecture:
Each time the Project is updated, the user is actually adding a child record to the Project Status Change table. You can have all sorts of info there to meet your requirements and more such as Notes or Criteria for the change.
The current Project Status is the value of the very last record added to the Project Status Change table. To get that info into the Project table there are two solutions,
1) Is to do a second relationship from Project Status Change to Project. You then can have look up fields from Project Status Change to Project
2) Write a Formula Query to pull the data up to Projects.
I always use the option 1) because it is so common to need to know many things about a Status Change.
------------------------------
Don Larson
------------------------------
This is a common issue and I always solve it with this architecture:
Each time the Project is updated, the user is actually adding a child record to the Project Status Change table. You can have all sorts of info there to meet your requirements and more such as Notes or Criteria for the change.
The current Project Status is the value of the very last record added to the Project Status Change table. To get that info into the Project table there are two solutions,
1) Is to do a second relationship from Project Status Change to Project. You then can have look up fields from Project Status Change to Project
2) Write a Formula Query to pull the data up to Projects.
I always use the option 1) because it is so common to need to know many things about a Status Change.
------------------------------
Don Larson
------------------------------