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?
Page 2 / 2
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.
‘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. 
t2: t2:
Hi @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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.