Help

Copy/Move a record to another BASE

3849 13
cancel
Showing results for 
Search instead for 
Did you mean: 
Enrico_Zoia
4 - Data Explorer
4 - Data Explorer

Hi!
Is there a metod to copy or move a record frome BASE 1 to BASE 2?
Not between two table of the same base but between two differents table.
Thanks

13 Replies 13
M_k
11 - Venus
11 - Venus

Hi @Enrico_Zoia

The best way to do this is by using Integromat, an automation app.

Here’s the link if you want to check it out:

They also have a Facebook forum.

Hope these suggestions help.

Mary

I use integromat but i didn’t find the option “when record matches conditions” (or similar)
Can you tell me what trigger i have to use?

Hi @Enrico_Zoia!

This is the scenario that I use to transfer records from one base to another.

Hope it helps!

image
:

Ok, thank you so much! In “search record” i have to use a formula? What formula is it?

Hi @Enrico_Zoia!

I took a screenshot and made a few comments, inside the image.

Hope this will be helpful!

Mary

image

Now i’m doing this:
I use “Search Record”, if a condition is true it create another record to another table (with the same name). But it doesn’t work. Is it correct this? :arrow_down:
image
image

Hi @Enrico_Zoia!

I am more familiar with how I did my formula, but I think that the formula should be one key or another, not two different unique keys.

This is my understanding.

The other thing you can try, for your formula, type the first part, then after the equal sigh, use the Airtable mapping/value tag. Keep the quotes, though.

Mary

Hi, i’m doing this scenario (i was very busy last week) but integromat do only the first (watch records) and after stops saying “scenario compleate” (but it isn’t true).
Maybe i’ve mistaken something in the formula? Here is a photo
image
The “Da condividere” fields is a ceckbox.
Thanks

Hi @Enrico_Zoia!

Try reversing the formula.

If you can explain a little bit, what you would like your formula to do?

Usually, this formula is going to tell Integromat, that if my unique key (a field that is always different), in Airtable, should be matched with the data coming into the scenario. Then once it matches the correct data, then it will place that incoming data into the correct record.

This is my understanding of this formula field.

Thank you,
Mary