Transfer rows from one sheet to another sheet

[Janae_Young]

I was wondering if there was a way to transfer one row of information from one spreadsheet to another. For example, we have a spreadsheet titled Fosters that has a list of our fosters and it links to our Cat spreadsheet so we can see who is fostering what cat. If a foster then decides to adopt that cat, is there a function that would allow us to check a box or something that would move the person and their information from the Foster spreadsheet to the Adopter spreadsheet?

[Kamille_Parks]

Is there a reason you can’t use one table to store both Fosters and Adopters in table, and use a View to show one “classification” at a time?

Export entries to another table Ask the community

My table consists of customer orders. Once the order has been completed, I would like to move the entry to out of my working table to another that is only completed orders. How can I set up the table to do this? Thanks for your help!

[Janae_Young]

Both the fosters and adopters are very long lists. And the fosters are already broken up into different groups. It will just be quicker and more simple to view if they are on different sheets.

[Valerie_Ericson]

I would also like to have an answer to Janae’s question. I have the same issue. Please help. Thanks!

[Kamille_Parks]

@Janae_Young and @Valerie_Ericson the answer to this question 9 times out of 10 is “don’t use two tables, use one table with two filtered views.” It doesn’t sound like you need two tables unless the answer to any of the following questions is “yes”:

1. Would the combined list of both foster and adoption records exceed your max records-per-table allotment of your Airtable plan? (I believe free accounts can have 1,200 records per table)
2. Can people adopt the cat without fostering it first?
3. Do you need to store considerably more information (5+ fields) for adoption records not included in foster records?

If you absolutely must use two tables: Airtable does not have functionality that will move a record from Table A to to Table B without the use of a third-party integration (Zapier or Integromat) or using the scripting block (the scripting block is free until September, and then will require a pro account). Without either of those options you’d have to manually make a new record in Table B and either: delete the original record from Table A, or link the original record from Table A to the new record in Table B.

For @Janae_Young specifically, it sounds like the following table setup may work for you: [People], [Adoption Records], [Foster Records], [Cats]. When a person fosters a cat, you’d make a record in the [Foster Records] table linking the [person] to the [cat]. If someone adopts a cat, you’d do the same thing in the [Adoption Records] table. Since personal information about each person would be stored in the [People] table, related information would be carried over to the adoption/foster table records without redundancy.

[Janae_Young]

@Kamille_Parks, we do have people adopt cats without ever fostering for us. And fosters come and go, so we have many fosters broken down into currently available, currently fostering, old fosters, not currently available, etc. So we would like to separate the fosters and adopters spreadsheets.

I will suggest using a “People” spreadsheet and/or look into those third-party integrations.

Thank you.

[Moe]

We’ve built an extension that allows you to move a record to another table by using a checkbox.

miniExtensions

Automatically Move Airtable Records To Another Table - miniExtensions

Move records between tables simply by selecting them. They would get copied to another table and will get immediately deleted from the original table.