Table of Contents

How do I move or copy fields or data from one table to another?

Lesley Updated by Lesley

You might run into a scenario where you need to copy or move fields or data from one table to another.

For example, you may realize that one of your tables needs to be a User Role so users can log into your app.

Copy/Move Fields

If you only need to copy or move fields to another table, this article section shows you how to copy fields from one table to another: Copy a Field.

If you no longer need the fields in the original table, you'll have to delete them manually from that table. Currently, there is not a way to bulk delete fields from a table.

If you are copying fields into a User Role table, do not copy the Name or Email fields.

User Role tables come with five special fields including Name and Email. When you copy your Name and Email field into that table, you'll have duplicate fields because the special fields can not be deleted.

You can still import the data for Name and Email into the special fields from your original Name and Email fields.

Copy/Move Data

If you only need to copy or move data to another table, you will need to:

  1. Export the data from the original table: Export Records
  2. Import the data into the other table: Import Records

You can ensure that any existing connections are moved over as well by importing the connections: Import Connections. This requires that the connection field is already set up in the table you're importing into.

If you no longer need the data in the original table, you'll have to delete the records from that table. You can delete records in a batch or clear all records from the table at once: Delete Records.

Copy/Move Fields and Data at the Same Time

If you need to copy or move both fields and data from one table to another, you can do both at the same time using an import. This option works whether you're importing into a new table or an existing table.

You'll follow the same steps as in the last section:

  1. Export the data from the original table: Export Records
  2. Import the data into the other table Import Records

However, this time you'll focus on ensuring the fields are being created as new fields during the import process: 

If it's not already selected, you'll choose the fields in the "Use columns to add new fields" section and select which field type you want to use for the new field. In the example above, we're importing a new field called "Phone" and selecting the "Phone" field type.

If you no longer need the fields or data in the original table, you'll have to delete them.

How did we do?

How do I bulk upload or import multiple files?

How can I show a customer's payment history if I'm collecting payments through my Knack app and through cash or check?

Contact