Jan 29, 2024 03:23 AM
Hi all
any ideas how to solve this problem?
can this be doen with the automation or do i need someone to write me script?
night shifts should be split per day, if the time span is over the midnight insert a new row with the working times (Hours) on the next day ... or something like that?
Thx!
Solved! Go to Solution.
Jan 30, 2024 01:34 AM
Hi Zach
Thx!
it is legal obligation (for hourly workers, in Austria) to split the days, when worked over the midnight.
i figured it out
its the automation that finds the record, updates the time fields and creates new record for the next day.
Jan 29, 2024 12:52 PM - edited Jan 29, 2024 01:25 PM
It seems like if someone creates one record for a shift that spans two days, you want to create a new record for the second day with just the hours for the second day (and also edit the original record to only include hours for day 1?).
What about letting the shift be its own atomic thing, and then summing up the hours of all shifts on dates (in a differen table)?
The shifts:
The dates:
The hours on the dates sum correctly.
https://airtable.com/appJb2u1Myw9JqubZ/shr45zUnzX86H7wqi
Jan 30, 2024 01:34 AM
Hi Zach
Thx!
it is legal obligation (for hourly workers, in Austria) to split the days, when worked over the midnight.
i figured it out
its the automation that finds the record, updates the time fields and creates new record for the next day.