F2 Lookup List Feature

<< Click to Display Table of Contents >>

Navigation:  QuoteWerks Help > CHAPTER 6: Customizing QuoteWerks >

F2 Lookup List Feature

QuoteWerks allows you to create lists of options to choose from when filling out certain fields.

To display the lists of options for a particular field, while you are in that field, press the [F2] key on your keyboard, or double-click in the field.

For example, under the Sale Info tab of the Quote Workbook, the F2 feature could be used for fields such as Date, Ship Via, FOB, Terms, and Due Date.

The feature is also available for columns on the Document Items tab, as well as most fields in the Quote Workbook. Click on any cell in the Document Items tab or whichever field you wish to use the feature in and press the F2 key to display this option list.

Note:The F2 Lookup window can be resized, the last size and location can be remembered for each user for the next time.

Users can create the items in the F2 Lookup by clicking on the new button or by importing them. Clicking on the New button will enable users to create a new item 1 at a time. Importing enables users to add multiple items to the list at once.

To import items, click on the icon. This will import the data that is currently in the Windows Clipboard. Simply copy the list of entries that you want to import into the Windows Clipboard (each entry must be on its own line) and click on the icon.

Duplicates in the clipboard data will be ignored if the entry already exists in the F2 Lookup List. If a user has the access right of CannotCreateF2LookupValue set, then they cannot use this feature. Also the DEL key deletes entries making it easy to delete incorrectly imported entries.

Note:When importing a list of values, you can use // to import the description for the value,   For example USPSPM // United States Priority Mail  will add USPSPM to the value and United States Priority Mail to the description.

Maintaining the Lookup List

On the F2 Lookup window, click on the [New] button to add a new option to the list of options. Click on the [Edit] button to change an existing option item or click on the [Delete] button to remove an existing option item.

Special Codes

The following special codes can be used with the F2 Lookup feature.


The value is a macro field name. This macro can be inserted into the introduction or closing field on the notes tab. When these fields print, the macro field will be replaced with the actual value behind the macro.

For example if your closing text were:

“Your payment terms are DH_CUSTOMTEXT01”, it would be printed as:

“Your payment terms are NET 15”

if the information in the CustomText01 field value was “NET 15”.


Note:See Macro Expressions for more information on macro expressions.

Using the F2 Lookup Text Library

For Notes and Memo fields, the F2lookup lets you store a text library of large chunks of text that are searchable enabling you to easily compose your statements of work, terms, and other text intensive composition.  It  also allows you to Append, Insert, or copy the value from the library




Using the F2 Lookup Feature with Contact-Manager Data

The F2 Lookup list usually contains a list of static text. For example, the ship via field would contain a list of FedEx, UPS, DHL, Airborne, etc.

You can also add a list item that when selected retrieves information from a field in your contact manager. You could store your customer’s preferred shipping method in a field in your contact manager. Then when you selected the item, QuoteWerks would obtain the customer’s preferred shipping method from your contact manager.

Note:Your contact manager must be running for these functions to work.

Listed below are some examples of the items and how they should be formatted. The field name between the ( ) brackets is the information you want to retrieve from the contact manager. See the section on your contact manager for a complete list of the fields that you can retrieve information from.

Function Examples

GoldMine Functions


Act! (versions earlier than 2005) Functions


Act! 2010/2009/2008/2007 Functions


Maximizer Functions


QuoteWerks Functions




Advanced F2 Lookup Features


This new function/macro will...



run the application and then paste the contents of the Windows clipboard into the field that the F2 Lookup was launched from when the application that was launched has terminated.

~RunAppAndReturnClipboard(c:\windows,c:\YourCustomApp.exe, 1)

~RequestDDEValue(TargetAppName$, TargetAppTopic$, DDECommand$)

open a DDE communication channel with the application, send the DDE command string to it, and then paste the results into the field that the F2 Lookup was launched from.

~RequestDDEValue(GoldMine, Data, &Company)

~RequestDDEValue(excel, sheet1, R1C1)