Duplicating staff rosters for upcoming weeks

428 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

We have a base that lists our staff calendar and we have approx 20 employees. When we duplicate the data for the next week, it is very cumbersome to keep the hours the same but change the date for each employee as they all work different hours. Is there a way that we can duplicate a previous working week and get the new dates populated in a more efficient manner?

1 Reply 1

Welcome to the Airtable community!

There are a variety of different methods. One of the easiest to use would be having a script that duplicates the records, adding one week to all the dates. However, that requires being able to write the code, or having budget to hire someone to write the code.

Another possibility is to have a formula field that adds one week to the actual date and time. Then right after you duplicate the records, do a bulk copy/paste from the formula field to the actual date and time field. It is kludgy, but it will work.