User Symbolics

You can calculate and manipulate data in Vernon CMS with User Symbolics. You can use this powerful functionality to change how information is displayed in Reporting, List Manager, and Vernon Browser.

How User Symbolics can help you

User Symbolics (or user-created symbolic fields) perform an immediate calculation on your data to do a variety of tasks. You can create an unlimited number of these symbolic or calculated fields in any of the major files in Vernon.

You can create User Symbolics to do the following tasks:

Pull information from related fields into a file to make it easier to report on.
Extract specific rows of information from one table of a record.
Perform basic maths or calculations.
Generate static data that’s the same for every record in a report.
Reformat information for presentation in another system, including our Vernon Browser online collection module.

You can then select your User Symbolic fields in Reporting and List Manager. These fields are always at the bottom of the Available Fields list.

You’ll need to have supervisor access in Vernon CMS to create User Symbolics. We almost always help our clients set them up. Email support@vernonsystems.com with your enquiry.

Simple and complex User Symbolics

Simple User Symbolics let you show information from other fields that are not available normally.

For example, you may need to include an artist's website in an object label. This information is held in the Web Address field in the Person file and is not available when reporting on Object records. A simple User Symbolic can take this data from the Person file and make it available in the Object file.

Complex User Symbolics manipulate and calculate your data in a variety of ways. They use programs called subroutines to perform specific functions.

Find out more

Video

Explainer