Complex User Symbolics use programs called subroutines. Below is a list of subroutines and practical examples of how you could use them. The most popular User Symbolics are at the top of the table, the less frequently used are at the bottom.
Please contact us on the customer support portal for advice when creating User Symbolics.
Symbolic Name |
Vernon CMS field types |
What does it do? |
Example |
---|---|---|---|
"Explodes" a hierarchy. It allows you to separate your authority field hierarchy onto a new line. You can also choose which part of the hierarchy will be displayed. |
Reporting on an object's location will display: Shelf 1/Room 32/ Ground Floor/ Storage/Vernon Systems Museum
The Explode User Symbolic allows you to change the display to: Shelf 1 Room 32 Ground Floor Storage Vernon Systems Museum
You can choose when the hierarchy should stop. For example, instead of the full hierarchy of Shelf 1 to Vernon Systems Museum, you could display just the terms two levels higher: Shelf 1 Room 32 Ground Floor
|
||
Displays a specific part of an authority term's hierarchy. |
You may only want to display the country an object was made in, not the city or suburb. So instead of seeing: Morningside/Auckland/New Zealand You would just see: New Zealand
|
||
SUBROUTINE > EXTRACT.AMV |
"Extracts" data from a specific row in a table. |
You could take only the first row of data from a table.
Another example is to take only data with a certain authority field. For example, you could report on the Other ID table and only see the rows with the Other ID Type "Old Accession Number".
|
|
SUBROUTINE > MULTI.FIELDS |
All fields. |
Joins fields together into a block of text. |
This field is especially helpful when your collection is online. You could combine the fields Brief Description and Credit Line to make a web description.
|
SUBROUTINE > TWO.FIELDS |
All fields. |
Reports on one field, but if there is no information in that field it reports on a different field. |
If your collection has social history and natural history collection items, you likely use different fields. You could report on Name/Title field (social history objects) and if there was no information in that field, this user symbolic will instead report on the classification field (natural history specimens).
|
SUBROUTINE > TRUNCATE |
All fields. |
Shortens or "truncates" your chosen field(s) to a certain number of characters.
|
You could restrict your Brief Description in reports to 100 characters. |
SUBROUTINE > FIXED.LITERAL |
No Vernon CMS fields. |
Adds a phrase or statement. |
You could create a default statement for your institution's credit line. This way all records would have the same information.
|
SUBROUTINE > PERSON.NAME |
Person Name and Identifying fields. |
Customises the display of the Person or Corporation name. |
The person's title, firstname, lastname and life years could be displayed. Miss Georgia Flowers 1942-2001 |
SUBROUTINE > PROD.PRI.PERSON.WORK |
Primary Maker field and Object One Line Display. |
Lists all of the other objects that has your object's artist as the primary maker. It will list the objects by the fields chosen in your one line display.
|
Your institution has 4 Pablo Picasso paintings. If your report contained a Pablo Picasso painting, all the other works by Picasso in your collection will also be listed. |
SUBROUTINE > COSTS |
Tasks and Their Costs fields. |
Displays the total cost for a certain task or cost type in general or within a task. |
You could see the total amount that has been spent on Photography tasks, or on exhibition purchases.
|
SUBROUTINE > OB.ME |
Measurement fields. |
Displays a row of data with a specific measurement type, part number or both.
|
You could report only the dimensions of an object, ignoring other measurements like diameter or weight. |
ACT > CURRENT.ACT |
Management Activity field. |
Finds and displays the current Activity for an Object record.
This symbolic can also display Activity files with specific information in them or with a General Flag.
|
Usually, when you report on exhibitions objects were in, it shows the entire exhibition history. This symbolic will show just the current exhibition. |
ACT > LAST.ACT |
Management Activity field. |
Displays the last Activity for an Object record. Last means the record with the closing date most recently passed.
|
You could see the last Outward Loan an Object had been on. |
ACT > CURRENT.ACT.BY.STATUS |
Management Activity field.
|
Finds and displays all activities with a certain Procedural Status.
|
You could see all completed Condition Reports. |
ACT > OB.CURR.LOC |
Location field for an Activity's object(s). |
Displays the current location of all the objects linked to an Activity.
|
See all the current locations of your proposed objects while planning a new exhibition. |
ACT > TOTAL.VALUES |
Valuation fields. |
Provides the total value of all the Object records linked to the Activity record.
|
You could add up the acquisition price for all of the objects. |
ACT > EXH |
Exhibition Concept and Related Exhibition Venue. |
Displays all the Exhibition Concepts linked to an Object's or Activity's Related Exhibition Venue. |
A painting has 12 Related Exhibition Venues. However, the object has only been displayed in 2 Exhibition Concepts. This symbolic provides a list of all the Venues and the associated Exhibition Concept. For example, the painting's Related Exhibition Venues 1-10 were part of the "Vernon Systems unveiled" exhibition, and the other 2 Related Exhibition Venues were part of the "portraiture" exhibition.
|
Extract only the narrower terms of a specific term. |
You may have multiple classification systems (taxonomic or nomenclature). This symbolic will let you show just the taxonomic classification, or just the nomenclature classification. You can then display this on your website as two different fields.
|
||
All fields. |
Evaluates Visual Basic Script (VBScript) expressions. If no other symbolic fits your needs, this symbolic will.
You can learn more about Visual Basic Script on the Microsoft Developer Network (MSDN). |
Here are just a few examples of what you could achieve: - Create conditions, e.g. if there is a next higher term it will be displayed in brackets, if not, nothing will be displayed. - Use Javascript to create expressions - Join multiple fields together with a carriage return between each section of data - Perform calculations based on dates or numeric fields.
|
|
Location fields. |
Calculates how long an object has been in a particular location or had a particular location reason or had either option within a set time frame. |
You could calculate the time that an object has been on display by using this symbolic. You use the duration symbolic on just the exhibition Location Reasons, e.g. Temporary Exhibition, Permanent Exhibition.
|