If you're managing many QuickBase applications, you may eventually want to consolidate or reorganize tables between applications. If you've come to this pass, QuickBase can help you move tables between applications.
You can take an existing table from any application and move it into another application. When you move a table into an application, it no longer belongs to the original application. This means that the table doesn't appear on the source application's Table bar, and any relationships with other tables in that application are broken. The moved table becomes a table in the destination application. (If you later decide that you don't want this table to be a part of the application, you can move it to its own application, which removes the table from the application but does not delete the table or its contents. You can also delete the table at any time.)
Note: When you move a table into a new application, QuickBase breaks the table's old relationships. This makes it extremely difficult to return the table to its original application. When you create a copy, the table remains in the original application. You may consider copying a table instead of moving a table, if you want to retain the relationships in a table.
Copy the original application with its data or without its data.
Move the table out of the copy and into the destination application.
When you move a table, some attributes of the original application do not carry over to the new application. These attributes are:
Roles and their properties
Users who have access to the table
Custom pages that feature the table
Application variables (what's this?)
Be sure to make a note of any attributes that you want to keep before you move the table. If you move the table to its own application, these attributes reappear in the new application.
Note: To move a table, you must be the manager of the table you want to move and also the manager of the application that you move the table to.
Open the application to which you want to move a table.
From the app home page, click SETTINGS, then click App management.
Click Move a table into this app.
Click Select a Table. A list of your applications appears.
Select the application that contains the table you want to move, then click OK.
If you selected a multi-table application in the last step, select the table you want to move and click OK.
Choose the access permissions on this table to give other roles.
While you're in the process of absorbing a table, it's usually best to grant "no access" until you have everything set up exactly as you wish. Later, you can assign permissions properly via the Customize Roles page. As administrator, you'll have full access to this table, even with "no access" turned on.
Once the table's part of your new application, you're free to create relationships with existing tables.
Tip: When adding tables to an application, you should consider making the term for "record" unique for each table you add so that users aren't confused when they try to add a record. To learn more, see Changing the Term for a Record.
Return to top
© 1999-2013 Intuit Inc. All rights reserved. Legal Notices.
Open topic with navigation