You are here: Chapter 7: Configuration and Administration > Workspace Administration > Fields > Using Dynamic SQL Field Mapper

Using Dynamic SQL Field Mapper

Once enabled, FootPrints automatically populates the fields that you mapped when the lookup field is populated, if that option was selected during configuration. You can also manually initiate or clear a lookup by using the two icons to the right of the field: Lookup and Clear.

To use this feature manually:

  1. The lookup key field must first be populated (either manually by the user, or dynamically from another field mapper lookup or the LDAP or SQL Address Book). You can enter the exact data, or you can enter a partial string (for example, Smi) to see a list of matches.
  2. Click the Lookup icon or press Enter.
  3. If a match is found, the data is populated in the associated fields.
  4. If there are multiple matches, a pop-up window is displayed with a list of matches. Select the desired match and the data is populated in the associated fields.

Note

Only text-based lookup fields return partial matches.  Due to limitations in some databases, if the lookup field is numeric, an exact match must be found.

  1. If the matched data is not what you want, click Clear, and the data fields will be cleared.

Notes on Using the Dynamic Field Mapper