Create the Copy or Import Button

Before you create a copy or import button, you should understand how the button works and the limitations for the Copy Master and Detail Records option (read more).

Creating a copy or import button using the Copy Master and Detail Records option involves:

Creating the copy or import button

You can either:

To create a button to copy a master record and its detail records:

  1. Open the application to which you want to add the copy button.

  2. In the menu bar on any application page, do one of the following:

    Select Customize > Application and click the Management tab.

    Or select Help > Application Site Map > Miscellaneous.

  3. Click Copy Master and Detail Records.

  4. Choose the table in which the master records exist from the Choose a table dropdown.  A Formula - URL field for the copy button will be added to records in this table.

  5. In the Choose what to copy section, select the Copy the current master record and its detail records radio button.

  6. Select a field from the Choose a field to use as the name of the new master record dropdown list.  The name of the new record will be "Copy of field value."

  7. Click Show Advanced Options if you want to indicate from which relationships detail records are copied or disable the recursive copy of detail record descendants.
    QuickBase can copy up to ten levels of detail records.  If your application has more than ten levels, specify which relationships to copy and/or disable recursion to reduce the number of levels being copied:

  8. Enter the text to appear on the copy button in the Name the button section text box.  You also can accept the default name: "Copy of master record".

  9. Click Create Button.
    A dialog box displays, telling you that the new field for the button was created.  

  10. Click Go to field list.
    The master table's field list opens and contains the new Formula -URL field for the copy button.
    Depending on how the master table's forms are configured, the copy button may be added to its forms:

  11. If the button was added to forms, edit the forms so that the button displays when the form is used only for "view". Click the Forms tab and select the field for the button.  Select view from the Display when this form is used for: dropdown.
    You can also move the button up or down on the form from this tab.
    To make changes to the form later in the Form Builder. In the table bar on any application page, click the table whose form you want to edit. Within the menu that appears, select Customize --tablename-- table > Forms. Click Edit the Layout of the form. (Read more about editing forms.)
    copyButtonFormLayoutCallout.png

    After you save your changes, the example form looks like this:

    copybuttonProjectFormCallout.png

top

To create a button to import specific detail records to a master record:

  1. Open the application to which you want to add the import button.

  2. In the menu bar on any application page, do one of the following:

    Select Customize > Application and click the Management tab.

    Or select Help > Application Site Map > Miscellaneous.

  3. Click Copy Master and Detail Records.

  4. Choose the table in which the master records exist from the Choose a table dropdown.  A Formula - URL field for the import button will be added to records in this table.

  5. In the Choose what to copy section, click the Always import detail records from a specific master record  radio button.

  6. Click the Choose the master record from which to import detail records link. Select the master record and click OK.  

  7. Click Show Advanced Options if you want to indicate from which relationships detail records are copied or disable the recursive copy of detail record descendants.
    QuickBase can copy up to ten levels of detail records.  If your application has more than ten levels, specify which relationships to copy and/or disable recursion to reduce the number of levels being copied:

  8. Enter the text to appear on the import button in the Name the button section text field.  You also can accept the default name: "Import detail records".

  9. Click Create Button.
    A dialog box displays, telling you that the new field for the button was created.  

  10. Click Go to field list.
    The master table's field list opens and contains the new Formula -URL field for the copy button.
    Depending on how the master table's forms are configured, the copy button may be added to its forms:

  11. If the button was added to forms, edit the forms so that the button displays when the form is used only for "view". Click the Forms tab and select the field for the button.  Select view from the Display when this form is used for: dropdown.
    You can also move the button up or down on the form from this tab.
    To make changes to the form later in the Form Builder. In the table bar on any application page, click the table whose form you want to edit. Within the menu that appears, select Customize --tablename-- table > Forms. Click Edit the Layout of the form. (Read more about editing forms.)
    importbuttonFormLayout.png

    After you save your changes, the example form looks like this:

    importbuttonProjectFormCallout.png

top

Testing and troubleshooting the copy or import button

After you add a copy or import button to a master table and its forms, test it in your application to make sure that it works correctly.  (If you did not add the button to the table's forms when you created the button, add it to at least one form in order to test it.)  When you click the button, you either receive a message confirming the number of records that were copied, or an error message.  If the copy is successful, check that all of the records that you expected to be copied were copied.

Common issues and possible solutions include:

Once you figure out what went wrong and how to fix it, it's recommended that you delete the existing Formula - URL field for the button and create a new one.  If you would rather edit the existing field (if, for example, you have already added it to reports and forms), create a new button with a different name that behaves correctly and then copy the text in its Formula - URL field and paste it into the Formula - URL field for the existing button. Save your changes, and then delete the new button.

top

Adding the copy or import button to reports and additional forms

Now that you have a working copy or import button in the master table, and possibly the table's forms, you can add it to reports and additional forms.

The Formula - URL field for the button is created as a default column for reports.  If you create a new report that uses default columns, the button appears on the report. Or, specify the field when selecting custom columns for a report.  You can also edit existing reports to include the button. (Read about creating and editing reports.)

Depending on how the master table's forms are configured, the import button may have been added to its form when you created its Formula - URL field. If it was not created, or if you want to add the button to additional forms, simply edit the forms and add the button. On the Form Builder Elements tab, set the button to display when the form is used only for "view". (Read more about editing forms).

top

Ensuring application users can use the copy or import button

Make sure that all users who can view forms and reports with the copy or import button have the right permissions to copy the records:

Users receive an error message when they try to use the button if they don't have the right permissions. (Read more about roles.)

If you want to restrict use of the button to certain roles, use custom forms to associate forms with the button with those roles (read how).

top

Related Topics

 

Return to top

© 1999-2011 Intuit Inc. All rights reserved.