Copy fields into a new table

Hello. I have a table with a field I want to copy and paste into a new table. Seems like a simple thing to do, yet I cannot find out how. Any insight? Much appreciated.

Hi @Rebecca_Povio - if you want to copy the whole field/column, click on the field header to highlight all cells in the column, then CTRL+C to copy. Click on the column header in the new table and CTRL+V to paste. If it isn’t already set to be the same field type, the new column will adopt the field type of the original.

JB

1 Like

To clarify, Jonathan’s suggestion will work if you want to copy data between tables. Copying an entire field definition—including the field type and settings, as well as the data—from one table to another can’t currently be done.

1 Like

Further clarification :wink:

For some field types (and for certain field destinations) data, field type and settings are copied over, e.g. single select, multi-select, date, phone. (The field name isn’t copied over.) If you try to copy data into the primary key field from a field type that isn’t allowed for the primary key, e.g. mulit-select, you will get the values as text, but not the field type or settings.

I’m sure there’s more rules about field/column copy & paste than this - but it clearly works to different degrees in different situations. Probably best to try your scenario and see how far Airtable will let you go.

JB

2 Likes

Thank you, both - the data did copy over but I had to add the field name. Ideally, I would love a way to do the whole thing but the field name is the easiest to update so I’m happy for now!