Skip to main content

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!

 

 

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

 


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

 


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.