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.
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 -
Right click on the 'Transferred To' column name.
Select 'Insert left'.
Enter your new field name for this linked record field.
Select "Link to another record" as the field type.
Select the 'DNA Match Details' table to link to that table.
You should get a popup asking if you want to add lookup fields.
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.
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!
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.
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.
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."
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 -
Right click on the 'Transferred To' column name.
Select 'Insert left'.
Enter your new field name for this linked record field.
Select "Link to another record" as the field type.
Select the 'DNA Match Details' table to link to that table.
You should get a popup asking if you want to add lookup fields.
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.
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.
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.