HomeTraining Manual Archives-Worldox GX4:: Professional - AdministratorEditing Profile Cards & Code Look Up Table CodesEdit Codes in Code Look Up Tables

3.2. Edit Codes in Code Look Up Tables

Introduction to Code Look Up Tables

Understanding code lookup tables is fundamental to learning how to save and search for documents in Worldox.

What is a Code Look Up Table

A code look up table is a pre-defined list of items to choose from when saving a searching for documents.  Using values in code lookup tables ensures that everyone is filing consistently because for the most part, Worldox fields require that you select a value from the lookup table to file a document.

Viewing Code Tables

There are three ways to view a code look up table:

Option #1:  To view the field code lookup table, simply click on the label next to the field you'd like to view.

Option #2:  To view the field code look up table, select the drop down arrow on the right hand side of the field, and choose "Browse <Selected> Table"

Option #3:  To view the field code look up table, place your cursor in the field, and select F2 on your keyboard.

The Details

Each table contains both field codes and descriptions. 

Here is an example of a field code lookup table:

Some of the fields in the code lookup tables are linked to others.  For example, in the example below, the Doc Type table is linked to the Category table:

Another example is when Investment Accounts are linked to client names.  The values in the Acct No field are linked to the client code.

Worldox also allows you to flag entries as inactive or active.  Note in the illustration below, ALBEJO01 has a slightly different icon than ADAMGR1.  The red circle on the icon indicates that the client code is inactive.

You can still search for and save documents to inactive values, this is simply a visual indicator to you that that value is inactive.

Introduction to Editing Values

On occasion, you may need to edit the values in the field code lookup table. 

In the field code lookup table, you will see an "Edit" button.  The illustration below is the field code lookup table for the AcctNo field.

You will begin by highlighting the entry you wish to edit, and then selecting the "Edit" button.

This will open the Field > Edit window:

Important:  Remember that Worldox uses the field code to create an underlying folder structure in which the documents are stored.  Therefore, editing field codes requires a bit more than simply editing a field description.  Please follow the instructions for Editing a Code explicitly to ensure that your documents are easily searchable!

Edit a Code

You may need to edit a field code in Worldox.  For example, you may not know an account number when you first begin to save documents for that account, or a client may get married or divorced and you want to have their client code properly reflect their name change.


This isn't as simple as editing the client code field in Worldox.  Remember, Worldox uses the field code to create an underlying folder structure in which the documents are stored.  Here's an example of the Worldox Document Repository's underlying folder structure:

You can see that the files on the right are filed in the directory structure notated on the left.

When you change the code in the code lookup table, you're changing where documents will be filed in the future - but not where they currently exist. 

To take things one step further, if you edit the code lookup table but do not move the existing documents accordingly, you will not be able to easily search for those documents by their code because it will not longer exist in the lookup table.

Trumpet refers to these files "Orphaned".  Now that you understand the implications of editing a code in Worldox incorrectly, let's discuss how you can do it properly.

Changing a code in Worldox is a three-step process:

  1. Search for documents already in the system
  2. Edit the code
  3. Edit the profile of the documents filed to Worldox

How to Edit a Code that Appears in a Single Cabinet

Let's get started:

  • Ensure that the code is only in one cabinet (if editing a client code, see "How to Edit a Code that Appears in Multiple Cabinets", below)
  • Perform a search for all documents assigned to the code you wish to change
  • Select Ctrl+A on your keyboard to select all the documents
  • Select the Edit Profile button
  • Select the field in which you wish to edit the code
  • Highlight the code you wish to edit and change the value
  • Ensure the remainder of the fields in the Edit Profile dialog contain the asterisk
  • Select "OK" to edit the profile of the documents to appear under the new code

How to Edit a Code that Appears in Multiple Cabinets

Let's get started:

  • First, perform a search for all documents assigned to the code you wish to change.  Be sure to search in *all* cabinets in which the code appears (e.g., if editing a client code, search across all cabinets with a Client field)
  • In the Worldox search results screen, add the "Cabinet Name" column to your column headers (right-click in the header area and select "Cabinet Name")
  • Single-click on the Cabinet Name column to sort by cabinet
  • Highlight the last file in the list for the first cabinet
  • Right-click on the checkbox and choose "Tag > Above Highlight". This will check all files for this first cabinet in the list
  • Select the Edit Profile button
  • The Edit Profile window will appear
  • Make sure to change all fields to asterisks (*) except the code that is being edited.  If the fields list a specific value, such as "MULTIPLE" rather than "*", it must be changed to an asterisk
  • Open the Field Code Lookup Table for the value you wish to change (e.g. Client, or AcctNo)
  • From the lookup table, highlight the code you wish to change and select the "Edit" button:
  • Edit the code
  • Select "OK"
  • In the Field Code Lookup Table, select your newly edited code
  • Click "OK" in the Edit Profile window
  • Depending on how many files were selected, it may take several seconds or minutes for Worldox to re-profile the files
  • Now, back in the Worldox Search Results list, you will no longer see those documents
  • Select all the documents in the next cabinet
  • Select the Edit Profile button
  • Select the newly edited code from the field code lookup table
  • Lather, rinse, repeat until all documents in all cabinets are re-profiled under the new code

This page was: Helpful | Not Helpful

© 2022 Trumpet, Inc., All Rights Reserved