Help

Re: Can You Identify the Issue(s) with My Flow?

Solved
Jump to Solution
144 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Austin_Tremblay
5 - Automation Enthusiast
5 - Automation Enthusiast

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. 

Screenshot 2025-02-02 at 4.10.08 PM.pngScreenshot 2025-02-02 at 4.04.05 PM.png

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!

1 Solution

Accepted Solutions
Alexey_Gusev
13 - Mars
13 - Mars

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

Alexey_Gusev_0-1738635397555.png

 

Alexey_Gusev_1-1738635413220.png

I would also recommend to lock the view afterwards and set some warning to avoid accidentally breaking your sync configuration.

Alexey_Gusev_2-1738635610150.png

 

Alexey_Gusev_3-1738635645749.png

 

See Solution in Thread

4 Replies 4

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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. 

Alexey_Gusev
13 - Mars
13 - Mars

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

Alexey_Gusev_0-1738635397555.png

 

Alexey_Gusev_1-1738635413220.png

I would also recommend to lock the view afterwards and set some warning to avoid accidentally breaking your sync configuration.

Alexey_Gusev_2-1738635610150.png

 

Alexey_Gusev_3-1738635645749.png

 

Really interesting! Thanks so much for this recommendation!