Discussions

Expand all | Collapse all

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

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

    Posted 03-29-2017 14:19
    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?_


  • 2.  RE: Is there a way to copy fields from one table into another

    Silver
    Contributor
    Posted 03-29-2017 14:27
    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?


  • 3.  RE: Is there a way to copy fields from one table into another

    Silver
    Contributor
    Posted 03-29-2017 14:30
    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?


  • 4.  RE: Is there a way to copy fields from one table into another

    Silver
    Contributor
    Posted 03-30-2017 10:03
    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....


  • 5.  RE: Is there a way to copy fields from one table into another

    Top
    Contributor
    Posted 03-30-2017 03:29
    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)