Is there a way to copy fields from one table into another

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I have two separate tables that will have around 100 of the same fields. The tables are separate and the information can not be put into one table due to process and policies. Is there an easy way to copy over fields from one table to the next without having to manually input them twice?
Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
When you display the report, you should have the "More" menu option at the top right of your screen. When you click, "More", do you not have the option to "copy these records to another table" option?
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 2,266 Points 2k badge 2x thumb
1) Will your second table essentially "duplicate" the first table; but only have certain fields in it?
2) Will your two tables have the same Key Field if they are not duplicates?
3) How will you update your second table?  Record by record or in bulk?
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 2,266 Points 2k badge 2x thumb
Another option is to create a relationship between tables A and B and push all the fields down as Lookup fields - you haven't really commented on why you would duplicate data instead of control access permissions etc; or whether the data is supposed to be "aligned" or could potentially change in either table....
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
2 easy options that I've used to duplicate the table.

Option 1:
> If you have one table made already, you can add ALL 100 of those fields to a report.
> Save that report as a spreadsheet
> Then use the option to create a new table from a spreadsheet, then it will go through and it will ask you the field types for all of the fields.  
(With 100 fields that could take some time)

Option 2: (My preference)
> Copy your application
> In the original app, go to the app management settings page
> Select "Move a table into this App"
> find the table in your copied app.
> Transfer
> Then just rebuild any relationships needed.
(shouldn't take more than 5 min, and about 20 clicks)