Skip to main content
Solved

Copying a column heading/field from 1 tab to another


Hi,

I’m experimenting with the RLP with DNA 2023 Airtable template.  I’m trying to personalize the column headings and can’t figure out how to do what I want after reading the Airtable help.  Can someone please tell me the following?  It's really a general question about copying/pasting a column field from one tab to another.

I made a new field called “My Tree” and inserted it on the DNA Match Details tab.  But, now how do I insert that same “My Tree” column on the Kit Access tab?

Thanks!

 

Best answer by siliceous

ckennedy wrote:

Thanks for the link.  I've read that but will read it again.


@ckennedy,

It can take some time to get used to Airtable's features if fairly you're new. To insert a field on the left of the 'Transferred To' field in the 'Kit Access' table -

  1. Right click on the 'Transferred To' column name.
  2. Select 'Insert left'.
  3. Enter your new field name for this linked record field.
  4. Select "Link to another record" as the field type.
  5. Select the 'DNA Match Details' table to link to that table.
  6. You should get a popup asking if you want to add lookup fields.
  7. Toggle the 'MY TREE' field to also create a field in the 'Kit Access' table that will contain the same data as is contained in the 'DNA Match Details' table.

Good luck!

View original
Did this topic help you find an answer to your question?

9 replies

  • Author
  • New Participant
  • 4 replies
  • March 5, 2023

Hi again,

I can't seem to edit my original question on this board; however, I think I may not want to copy/paste a column heading from 1 table to another.  Rather, I think I want to "manage fields," so I can have the same field appear on more than 1 table.  That's really my question.  How do I accomplish inserting the "My Tree" that is in 1 table to another tab/table?  Thanks!

 


siliceous
  • Inspiring
  • 23 replies
  • March 5, 2023

Hi @ckennedy,

If you're wanting to have the same field/column appear on a different table and also display all of the cell data from the column, you'll need to link the tables using Linked records.

'Manage fields' is only available per table. You can't manage all fields for all tables in one place.

 


  • Author
  • New Participant
  • 4 replies
  • March 5, 2023
siliceous wrote:

Hi @ckennedy,

If you're wanting to have the same field/column appear on a different table and also display all of the cell data from the column, you'll need to link the tables using Linked records.

'Manage fields' is only available per table. You can't manage all fields for all tables in one place.

 


Thanks for your reply.  I'm just at the beginning stages of learning about Airtable.  I've watched some videos, but still don't understand.  I'm trying to get the column heading and data under "My Tree" from the DNA Match Details tab to also appear in the "Tree Access" tab in the column before "Transferred To."  Do you have an idea for me?  Thanks so much.


  • Author
  • New Participant
  • 4 replies
  • March 5, 2023
ckennedy wrote:

Thanks for your reply.  I'm just at the beginning stages of learning about Airtable.  I've watched some videos, but still don't understand.  I'm trying to get the column heading and data under "My Tree" from the DNA Match Details tab to also appear in the "Tree Access" tab in the column before "Transferred To."  Do you have an idea for me?  Thanks so much.


I meant also appear in the Kit Access tab right before "Transferred to."


siliceous
  • Inspiring
  • 23 replies
  • March 5, 2023
ckennedy wrote:

I meant also appear in the Kit Access tab right before "Transferred to."


@ckennedy,

I've already described how to do this above. ☝️

Here's some further reading on linked records - https://www.airtable.com/guides/build/connect-data-with-linked-records

 


  • Author
  • New Participant
  • 4 replies
  • March 5, 2023
siliceous wrote:

@ckennedy,

I've already described how to do this above. ☝️

Here's some further reading on linked records - https://www.airtable.com/guides/build/connect-data-with-linked-records

 


Thanks for the link.  I've read that but will read it again.


siliceous
  • Inspiring
  • 23 replies
  • Answer
  • March 5, 2023
ckennedy wrote:

Thanks for the link.  I've read that but will read it again.


@ckennedy,

It can take some time to get used to Airtable's features if fairly you're new. To insert a field on the left of the 'Transferred To' field in the 'Kit Access' table -

  1. Right click on the 'Transferred To' column name.
  2. Select 'Insert left'.
  3. Enter your new field name for this linked record field.
  4. Select "Link to another record" as the field type.
  5. Select the 'DNA Match Details' table to link to that table.
  6. You should get a popup asking if you want to add lookup fields.
  7. Toggle the 'MY TREE' field to also create a field in the 'Kit Access' table that will contain the same data as is contained in the 'DNA Match Details' table.

Good luck!


mbaileyPJI
Forum|alt.badge.img+1
  • New Participant
  • 1 reply
  • March 13, 2025

This was not solved! 

The original poster simply wanted to know how to remove a field from one table and paste it into another table. He was not asking how to link the data. 

Like him, I have created a field with a lot of options (multiple select), and I need this field to be in a completely different table. I need to move it entirely from one table to a different table. 

I’m not trying to link data from one table to another. Just trying to copy/paste a field with all its options. 

Thanks.


DisraeliGears01
Forum|alt.badge.img+6

You should just be able to copy/paste the records from one Airtable base to another. Just set sort functions the same on both tables so the records are in the same order and have a blank multi select field ready to receive the information. Then just Ctrl+C and Ctrl+V the information over. The multiselect options should just be automatically created as they’re populated in the paste. The only potential issue would be if your multi selects have commas in them, I could see that causing paste issues. 


Reply