This could be done with an automation, but you would need to figure out how to tell the automation which records to “find” from the first table that you subsequently wanted to “paste” into your linked record field.

If so, you could just use a “Find Records” step in your automation, and then the next automation step would be to insert the list of records that were previously found into your linked record field.

Hey Scott - thanks for coming back so quickly.

I’ve had a play around and can only seem to get one of the twenty records to work…

I added a ‘run automation’ check box to trigger it - would you mind having a look and see what I’m missing please?

The base is here…

Thanks,


Curtis

I don’t have access to your base… but why don’t you just post a screenshot or a video? That would probably be easiest to explain.

Hi,

Yes, that should be very simple ‘from the other side’. Just copypaste whole Name Column into ‘choir’. If links not created, check difference in values (extra space, wrong letter etc)

Hey Scott - sorry for the delay coming back to you…


Here’s a video - so close yet so far!


-C

For your “update record” action, you’re telling it to put in just one name. You have to pull from the “find records” step and choose “make a new list of names”.

I mean not ‘choir’ (it looks like linked field), but the field of MB table, which links to 22W. What you doing now is really a waste of time.


How much records do you have in unfiltered MB? 418 ? if you add ‘count’ field to each link field and see Sum, it’s the same number for both tables. That quickly helps to understand how linking working.

Automation works too, you just should put there all the values found by ‘Find records’, as @ScottWorld advices.


I’m not sure about list of Names, as they are the same and I don’t know how table engine inserts them. Maybe list of Names works too but List of ID should work 100%

Oh right, do “List of Record ID’s” instead of “List of Names” for 100% accuracy under all circumstances.

Thanks, @Alexey_Gusev! :cowboy_hat_face:

Hey Alexey & Scott

Thanks so much for your help and advice on this. What you’ve said makes perfect sense, but I still can’t get it to work… If you have a moment, here’s yet another video showing the issue:

gvideo 3](https://www.dropbox.com/s/ea2lq96wjjae3hx/airtable%20HELP3.mov?dl=0)


https://www.dropbox.com/s/ea2lq96wjjae3hx/airtable%20HELP3.mov?dl=0





I've tried everything it would seem but nothing will make it run properly!


Thanks


Curtis

gvideo 3](https://www.dropbox.com/s/ea2lq96wjjae3hx/airtable%20HELP3.mov?dl=0)


https://www.dropbox.com/s/ea2lq96wjjae3hx/airtable%20HELP3.mov?dl=0





I've tried everything it would seem but nothing will make it run properly!


Thanks


Curtis

Where it is specifically asking you for a Record ID, you are not giving it a record ID. Where it asks you for the record ID, you need to specify the Airtable Record ID from the trigger step.

I think what we’ve all learnt today, is that I don’t understand Airtable as well as most!


Thanks ever so much - I really do appreciate it.


It works