Adding records to details table automatically
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 (m...
Forum Discussion
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
------------------------------
Hope that provides some inspiration for you.
------------------------------
Ryan Stanford
------------------------------
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
------------------------------
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
------------------------------