if you just want to replicate this table in a one-shot mode, I suggest that you simply copy the records from the source into the target (assuming that records have the same order and structure)
For a recurring task you may need some sort of automation (understanding that you want to copy, not to link records).
In that case you can setup something like:
This process can work, however you may bear in mind that:
let me know if this makes sense
Thank you. I have managed to set up an automation to create the record on the new sheet when it enters a view on the source :slightly_smiling_face: As part of the automation I would like to take over the thumbnail image but there are so many options from the list that I am not sure which is the right one to select.
Also, if possible, it would be great to have it deleted from the source sheet once its transferred to the new location.
About the thumbnail image, I’m not sure to understand what you mean. Maybe you can add a screenshot and some more details.
Related to the deletion, that it’s more tricky. There’s no action in the automations right now to delete records from a table… so you need to do it by yourself.
If you can put all the pieces together, it will work. However there is always a bit of playing with them.
Thanks, I will take a look at the steps you mention.
I am using the attachments field type and want to take with it the images that are attached when moving it, but there are too many options to know which ones to take across.
(When I was initially creating the automation, I noticed that any fields set as picklist, I didnt need to select all the options - just the Name, for it to populate correctly, the ID and colour didnt need to be part of the automation)
Some fields types in Airtable can be treated differently, especially in automations. You have noticed that there are many properties that can be used for the copy (in this case)
That makes sense, and in the case of attachments, is specially relevant. You may need to copy the ID of the field, or the filename where you uploaded the file from, the size… so some of the properties or the contents of the field.
In your case, based on my test, you should use the URL. Just select it from the automation wizard and test it on your base.
Hope it works, good luck