Office - Custom Fields

Table of Contents


Overview

  • Custom Fields are designed as a club specific solution to gathering additional information on particular instances of the Office system.  Specifically, Custom Fields can be created to gather additional information on Members, Employees, and Vendors.  The Office system has the capability to create various types of Custom Fields including Choice, Date, Number, Text, Yes/No, and Group.

Required Permissions

  • Membership

  • Add/Edit/Delete Custom Fields


Accessing the Tool

Please see instructions below to access Custom Fields within each available module.

Membership

To access Custom Fields specific to Members:

  1. Select Membership across the top toolbar.

  2. Choose Custom Fields.

Employees

To access Custom Fields specific to Employees:

  1. Select Employees across the top toolbar.

  2. Choose Custom Fields.

Vendors

To access Custom Fields specific to Vendors:

  1. Select Accounts Payable across the top toolbar.

  2. Choose Custom Fields.

Custom Fields Grid

A Custom Fields Grid will launch, specific to the selected module, when either of these options are selected.  These Grids can be filtered, and exported to excel in the same manner as any Grid within the Office system.

Custom Fields Categories

Please Note: Selecting a Custom Fields Category is required during the setup of a Custom Field.  

This allows the user to classify their Custom Fields for easy reporting.

To create a Custom Fields Category:

  1. Navigate to System across the top toolbar and select Custom Fields Categories.

  2. Then, perform either of the following to launch the Custom Fields Categories setup screen:

    • Click the New icon on the toolbar.

    • Right Click anywhere on the Custom Fields Categories Grid and select New.

  3. Give the new Custom Fields Category a name and Save & Close. Web Visibility is only applicable to clients still using CSWeb.

Create a New Custom Field

To create a new Custom Field:

  1. Navigate to the corresponding Custom Fields Grid, specific to the module the user is entering the new Custom Field.

  2. Then, perform either of the following to launch the Custom Fields setup screen:

    • Click the New icon on the toolbar.

    • Right Click anywhere on the Custom Fields Grid and select New.

  3. The Custom Fields setup screen will launch.  Select the Type of Custom Field that is being entered.

Custom Fields Types

Please see below instructions on each Type of Custom Field.

Choice

A Choice Custom Field creates a selection option within the specific instance of the Office system the Custom Field is created.

  1. Name - label that will display for the Custom Field.

  2. Category - select the Custom Fields Category.

  3. Description - additional information about the Custom Field.

  4. Display Order - used to put the Custom Field in order on the Custom Field screen within the specific module the Custom Field was created.

  5. Type - used to determine if the field will accept more than one selection.

    • MultiSelect- more than one can be selected.  When selecting multiple instances, please be sure to hold CTRL on the keyboard.

    • SingleSelect- only one can be selected.

  6. Required - will make the Custom Field a required field when entering a new member.

  7. Add Selections - the selection options are added and edited using the New, Edit and Delete icons at the bottom of the screen.

  8. Be sure to Save & Close the Custom Field when complete.

The new Custom Field will display on the Custom Field Tab within the specific module the Custom Field was created.

Date

Date Custom Fields are used to store additional information in a date format.

  1. Name - label that will display for the Custom Field.

  2. Category - select the Custom Fields Category.

  3. Description - additional information about the Custom Field.

  4. Format - used to set the specific format for the Custom Field.

  5. Date Only - will only accept date entry

  6. Time Only - will only accept time entry

  7. Date and Time - will accept date and time entry

  8.  Default - used to auto fill the Custom Field, but can be overwritten.

    • Today - new vendor will default to creation day for this field.

    • Custom - will default with entry in Custom field below.

  9. Custom - When default is set to Custom, set the custom date to be entered. Date format is month, day, year (XX/XX/XXXX).

  10. Display Order - used to put Custom Fields in order on the Custom Field screen within the specific module the Custom Field was created.

  11. Required - makes the Custom Field a required field when entering a new member.

  12. Web Privileges - Only applicable if client still uses CSWeb.

    Be sure to Save & Close the Custom Field when complete.

The new Custom Field will display on the Custom Field Tab within the specific module the Custom Field was created.

Number

Number Custom Fields are used to store additional numeric data.

  1. Name - label that will display for the Custom Field.

  2. Category - select the Custom Fields Category.

  3. Description - additional information about the Custom Field.

  4. Display Order - used to put Custom Fields in order on the Custom Field screen within the specific module the Custom Field was created.

  5. Max - maximum value, example: entry of 150 means that the field will only accept an entry of 150 or lower

  6. Min - minimum value, example: entry of 1 means that the field will only accept an entry of 1 or higher

  7. Decimals - number of decimal places that can be entered for the numeric value.  Must be between 0 and 10.

  8. Default - used to auto fill the Custom Field, but can be overwritten.

  9. Required - will make the Custom Field a required field when entering a new member.

  10. Web Privileges - Only applicable if client still uses CSWeb.

    • Be sure to Save & Close the Custom Field when complete.

The new Custom Field will display on the Custom Field Tab within the specific module the Custom Field was created.

Text

Text Custom Fields are used to store additional information in simple text format.

  1. Name - label that will display for the Custom Field.

  2. Category - select the Custom Fields Category.

  3. Description - additional information about the Custom Field.

  4. Display Order - used to put Custom Fields in order on the Custom Field screen within the specific module the Custom Field was created.

  5. MaxChars - limits the number of characters that can be used in the Custom Field

  6. Default - used to auto fill the Custom Field, but can be overwritten.

  7. Multiline - used to allow multiple lines for entry.

  8. Required - will make the Custom Field a required field when entering a new member.

  9. Web Privileges - Only applicable if client still uses CSWeb.

    • Be sure to Save & Close the Custom Field when complete.

The new Custom Field will display on the Custom Field Tab within the specific module the Custom Field was created.

Yes/No

Used for storing Yes or No information. Creates a checkbox for the user to check for yes or leave unchecked for no.

  1. Name - label that will display for the Custom Field.

  2. Category - select the Custom Fields Category.

  3. Description - additional information about the Custom Field.

  4. Display Order - used to put Custom Fields in order on the Custom Field screen within the specific module the Custom Field was created.

  5. Default - used to auto fill the Custom Field, but can be overwritten.

  6. Web Privileges - Only applicable if client still uses CSWeb.

    • Be sure to Save & Close the Custom Field when complete.

The new Custom Field will display on the Custom Field Tab within the specific module the Custom Field was created.

Group

This Type is used to group several types of Custom Fields into one section within the specific module the Custom Field is entered.

  1. Name - label that will display for the Custom Field.

  2. Category - select the Custom Fields Category.

  3. Description - additional information about the Custom Field.

  4. Display Order - used to put Custom Fields in order on the Custom Field screen within the specific module the Custom Field was created.

  5. Group Type - used to determine if only one group can be added per instance or if more than one group can be added

  6. Single - only one group of these Custom Fields will be in the specific module the Custom Field is entered.

  7. Multiple - initially one group will display in the specific module the Custom Field is entered, but an Add button will be available to add as many as needed to keep all of the information for that particular instance.

  8. Required - will make the Custom Field a required field when entering a new member.

  9. Add Selections - the selection options are added and edited using the New, Edit and Delete icons at the bottom of the screen.

To add a new selection:

  1. Click New with the Down Arrow

  2. Select the Custom Field Type

  3. Fill in the entry screen based on the information provided on the different types above. 

  4. Save and Close

Web Privileges - Only applicable if client still uses CSWeb.

Be sure to Save & Close the Custom Field when complete.

The new Custom Field will display on the Custom Field Tab within the specific module the Custom Field was created.

Custom Fields Reporting

Reporting on Custom Fields is most efficient when using Grids.  Once a Custom Field is created, the Custom Field becomes an available column option within the specific module the Custom Field is created.

For example, assume a club created a Membership Custom Field titled, Age Joined.  The primary goal of this Custom Field is to track the age of their members when they joined the club.  

To create a report displaying this information:

  1. Navigate to the Mange Members Grid.

  2. Right click on the grid and select Customize Columns.

  3. The newly added Custom Field is now an available column option. Double click or drag and drop the column.

  4. The column is now on the grid and can be filtered and exported to Excel the same as any other column.


Best Practices

  • Make sure to always save and close when finished editing the custom field. 

  • It is required to select a Custom Fields Category during the setup of a Custom Field. 

FAQs