Forum Discussion

Stephony_DBH_'s avatar
Stephony_DBH_
Qrew Cadet
9 years ago

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

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?_
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    9 years ago
    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?
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    9 years ago
    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?
    • LauraThacker's avatar
      LauraThacker
      Qrew Captain
      8 years ago
      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....
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    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)