Alpha Video Training
Results 1 to 4 of 4

Thread: Hourly and calendar based job list - help for a novice

  1. #1
    Member
    Real Name
    Emile van der Merwe
    Join Date
    Jun 2003
    Location
    New Zealand....sort of
    Posts
    15

    Default Hourly and calendar based job list - help for a novice

    Hi there.

    I need some directions in how to setup an hourly and calendar based database. I have equipment that need servicing either by the hours they run or by the date and by whichever come first. Based on the historical service record I need to create "Job List" for all the equipment. I just can't figure it out yet. THANKS.

  2. #2
    "Certified" Alphaholic Ray in Capetown's Avatar
    Real Name
    Ray Hendler
    Join Date
    Jan 2009
    Location
    South Africa
    Posts
    2,036

    Default Re: Hourly and calendar based job list - help for a novice

    The date side is easy - for each item besides whatever else you need - have a fields for last serviced date and duration (days/weeks or months)to next. Each time the list is viewed a calculated field can give you the date of next service
    The Hours depends,
    .... if you know how many hours per day and which days of each week the item runs (to skip weekends at least) requires the same fields (at a minimum) and a more complex calculation to predict next service date.
    .... if not then you have to set up a timesheet logging table.

    Tell us in a little more detail.
    ..The scenario
    ..Have you got any records existing
    ..your level of experience with A5 -to more effectively assist
    Last edited by Ray in Capetown; 06-02-2013 at 05:04 PM.

  3. #3
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    5,992

    Default Re: Hourly and calendar based job list - help for a novice

    are you trying to do this in a desktop app or a web app? ad what version of alpha are you working?
    Dave Mason
    dave@aldaweb.com

    Skype is dave.mason46

  4. #4
    Member
    Real Name
    Emile van der Merwe
    Join Date
    Jun 2003
    Location
    New Zealand....sort of
    Posts
    15

    Default Re: Hourly and calendar based job list - help for a novice

    Hi there. Thank you for your reply. I appreciate it heaps. My email was wrong and never seen your replies till now.

    I did manage to come up with a solution thanks. Very similar to your idea Ray. Thanks again for your reply.

Similar Threads

  1. Hourly sales report
    By JetLi in forum Alpha Five Version 11 - Desktop Applications
    Replies: 8
    Last Post: 05-31-2012, 06:38 PM
  2. Web Based Calendar Example
    By jkletrovets in forum Code Archive
    Replies: 0
    Last Post: 11-09-2008, 08:25 PM
  3. Novice questions re mail list database
    By Stan Rabbiner in forum Alpha Five Version 5
    Replies: 5
    Last Post: 08-10-2003, 02:48 PM
  4. Total Time x Hourly Rate
    By Sharon Stewart in forum Alpha Five Version 4
    Replies: 2
    Last Post: 10-18-2001, 07:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •