Create an Exact Form

This topic refers to functionality that is not available to accounts on the Quick Base Essential plan. If the functionality described here does not match what you're seeing in Quick Base, your account is probably on this plan.

Say you enter all your client contact information in Quick Base and now you want to put it to work. It's time to generate your quarterly sales letters. So how do you get your data out of Quick Base and into your form letter? You can easily generate documents like this by creating an exact form. An exact form is a template you use to insert Quick Base content into documents like letters and invoices.

How exact forms work

If you have permission to create an application, you can create exact forms. Using a special Microsoft Word template, you can insert Quick Base data directly into whatever document you create (like a letter, invoice or work order) and then print the document from within your Quick Base application.

To create exact forms, you download the exact forms template, open it in Microsoft Word, then enter your text—including field codes that Quick Base uses to insert data from your records. Each field code copies values from the field you choose, directly into your document. (If you ever generated a mail merge in a word-processing program, you've seen field codes in action.) When you finish, save the exact form in your Quick Base account and use it to print documents from there.

The following figure shows a Microsoft Word (top left) form with field codes. When a user displays it in a web browser (lower right), the actual data from Quick Base replaces the field codes:

Requirements for exact forms

  • 32-bit version of Microsoft Word for Windows to create exact forms. There is one exact forms template for versions of Word prior to 2007, and one for version 2007 and later.

    Note: If you need a 64-bit version of the template, please open a new case with Customer Care.

  • Permission to create an application in Quick Base.

    Note: Although exact forms use the Quick Base API, they do not require application tokens. In fact, exact forms don't work with any application that requires tokens. If an application requires tokens, you see a blank page. If an application that you'd like to create exact forms for requires tokens, disable tokens for that app.

To create an Exact Form:
  1. Download the Quick Base Exact Forms template for the Microsoft Word version you need to your hard drive:

    Note: The template will not work if you try to use it with Microsoft Word for Mac.

  2. Right-click the template you want and select Save Target As or Save Link As (varies by browser) from the shortcut menu.

  3. If your browser asks whether you want to open or save the file, click Save.

  4. Select a location for the Quick Base Exact Forms template. You can save it on your desktop or in any folder you want. For versions of Word prior to 2007, save the file with a .DOT extension. For version 2007 and later, save with a .DOTM extension.

    Once you've selected a destination folder, click Save.

  5. Double-click the Quick Base Exact Forms template. Microsoft Word opens.

    • If you have Word 2010, the yellow Message Bar appears with a shield icon. Click Enable Content.

    • If you have Word 2007, the Word toolbar displays a Security Warning. Click Options, then enable the macros. In the dialog box that opens, select the Trust all documents from this publisher or enable this content checkbox, then click OK.

    Note: You must select trust all, or at the very least, enable this content for the template to work.

  6. The document that appears contains some explanatory text which includes links to sample documents. Click one of the links to view a sample. To use it as a template, replace the field names with those from your table, then add the text that you want.

    Or, just work in the first document that opens, replace all the explanatory text with your own.

    Note: You must start with one of these templates because these files have built-in features that communicate with Quick Base and let you save the file there.

  7. Design and format the form. You can enter whatever text you want. Include field codes and formulas to draw in specific information from Quick Base. (These fields should all exist in the table to which you link the exact form in Step 8.)

  8. When you finish customizing the exact form, do one of the following tasks for your version of Word:

    • For Word 2007 or later, click Add-Ins > Save to Quick Base As.

    • For versions of Word prior to 2007, click File > Save to Quick Base.

  9. A sign-in dialog box appears. Enter your Quick Base User Name and Password.

  10. If your application uses a custom URL, such as, you must replace the text that Quick Base inserts in the Quick Base Domain field with your own custom domain.

  11. When you complete all fields, click Sign In.

  12. Select the table that contains the data that you want the form to use.

    From the Quick Base Tables list, select the name of the application and table that you want. If that table already has an exact form connected with it, the filename displays in the Quick Base Exact Forms box below the table list.

    Note:  You can save multiple forms in a table as long as you give each one a unique name.

  13. Enter a name for your form, for example, "Letter", then click Save.

    When you save your form, Quick Base generates multiple HTML pages—one for each record in your table. To store each file, the program automatically creates a Formula - URL field in the table you chose. This field is named Print Exact Form name (where Exact Form name is the name of your form).

  14. Add the new Formula - URL field to any reports or forms where you want it to appear.

    Note: Quick Base automatically creates the Formula - URL field that hosts your exact form, but you must add this column/field to any custom forms or reports in which you want it to appear.

    In a table report, click the button in the column heading and select Add a Column from the menu. The new field contains a link that opens the finished product: a document containing information from your application.

  15. To open one of these exact form documents, display a report of your table or a specific record in the table and click this link.

To print an exact form from Quick Base:
  1. Open a report or form that features this field, then click Print Exact Form Name.

    The page displays in a new browser window.

  2. Select File > Print.

    Quick Base Exact Forms print one record per document.

To edit an existing exact form:
  1. Open the Quick Base Exact Form template file, then complete one of the following tasks:

    • Click Add-Ins > Open from Quick Base for Word 2007 or later.

    • Click File > Open from Quick Base for versions of Word prior to 2007.

  2. Select the table that contains the exact form that you want.

  3. Select the form name, when it appears, then click Open.

  4. Complete one of the following tasks;

    To save the form in the same table:

    • Click Add-Ins > Save to Quick Base for Word 2007 or later.

    • Click File > Save to Quick Base for versions of Word prior to 2007.

    To save the form to a different table:

    • Click Add-ins> Save to Quick Base As, then select the new table from the dialog box for Word 2007 or later. Make sure you edit field codes in the letter so they match fields in the new table.

    • Click File > Save to Quick Base As for versions of Word prior to 2007.

To view the exact forms in an application:
  1. Open an application, then click Home, then click Settings.

  2. Click Pages.

Note: If you display an exact form in an application that requires application tokens, only a blank page appears. If an application that you'd like to create exact forms for requires tokens, disable tokens for that app.

Related topics: