Discussions

Expand all | Collapse all

Adding records to details table automatically

  • 1.  Adding records to details table automatically

    Posted 29 days ago
    Hello,

    I am looking for help to fill "blanks" in appointment schedule for mobile workers. Blanks are non chargeable activities (mostly driving between sites).

    Structure of the app is Clients (master table)<Assignments (detail table)

    Assignments are scheduled by the office so each worker has a list of daily appointments on their smart phones. Assignments are NOT calendar/date records, they are records with several fields. Workers' daily schedules are reports of Assignment table ordered in expected start time.

    After an assignment is completed, workers record time it has taken and add notes of what was done, so it becomes a "time sheet" for calculating working hours.

    In order to complete time sheet record for each day, workers have to manually add driving and shopping "assignments" between customer visits, which takes time.

    Is there a way to have a button that would add record to fill gap between assignments? Or have a way to calculate workday between start of the first job and end of the last one; the difference between length of workday and chargeable time would be non-chargeable work.

    I would be grateful for any pointers.

    ------------------------------
    Arkady
    ------------------------------


  • 2.  RE: Adding records to details table automatically

    Posted 29 days ago
    In one of our applications we had a similar situation, scheduled activities > Child Record of "assignment"... in our case, a user was adding the child record, and it defaulted start time to end time of the previous record... The users add a uncharged time record once completing the previous assignment, and then once ended, started the next assignment record. Uncharged vs assignment is a drop down in the child record itself.

    Hope that provides some inspiration for you.

    ------------------------------
    Ryan Stanford
    ------------------------------



  • 3.  RE: Adding records to details table automatically

    Posted 29 days ago
    Hi Ryan,

    Thank you. Yes, using time in current record for the next one helps.

    I can't help thinking that when there is a clear gap between end of one job and start of the next one, it should be possible to add a new record in between. It may need a new master (parent) table and some careful parsing of dates, times and users. Seems like an entertaining puzzle, so wondered whether anyone solved this.

    Thanks again.

    ------------------------------
    Arkady
    ------------------------------