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?
@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.
@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.