I would like a way to easily copy and paste columns, along with entries, field type, etc. from one base to another.
+4Richard_York wrote:
I use my browser’s Copy/Paste function.
I suppose that mostly works. Although, it doesn’t copy the header or update the header field type. You can highlight cells like in Excel but I wish you could include the headers.
There is no way to duplicate a tab to another base that I see. You have to export it to CSV and then import it to the new base.
+5Kyle_Stenson wrote:
I suppose that mostly works. Although, it doesn’t copy the header or update the header field type. You can highlight cells like in Excel but I wish you could include the headers.
There is no way to duplicate a tab to another base that I see. You have to export it to CSV and then import it to the new base.
Ah. I see your requirement.
Kyle_Stenson wrote:
I suppose that mostly works. Although, it doesn’t copy the header or update the header field type. You can highlight cells like in Excel but I wish you could include the headers.
There is no way to duplicate a tab to another base that I see. You have to export it to CSV and then import it to the new base.
Kyle, if you copy and paste and expand the table to accommodate more fields, the pasted fields will have the same titles and field types as what you copied—read this help article for more details.
+4Katherine_Duh wrote:
Kyle, if you copy and paste and expand the table to accommodate more fields, the pasted fields will have the same titles and field types as what you copied—read this help article for more details.
Hi Katherine,
When copying and pasting, the fields (cells) will update appropriately but the headers with the customized “Field Type” cannot be copied as far as I can tell.
Kyle_Stenson wrote:
Hi Katherine,
When copying and pasting, the fields (cells) will update appropriately but the headers with the customized “Field Type” cannot be copied as far as I can tell.
If you are pasting into existing fields, then the headers will not update according to what you are pasting into it. This is because you may not necessarily want to copy the field type or the headers when you copy and paste something from one field to another—you may just want to copy the raw data.
If you are pasting a greater number of fields/records than are in your table, however, the new fields/rows that are added will have the same titles and field types as the ones you originally copied.
If you are looking to copy and paste the exact same set of fields/records from one table into another table that already has a bunch of stuff in it, I would suggest:
- On the right-hand side of the new table, creating a new, blank field of the same type as the leftmost field of the selection you copied
- Click into the new, blank field you just created.
- Paste (ctrl + V/cmd + V)
- Make sure to select the option to Expand the table so that all of the pasted cells will fit.
If you do this, you’ll only have to change one field type/field name (the first new, blank one you created), and all of the other fields that you paste in will be of the same field type and field name as the data you copied.
+4Katherine_Duh wrote:
If you are pasting into existing fields, then the headers will not update according to what you are pasting into it. This is because you may not necessarily want to copy the field type or the headers when you copy and paste something from one field to another—you may just want to copy the raw data.
If you are pasting a greater number of fields/records than are in your table, however, the new fields/rows that are added will have the same titles and field types as the ones you originally copied.
If you are looking to copy and paste the exact same set of fields/records from one table into another table that already has a bunch of stuff in it, I would suggest:
- On the right-hand side of the new table, creating a new, blank field of the same type as the leftmost field of the selection you copied
- Click into the new, blank field you just created.
- Paste (ctrl + V/cmd + V)
- Make sure to select the option to Expand the table so that all of the pasted cells will fit.
If you do this, you’ll only have to change one field type/field name (the first new, blank one you created), and all of the other fields that you paste in will be of the same field type and field name as the data you copied.
Interesting workaround. I’ll give this a shot. Appreciate the detail!
When I do this, the column name is “Pasted Field 1”, “Pasted Field 2”, etc. I can’t find any way to paste the column titles and settings. Any suggestions?
I’m running into the same “Pasted Field 1”, “Pasted Field 2”, etc. issue. Any solution? I have hundreds of fields for which I would have to change names and field types…
Elaine_Chan wrote:
I have the same problem. I wish there was a copy field option
@Katherine_Duh’s workaround from August 2016 should work for you.
Am I missing something? There is really no way to batch rename fields? @Katherine_Duh’s workaround is not working. I’m still getting the same “Pasted Field 1, Pasted Field 2, etc.”
I would think this would’ve been addressed early on. If people import .csv files, there is no way to copy their row names to the header names?
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.