Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Auto copy/paste records from one table to another

Topic Labels: Automations
Solved
Jump to Solution
2261 4
cancel
Showing results for 
Search instead for 
Did you mean: 
SharonLEE
4 - Data Explorer
4 - Data Explorer

Hello,

I have 3 tables Beijing, Shanghai and General in the same base. I want to auto copy/paste records from the first two to Table General when any records input in them. I created 2 automations with same triggers when a record enters a view and same actions to create record in Table General for Table Beijing and Shanghai respectively. I have 2 questions.

Question 1 - Automation BJ ran well but empty lines created without any data appearing. 

Input 2 lines of data in Table Beijing,

SharonLEE_0-1692668498332.png

Automation BJ ran successfully (the first two at 10:21 and 10:22).

SharonLEE_1-1692668568437.png

Line 3 and 4 were created but without any record in Table General.

SharonLEE_2-1692668775569.png

Question 2 - Automations SH didn't run at all.

Input records in line 5 in Table Shanghai.

SharonLEE_3-1692669042625.png

The automation didn't run at all even though it tested well.  

SharonLEE_4-1692669353338.png

I did delete the automations and recreated new ones from scratch but they didn't work.

Can anyone help? Thanks

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Multi-source Sync is possible if the fields are similarly configured.

Multi-Source syncing overview | Airtable Support

See Solution in Thread

4 Replies 4
Sho
11 - Venus
11 - Venus

Hello @SharonLEE ,

I have a suggestion.
How about unifying the tables into a General table and filtering by city in the View?
It is difficult to maintain data consistency using Automation.

SharonLEE
4 - Data Explorer
4 - Data Explorer

Thank you Sho! 

The table Beijing and Shanghai sync from other workspaces. 

Is there a better way than automation?

 

Sho
11 - Venus
11 - Venus

Multi-source Sync is possible if the fields are similarly configured.

Multi-Source syncing overview | Airtable Support

Thank you very much @Sho ! That's exactly what I want to do.