Duplicating multiple records within one table

Topic Labels: Base design
6869 23
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

What’s the best way to go about designing a table so that my team can duplicate multiple records at a time? For context, we are grant writers, and we want the tasks and subtasks for each grant to be the same. So I created a template that has 8 records. Right now, we have to make a copy of each record of the template and assign it to the correct grant. That of course leaves room for error. How can we duplicate the template Tasks at one time?

Thanks in advance.

23 Replies 23
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi Ashley! Welcome to the forum. I’m guessing that you’ll be able to solve this problem by organizing your base differently. Can you provide a little more specifics? What are the record categories that you want to duplicate?

Hi thanks for responding. Sure!
The Tasks tab will be used to keep track of the progress of grants, which we want to have standardized sub tasks for each step.
The preferred view is grouped by grant so all the steps for the grant are together. To standardize the steps, I created a template grant with each step and sub tasks. Each time we add a new grant, we make a copy of each step of the process from the template and then assign it to the correct grant. So the overall purpose of the Task tab is to standardize the writing process, assign sub tasks to people, and for me as supervisor to be able to monitor overall progress of each grant.

Ashley N. Ashe
Gateway Grant Services

Is there a reason why you’ve decided not to add columns which have each of these tasks? Organized this way, you’d have each task replicated each time you create a new grant record. Like this:

Screen Shot 2020-11-25 at 8.34.10 AM

We did not go that route because there are 8 Tasks with 5-8 Subtasks in each. That would be a really long table and difficult for me as supervisor to visually see where each project is. Also, I’d like to assign each task to a team member.

Can I send you my current setup so you can see what information I’d like to capture?

Sure! Feel free to share here or send me a share link in a private message.

I tried to create what you suggested - it’s Tasks 2.

Hi Ashley, That’s very helpful to see what you’re tracking. Honestly, I don’t think you’re missing any brilliant solutions - it’s just a lot of information to track. It’s almost like you need a table within each row (this would be totally doable in a custom database, but I can’t think of a way to do it in Airtable). One thing that might be useful is to think about which pieces of information are most important to see all together in a summary page, then to build according to that. For example, maybe the most important thing is to have one spreadsheet that shows what each person is responsible for. Then your key spreadsheet that connects everything would be one where the Name column is “collaborators”. Maybe it’s knowing that each grant has all tasks assigned to a person.

If I were designing this system for me (everyone organizes in different ways), I think I might have each grant in its own tab. To create a new grant (and replicate all of the tasks), you would right click the tab, click “Duplicate Table”, and enable the option to “Duplicate Records”. This creates lots more tabs, which might mean that you’d need to separate the grants entirely from the rest of the base, which is essentially a CRM (contacts, foundations, etc), and link the bases via Airtable’s new “sync” feature. I think of this just like organizing parts of my house - I can have a box and a label for everything, but at some point, with enough stuff, I have to either throw things away or find another room! Hope that’s helpful…

Screen Shot 2020-12-04 at 3.53.55 PM

Hi Julian,

It sounds like you may be in need of some Airtable Automations. I think your issue can be solved pretty easily by using these, because it sounds like the tasks and sub-tasks associated with your grants stay fairly consistent. I created a test base to show what I mean: Test Tasks Base. Copy it into your workspace and take a look at it.

I have 3 tables set up, 1 for the Project (or grant), another for the major Tasks associated with said project, and yet another for the Sub-tasks associated with each of those major tasks. Then an automation set up. Whenever you add a record to the projects table (ie, a new grant), the automation will run and create tasks in the Tasks table and sub-tasks in the Sub-tasks table. Give it a try yourself by adding a new project.

Creating the automation may get a little messy since you have many tasks, but it sounds like this is on the right track.