Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Need Help with Date Calcs


Chad_G

Recommended Posts

I'm working on a time tracking system for tracking dates and lengths of time for the individual construction processes involved in the construction of multiunit homes.

 

I have created many date fields with names such as "Excavation Start" and "Excavation Finish" I am trying to make the database so that a user can enter a date in the excavation start date field and the computer will generate all the subsequent dates for the other fields correlating to the processes of construction that take place after it based on simple addition formulas I provide it. The way I have accomplished this is by using auto enter calculations that look like this: ExcavationFinish= ExcavationStart + 4. Then the next field would be called "UndergroundUtilitesStart" and would have an auto-enter calculation of: UnderGroundUtilitiesStart= ExcavationFinish + 1. So that it would schedule the Underground Utilities installation to start the next day. I have gotten the database to work in this capacity. My problem is that sometimes things take longer than expected, so, for example, I want the user to be able to delete the auto enter calculation result that appears in the ExcavationFinish field and enter the correct date and have that modification affect all the subsequent fields(such as the UndergroundUtilitiesStart field). As of right now, I can only get filemaker to perform the auto enter calculations once, when the first entry is made, and then when i change the first value (upon which all others are dependant) nothing happens. Basically I am looking for a way to tell all the auto entry fields to refresh or update.

 

I would be appreciative of any advice you could give me or any direction you could point me in to get help figuring out how to accomplish this.

Link to comment
Share on other sites

Hi Chad,

 

Perhaps create a series of number fields as a variable in your calcs.

 

UnderGroundUtilitiesStart= ExcavationFinish + 1 + variable. Therefore, at any point in the chronology, any amount of days can be added at the point that things fell behind, and all subsequent operations will carry the extra days.

 

If you catch up the time at any point, the variable can have a negative entry.

 

Wolf

Link to comment
Share on other sites

Good answer Whiskey. But perhaps UNstoring the calculations will cause auto updtes when the base date is changed.

 

laugh.gif Tom

Link to comment
Share on other sites



×
×
  • Create New...

Important Information

Terms of Use