Skip to main content
Solved

How I can move specific rows of data to another table?

  • Jun 12, 2023 11:14 AM UTC
  • 6 replies
  • 612 views

Forum|alt.badge.img+6

Hi,

I'd like to know how I can move specific rows of data to another table. I have already created an auto move using the extensions however I'm not 100% sure if this will move all data or if I can select what gets moved.

Thanks.

Best answer by JonathanB

You need to set up your automation so that when a record matches certain conditions, it creates a new record in another table that copies the fields you need into the corresponding fields in that table.  Each time you conditions are what you specify, the automation will create the new record.  If the conditions don't match, nothing will happen.

View original
This topic has been closed for replies.

6 replies

Forum|alt.badge.img+17
  • Inspiring
  • Answer
  • Jun 12, 2023 11:19 AM UTC

You need to set up your automation so that when a record matches certain conditions, it creates a new record in another table that copies the fields you need into the corresponding fields in that table.  Each time you conditions are what you specify, the automation will create the new record.  If the conditions don't match, nothing will happen.


Forum|alt.badge.img+6
  • Author
  • Participating Frequently
  • Jun 12, 2023 11:33 AM UTC

You need to set up your automation so that when a record matches certain conditions, it creates a new record in another table that copies the fields you need into the corresponding fields in that table.  Each time you conditions are what you specify, the automation will create the new record.  If the conditions don't match, nothing will happen.


Thank you that's really helped me. 😊


Forum|alt.badge.img+17
  • Inspiring
  • Jun 12, 2023 11:48 AM UTC

Thank you that's really helped me. 😊


No problem 🙂


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Jun 12, 2023 1:24 PM UTC

@JWalker Also, is there a specific reason that you need to move entire rows to another table? Often, people just need to use views, which are different ways of seeing the same records in different ways. I discuss views at length in my free Airtable training course which you can take for free by signing up for a trial membership with LinkedIn Learning: https://www.linkedin.com/learning/learning-airtable/  


Forum|alt.badge.img+6
  • Author
  • Participating Frequently
  • Jun 12, 2023 1:32 PM UTC

@JWalker Also, is there a specific reason that you need to move entire rows to another table? Often, people just need to use views, which are different ways of seeing the same records in different ways. I discuss views at length in my free Airtable training course which you can take for free by signing up for a trial membership with LinkedIn Learning: https://www.linkedin.com/learning/learning-airtable/  


We have 2 tabs one for 'All Events' and another for 'Requests'. 'Requests' has a form and once we click 'Yes' on our 'Accept' column I want it to be transferred over to our All Events Tab. I have sorted it now. Thank you for the links though.


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Jun 12, 2023 1:47 PM UTC

That’s the exact use-case scenario for using views, but glad you found another solution that works for you too!