Duplicating staff rosters for upcoming weeks

[Matthew_Randell]

Hi,
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?

[kuovonne]

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.