This topic refers to functionality that is not available to accounts on the QuickBase Essential plan. If the functionality described here does not match what you're seeing in QuickBase, your account is probably on this plan.
Say you enter all your client contact information in QuickBase 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 QuickBase 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 QuickBase content into documents like letters and invoices.
If you have permission to create an application, you can create exact forms. Using a special Microsoft Word template, you can insert QuickBase data directly into whatever document you create (like a letter, invoice or work order) and then print the document from within your QuickBase application.
To create exact forms, you download the exact forms template, open it in Microsoft Word, then enter your text—including field codes that QuickBase 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 QuickBase 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 QuickBase replaces the field codes:
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.
Permission to create an application in QuickBase.
Note: Although exact forms use the QuickBase 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.
Download the QuickBase 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.
Right-click the template you want and select Save Target As or Save Link As (varies by browser) from the shortcut menu.
If your browser asks whether you want to open or save the file, click Save.
Select a location for the QuickBase 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.
Double-click the QuickBase 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.
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 QuickBase and let you save the file there.
Design and format the form. You can enter whatever text you want. Include field codes and formulas to draw in specific information from QuickBase. (These fields should all exist in the table to which you link the exact form in Step 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 QuickBase As.
For versions of Word prior to 2007, click File > Save to QuickBase.
A sign-in dialog box appears. Enter your QuickBase User Name and Password.
If your application uses a custom URL, such as mycompany.quickbase.com, you must replace the text that QuickBase inserts in the QuickBase Domain field with your own custom domain.
When you complete all fields, click Sign In.
Select the table that contains the data that you want the form to use.
From the QuickBase 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 QuickBase 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.
Enter a name for your form, for example, "Letter", then click Save.
When you save your form, QuickBase 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).
Add the new Formula - URL field to any reports or forms where you want it to appear.
Note: QuickBase 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.
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.
Open a report or form that features this field, then click Print Exact Form Name.
The page displays in a new browser window.
Select File > Print.
QuickBase Exact Forms print one record per document.
Open the QuickBase Exact Form template file, then complete one of the following tasks:
Click Add-Ins > Open from QuickBase for Word 2007 or later.
Click File > Open from QuickBase for versions of Word prior to 2007.
Select the table that contains the exact form that you want.
Select the form name, when it appears, then click Open.
Complete one of the following tasks;
To save the form in the same table:
Click Add-Ins > Save to QuickBase for Word 2007 or later.
Click File > Save to QuickBase for versions of Word prior to 2007.
To save the form to a different table:
Click Add-ins> Save to QuickBase 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 QuickBase As for versions of Word prior to 2007.
Open an application, then click Home, then click SETTINGS.
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.
Return to top
© 1999-2016 QuickBase, Inc. All rights reserved. Legal Notices.
Show help contents