![Austin_Tremblay Austin_Tremblay](https://community.airtable.com/legacyfs/online/avatars/2X/8/88bd8aa37d1ef2366e4bbcd26ed35ffda815a2a6.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 02, 2025 04:12 PM
I'm trying to use an automation in a base, but there's something wrong with my flow. And it may be that what I'd ultimately like to accomplish isn't possible.
In Base 1, I have a single-select field named "Status" with various color-coded options as variables to select from. In Base 2, I have a duplicate of the fields in Base 1, but none of the data.
My goal: When the single-select field Status is changed to a particular option (in this case, "Delivered"), the record is copied from Base 1 (Active) and duplicated in Base 2 (Archive). But the flow I have is definitely not correct.
So, one, is this possible? And, two, does anyone know what I need to adjust in the automation flow? Thanks so much for your time!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2025 06:21 PM
Hi,
Usually storing similar entities (records with the same set of fields) in different tables considered as bad design in Airtable. Instead, they should exist in a same table, with a set of filtered views to the different sets of records.
But in your case, you want it to be in other base. So, automation will not help you with that, as the scope of automation is the same base. The tool that suitable for your case is syncing. You can create a view with a limited set of visible fields (hide fields that you don't want to be synced), then filter it to see only 'Delivered' status, and sync that view to another base. Thus, each time new record became 'Delivered', it will be synced to the Base2. If you plan to remove these records after and you want to preserve them in the Base2, just
change this setting
I would also recommend to lock the view afterwards and set some warning to avoid accidentally breaking your sync configuration.
![Sistema_Aotearo Sistema_Aotearo](https://community.airtable.com/legacyfs/online/avatars/3X/d/9/d9d56e9b39ff7c3ba4f7225efe8a0bdca0f2d403.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 02, 2025 05:06 PM
Hiya!
I assume these two tables are in the same base?
You'll need to add every individual field that you want data to be duplicated in to. And on top of that, you'll have to configure each field to populate with data from the trigger source.
It could be quite time-consuming to go through each field if you have hundreds of fields. in addition, if you made a new field in the first table, you'd have to add that and configure it in table 2.
There could be a simpler archiving solution than using another table.
Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/
![Austin_Tremblay Austin_Tremblay](https://community.airtable.com/legacyfs/online/avatars/2X/8/88bd8aa37d1ef2366e4bbcd26ed35ffda815a2a6.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 02, 2025 06:20 PM
They are indeed in the same base.
Thanks for the response. That's interesting to know. I'll have to calculate whether it's worth the labor-intensive effort.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2025 06:21 PM
Hi,
Usually storing similar entities (records with the same set of fields) in different tables considered as bad design in Airtable. Instead, they should exist in a same table, with a set of filtered views to the different sets of records.
But in your case, you want it to be in other base. So, automation will not help you with that, as the scope of automation is the same base. The tool that suitable for your case is syncing. You can create a view with a limited set of visible fields (hide fields that you don't want to be synced), then filter it to see only 'Delivered' status, and sync that view to another base. Thus, each time new record became 'Delivered', it will be synced to the Base2. If you plan to remove these records after and you want to preserve them in the Base2, just
change this setting
I would also recommend to lock the view afterwards and set some warning to avoid accidentally breaking your sync configuration.
![Austin_Tremblay Austin_Tremblay](https://community.airtable.com/legacyfs/online/avatars/2X/8/88bd8aa37d1ef2366e4bbcd26ed35ffda815a2a6.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2025 07:20 PM
Really interesting! Thanks so much for this recommendation!
![](/skins/images/DD0CD7D0ACF200EF4456420D87029A3D/responsive_peak/images/icon_anonymous_message.png)