Copying a record from one airtable to another

[Jeffrey_Needle]

Hi. Is it possible to copy a row in a table to another table? I need to do this, effectively moving completed items to a file that accumulates the completed tasks. Any way to do that? Thanks!

[Emilio_Esteban]

Why a SEPARATE table is a must for you? Maybe you can set up a simple “task completed (yes/no)” field to cover the same purpose?

[Julian_Kirkness]

… and then use filtered views to show you Outstanding or Completed items as required.

However, it IS possible to copy records from one table (and even another base) if you want - but you would need to use something like Zapier to do it (although I don’t believe you would be able to delete the original record with Zapier).

[marcellus124]

I’m sure there will be cases that copying/moving records would be necessary. I was thinking @Jeffrey_Needle might be using a form view that links to this airtable. Hence, he wants to remove tasks that are already done, otherwise, his form would have a very long dropdown populated by completed tasks.

[Veronica_Rivera]

Hello Julian !

Ok so I keep looking this issue up and I understand i can categorize my views differently to avoid the seeing the unwanted rows however i really want to know how i am able to change a row into a different table with Zapier. I would rather look at my sold customer list in a different table all together.

[Moe]

If you would like to automate the process of copying records between tables (by adding a checkmark for example), you can use this extension. It automatically copies any record that goes into a specific view and add it to another table.

miniExtensions

Automatically Copy Airtable Records To Another Table - miniExtensions

Copy records between tables simply by selecting them. They would get copied to another table and will get a checkmark added to them to confirm.