• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

Lotus Notes capturing field updates and making calculations based on the updates

I am working on an application to track dealer performance in scheduling truck pick ups on time.  I do a daily import of information from our enterprise software keyed on Sales Order# with the following fields:

SalesOrder# , ScheduledShipDate , ActualShipDate , TotalLbs , ShippedLbs , RemainingLbs

Lotus Calculates the number of Trucks needed based on TotalLbs/45000

Customer Service enters in the Lotus app a CustomerConfirmPickupDate  for each truck and assigns number of Lbs to each truck based on trucks actual capacity

I need help with capturing (DateTruckWasConfirmed) the date customer service enters the CustomerConfirmPickupDate which can change if the truck is rescheduled.  So I need some way to allow the CustomerConfirmPickupDate to be changed but maintain each date and the date they were entered.  The goal is to be able to track the following:

1.  Has a truck been rescheduled within 3 days of its CustomerConfirmPickupDate (is the new DateTruckWasConfirmed within 3 days of previously entered CustomerConfirmedPickupDate)

2.  Did the ActualSHipDate occur after the last entered CustomerConfirmPickupDate


Any help or ideas would be greatly appreciated.

0
cinamitton
Asked:
cinamitton
  • 4
  • 2
  • 2
1 Solution
 
Sjef BosmanGroupware ConsultantCommented:
In general:
- use a Status-field to indicate what status the current item is in
- use a History-field (multi-value) to capture a history of status changes
- use a State Transition Diagram to analyse and design your application
- in your code, use the current state and the event that occurred to determine the next state and the actions to be executed
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
cinamittonAuthor Commented:
Sjef,  

I think I understand you concept,  would you have any example you could post?
0
 
Sjef BosmanGroupware ConsultantCommented:
Hm, yes, I was afraid you'd ask me that... It requires quite some time and space though, and I don't have that time right now...

Here's an earlier question with more or less the same topics:
http://www.experts-exchange.com/Q_21384093.html

The history-stuff is a different topic:
http://www.experts-exchange.com/Q_23810866.html
http://www.experts-exchange.com/Q_21707398.html
0
 
Sjef BosmanGroupware ConsultantCommented:
Just out of interest: how did you solve your problem?
0
 
cinamittonAuthor Commented:
I used some of the suggestions from the links you provided with status fields and history fields but found that some of the functionality being requested was not possible to program because there was no related data to work with from the Enterprise data downloads.  They wanted the Notes app to track individual truck loads (manually entered into Notes App) on time performance but there is no related individual truck shipping information provided in the download only a total Lbs shipped each day so there was no way to determine which trucks were associated with the Lbs shipped.  Thanks again for the assistance.
0
 
Sjef BosmanGroupware ConsultantCommented:
Good analysis. Thanks for the update!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now