Define Custom Fields | Considerations | Add Custom Field | Layout | Display Types | Display When | Parent Field | Reporting | Exceptions | Resources

This is where you can create and maintain custom fields that are used throughout the system based on your requirements.

NOTE: Custom Fields that you make here do not automatically show up in reporting, nor are they available in our non-modifiable standard reports.

Define Custom Fields

To start creating Custom Fields, go to Menu > Admin/Manager > System Setup > Custom Fields.

Workamajig provides you with the ability to add customized input and reporting fields to key parts of the system. Utilizing this functionality will allow you to more precisely tailor the system to the business needs of your organization and the needs of your client and vendors.

You are able to create custom fields that will be available in the following areas: Employee, Company, Contact, Project, Campaign, Retainer, Conversation, and Opportunity.

Considerations

Plan it out

In some cases, you can re-purpose an existing field that is not being used instead of creating a new custom field. For example, if you want to report on a Clients PO number, then we suggest you use the Client Project Number field that is already available on projects. As you can relabel the fields on invoice layouts and reports and use the field, as is.

If you do have many fields you want to add, think of what you want to show and why (as you may not be able to delete the fields later). Then explore the options of how the fields are populated and displayed that best suit your needs.

Character Limits

Plan accordingly as there are limits on the number of characters that can be used in each of the available fields, this includes spaces.

Description = 300
Hint = 300
User Text Input Field = 8000

Naming Conventions

In the reports and views that allow custom fields to be included, you will see these custom fields called out with a "CF_" in front of the field name. For example CF_Contact_MyCustomFieldName.

Also, note that you do not want to use any special characters (ie. !@#$%^&*) in the field name or caption, as this can cause issues with reports.

Deleting Custom Fields

In most cases, you will not be able to delete a custom field once it has been used at least once, where a record populated that field with data.

If you are unable to delete the field, then we suggest you ensure it's removed from the Available Fields, and then uncheck Active from the setup of the field.

Add A Custom Field

Go to Menu > Admin/Manager > System Setup > Custom Fields.

Choose your area of interest.

For example, this is what you might see if you click on Opportunity Fields.

Click the plus sign next to Available fields to add your first custom field.

You will then be prompted to add the field details.

Click Save when done.

NOTE: You can edit everything but the Field Name after the initial save.

Layout

Each section has its own layout. This determines what users will see when populating these fields in the system.

Drag and Drop the fields you want to use and place them in the order of your choosing.

Display Types

Numeric

A text box containing only numeric values.

NOTE: Only numbers, plus sign, negative sign, and a decimal point can be entered. The system will display any needed commas.

Date

A text box containing a date value.

Clicking on the calendar icon will open a date picker.

Text

A single-line text box containing that allows all alphanumeric values.

Will not expand into more rows.

Pressing enter will Save.

Text Area

A multiple-line text box that allows all alphanumeric values.

Also allows the user to format the text that is entered. Such as Bold, Size, and Color.

Will expand if more rows are needed.

Pressing enter will go to the next line.

Single Checkbox

Creates a single option to check or not check. Think of it as a Yes or No only option.

Multiple Checkbox

Allows the user to choose any options from a list of check-boxes.

If required, then at least one checkbox must be chosen.

Radio Button

Allows the user to choose one option from a list of multiple options.

Dropdown

A select box containing a list of pre-determined values.

If required, then an option must be selected in order to Save.

The Display Type of Drop-down now has an added conditional formatting that can be used called Parent Field. See the Parent Field section of this guide for more on this aspect.

Separator Text

Allows you to create a visual break in the form and be able to label the line as well.

Tab

Example

Tabs allow you to separate your custom fields into categories that the users can then click onto and fill out related fields without seeing all fields.

In order for Tabs to function properly, the first field in your layout must be a Tab field.

NOTE: If you have required fields under multiple tabs, keep in mind that the rules of the fields being required still apply before you can Save.

Display Only

Simply adds the display-only text in the form of the caption and text.

Select List

This is similar to the drop-down menu, but you can have the user pick and choose options from the list.

Display When

This option allows you to have one or more fields appear based on the user input data of another field. You can only do one level of result fields, meaning you cannot create a drop-down list that then opens more drop-down lists and so on. So get creative with your use of this feature.

The order of your selected fields is very important. You will want to make sure you put the results field(s) below the selection field, or else you may get odd-looking results when the fields appear.

How is a basic example of this looks to your users:

Click an option that is related to a Display When action.

Then the field appears based on the prior condition being met.

Parent Field

This allows you to create conditional values that appear within a Dropdown selection based on the selection of the parent field. This is different than Display When, as that shows/hides fields from being inputted altogether.

NOTE: This function only works with the Dropdown Display Type.

For example.

Setup the "to be" parent field with the initial set of options. In this case Web, Print, and Misc.

Then set up the "results" field that will display the available Dropdown options based on what is inputted into the Parent Field.

Options with no :: in them, will always show in the results field, regardless of the value selected in the parent field. In this example, "Other" is that option.

Here is the above setup example in action.

If no selection is chosen in the Parent Field, then only the Options with no :: appear.

If Web is chosen from the Parent Field, then the Options starting with "Web::" appear. Plus any Options with no "::" before them.

If Print is chosen from the Parent Field, then the Options starting with "Print::" appear. Plus any Options with no "::" before them.

If Misc is chosen from the Parent Field, then only the Options with no "::" before them appear in the Results Field selection.

Reporting

Custom Fields appear as "CF_FieldName" in reports. You can edit the Caption of the Column so its looks cleaner in the report itself.

NOTE: Only Active custom fields will appear in the list of fields you can add. However, fields added prior to them being made inactive will still be part of the report.

If the report is not displaying any information, this usually means improper data was entered in a Date or Numeric field. To check, simply change the field type to Text. Run the report to find the errant data. You can then change the field type back to Date or Numeric. If you are not using the fields for calculation purposes in Excel, you may want to keep the field as Text to prevent this error.

Exceptions

Employee Custom Fields: Since many use these fields for sensitive staff-based information, these fields are not available to add to views. These fields are only visible within the employee record or via the custom report datasets: Time Detail Data (with Employee custom fields) and Employee Data

Resources

Reports Overview