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

[JWalker]

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.

[JonathanB · Accepted solution]

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.

[JWalker]

Thank you that's really helped me. 😊

[JonathanB]

No problem 🙂

[ScottWorld]

@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/  

[JWalker]

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]

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