Help

Auto copy/paste records from one table to another

Topic Labels: Automations
Solved
Jump to Solution
1055 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.