hi, i’m currenly trying to use integromat to copy data from one base to another. but when there’s a linked column. it copies its record id instead of its field value. i tried turning on smart link, but it still copies record id instead of its value. any help please?
Solved
Integromat convert record ID to field value
Best answer by Sneh_Patel
Okay. It looked like a different field in the video.
Good to know.
Mary
so i found another solution around it, i made a new formula field in airtable which copies whatever data is in linked field as text, and then using integromat i copied that formula column’s data in may new table. if the formula field has more than one value, it’s seprated by a commna. and i can separate them in integromat by their split string function. and it works perfectly. thanks eveyone for your help. :+1:t2: :+1:t2:
This topic has been closed for replies.
What are the names of the fields that you have linked, so I can use that in the test.
‘client’ and ‘Job Type’
Job Type sometimes has more than one value like “photo, video” both.
+20‘client’ and ‘Job Type’
Job Type sometimes has more than one value like “photo, video” both.
Okay. It looked like a different field in the video.
Good to know.
Mary
Okay. It looked like a different field in the video.
Good to know.
Mary
so i found another solution around it, i made a new formula field in airtable which copies whatever data is in linked field as text, and then using integromat i copied that formula column’s data in may new table. if the formula field has more than one value, it’s seprated by a commna. and i can separate them in integromat by their split string function. and it works perfectly. thanks eveyone for your help. :+1:t2: :+1:t2:
+20Hi @Sneh_Patel
I figured it out. I was going to ask if you could make up some mock bases, with the two fields only in each base, so I can test it properly. One with some sample data and the other empty.
It was really easy to do and it only required two modules.
Mary
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.