Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 07, 2020 08:09 AM
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?
Apr 07, 2020 09:25 AM
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?
Apr 07, 2020 09:28 AM
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.
Apr 07, 2020 02:16 PM
I would also like to have an answer to Janae’s question. I have the same issue. Please help. Thanks!
Apr 07, 2020 06:21 PM
@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”:
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.
Apr 08, 2020 08:13 AM
@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.
Aug 24, 2020 06:02 AM
We’ve built an extension that allows you to move a record to another table by using a checkbox.