Conditional Automation of fields between dates

[cpatainbuslines]

Hello!

I have created a table view based off my main table to keep track of my drivers working hours. Legislation requires me to input something for each date, so on days they are off I have to write "Off". I have it set up that they fill out a form, which fills the main table. How can I set an automation to create fields in between the dates, each time a driver fills out a new form?

Any help is appreciated because I've tried so many ways and it keeps giving me errors

[TheTimeSavingCo]

Hmm, my understanding of what you need is:
1. Record exists for Driver A for 1 June 24
2. Driver A submits the form for 4 June 24
3. Records need to be created for 2 June 24 and 3 June 24 with "Off"

Is that right?