Download PDF

On this page…
Set Up Project Fields
Add, Edit, or Delete Fields

Set Up Project Fields

Text and Text Area Fields | Number Fields | Alphanumeric Fields | Date Fields | List Fields | Linked Fields | Linked Work Fields | Boolean (Checkbox) Fields | Artstor-Specific Fields | Default Values | Description | Position NumberRead-Only Fields | Required Fields

Download a PDF with default field definitions and mappings.

About Project Fields

Your project’s fields are where you will input metadata to describe your items and make them searchable in end-user environments. Field types range from simple free-text entry to date fields that restrict values to a calendar date. There are several different types to choose from and you will need to decide which field type is best suited for the metadata you wish to catalog.  Each field type acts differently in how it sorts data, how the data can be searched, and how the data can be edited.   There are nine Field Types you can choose from when building your project’s field list in the Admin Tools:

  • Text
  • Text Area
  • Number
  • Alphanumeric
  • Date
  • List
  • Linked
  • Linked Work
  • Boolean (Checkbox)

Each field type can be rendered as:

  • Editable or Read-only
  • Required

Important: The field type cannot be changed if there is existing data in the field. To delete field data, use Excel to export data by following these instructions: Change a Field Type for a Field with Existing Data Using Excel.

Text and Text Area Fields Text and text area fields both hold the same amount of characters and act similarly. Although, the text area field will display as a larger box suitable for larger text entries, whereas a text field will display as a single-lined box in your cataloging form. To set up a text or text area field, select the text or text area field type when adding a new field.

Number Fields As expected, the number field type will only accept numeric characters as a value. When searching or filtering data in the project, enter numeric values using (>) greater than, (<) less than, or (=) equal to. To set up a number field, select the number field type when adding a new field.

Alphanumeric Fields Alphanumeric fields support alphabetic and numeric characters, such as accession numbers. To set up an alphanumeric field, select the alphanumeric field type when adding a new field.

Note: When changing an existing field to the alphanumeric field type, the data will be hidden in the cataloging environment. Instead, create a new alphanumeric field and delete the old field that is no longer in use.

Date Fields Date fields provide a calendar selection (before, after, and on) for filtering and searching data. All entries in the data field must be formatted as mm/dd/yyyy. When importing dates from Excel, some formatting issues may occur. If you expect to use Excel for importing data to a project, we recommend using text fields instead for non-formatted date entries. To set up a date field, select the date field type when adding a new field.

List Fields Administrators can create controlled lists of terms to ensure standardized and consistent data. Lists can be setup as simple single-field lists of terms, or they can have multiple fields to qualify the term’s definition, its source, etc. It’s even possible to nest lists within a list.

Lists are added to your project so that users may catalog with the list terms. You can link multiple controlled lists to a single project field, or you can link a single list to a single project field. Any user with access to the project can use the list terms when cataloging items, but users who are provisioned to manage the list can add terms and edit local terms. You can easily add a list to a field that is either a list type for single lists, or linked field type for multiple lists. For more information on how to manage controlled lists, including the setup of a list field, see Lists.

Linked Fields Linked fields connect a text field to a controlled authority, such as the Getty Art and Architecture Thesaurus or the Library of Congress. The Getty’s vocabularies Art and Architecture Thesaurus (AAT), Thesaurus of Geographic Names (TGN), and Union List of Artist Names (ULAN) are fully integrated within the Cataloging Tools. Other authorities can be linked as well using the website’s URL. When using a provided project template as your metadata schema, suggested resources are already linked to use at your preference. The following list identifies the standard suggestions for specific linked fields in each template.

  • Standard:
    • Creator: Shared Shelf Names
    • Culture: Art & Architecture Thesaurus
    • Work Type: Art & Architecture Thesaurus
    • Material: Art & Architecture Thesaurus
    • Style/Period: Art & Architecture Thesaurus
    • Subject: Thesaurus of Geographic Names, Art and Architecture Thesaurus, Library of Congress Authorities
    • Location: Thesaurus of Geographic Names
    • Creation/Discovery Site: Thesaurus of Geographic Names
    • Repository: Thesaurus of Geographic Names
  • Dublin Core:
    • Creator: Shared Shelf Names
    • Subject: Thesaurus of Geographic Names, Art & Architecture Thesaurus, Library of Congress Authorities
  • Archivision:
    • Agent_Display: Shared Shelf Names
    • Work_WorktypeDisplay: Art & Architecture Thesaurus
    • Work_SubjectDisplay: Thesaurus of Geographic Names

For more information on how to catalog linked authorities, see Names & Getty Vocabularies.

To set up a linked field:

  1. Select the linked field type when adding a new field. Input a field label.
  2. Check the sources you want to link to this field. Select more sources to see a full list of sources available. Optionally set a default value, description, and position.
  3. Select Create.

Linked Work Fields When using a work project, linked work fields are setup to create the work-to-item relationship. Contact forumsupport@jstor.org to learn more.

Boolean (Checkbox) Fields Boolean fields are established as a checkbox with a value of True when checked or a value of False when unchecked. Values can also be left empty as a null value (N/A), in which the box will appear with a blue square. To set up a boolean (checkbox) field, select the boolean (checkbox) field type when adding a new field.

Artstor-Specific Fields There are four specific fields that, when mapped for publishing to Artstor, make it possible for your users to sort and filter search results: Artstor Classification, Country, Earliest Date, and Latest Date. The country and classification fields are controlled lists of values that should not be modified, because the controlled list of values must strictly match the values that exist in Artstor in order to support filtered searches. Earliest and latest date fields allow numeric values to be entered by catalogers. For more information on how Artstor-specific fields are cataloged, see Field Types: Artstor-Specific Fields. When mapping any of these specific fields in Forum Admin, you will want to follow the example pictured below. Note that the fields, as mapped, are set by default to be “Displayable = true,” but they actually do not display in Artstor, regardless of this setting. These fields are meant to work entirely behind the scenes to aid the discovery of content.

Map Artstor facet fields

Default Values Administrators can configure default values to auto-populate certain fields when new records are created. Fields will be populated with default values when creating new records through:

  • using the Options menu;
  • uploading a new media file; and
  • creating a new record though an Excel spreadsheet import with the SSID entered as NEW and the other fields left blank

Default values may be overwritten or modified in the record and with new data in Excel spreadsheet imports, unless the field is read-only in the cataloging form.

To set a default value:

  1. Navigate to the Fields tab.
  2. If the field does not exist, add a new field.
  3. Input a default value.
    • Text and Text Area fields allow for free-text values.
    • Number fields allow for numeric values.
    • Date field allows for a calendar value in the form of MM/DD/YYYY.
    • List field allows for a default value from the selected list.
      • You must set up the list before the field and its default value can be selected, but you can add the term to the list at a later time.
      • If you add the default value before the term is added to the list, the value and the term are case-sensitive and must match.
      • Once the term is added to the list, the default value in the Administrator settings will update to the term’s ID (e.g. [[LIST ####]]).
      • Note that it is important you establish the default value for the field in the project field. Lists allow for establishing default values in the term fields, but this will only apply to the list and not the project (meaning all terms will default to one term by mistake).
    • Linked field allows for a default value of text plus the Getty term ID in brackets.
      • For ULAN, enter [[SSN ####]] to link the authority (e.g. Pablo Picasso [[SSN 500009666]])
      • For AAT, enter [[AAT ####]] to link the authority (e.g. paintings (visual works) [[AAT 300033618]])
      • For TGN, enter [[TGN ####]] to link the authority (e.g. Spain [[TGN 1000095]])
    • Boolean Checkbox field allows for a default value of None, True, or False.
  4. Create your new field or Save your changes to an existing field.
    • New records added after the default value had been established will begin receiving the value upon creation. Existing records cannot retroactively receive the default value, it must be added manually through single or bulk edits.

Description When setting up a new or editing an existing field, there is a text area box in the dialog window to enter a description. This area is a designated space to enter defining language for the field’s data information, meaning you can add instructions for what type of information to enter and how to enter it. The text would then appear when the cataloger hovers their cursor over the field label in the cataloging form. The description can be edited under the Fields tab to be used across all cataloging forms, or you can edit the description in each cataloging form to provide specific instructions to specific catalogers.

An example of the descriptive hover text using the Creator field: Name, brief biographical information, and roles (if necessary) of the named creator or creators in the design and production of the work, presented in a syntax suitable for display to the end-user.

The Description field is not just limited to text, you may add clickable URLs to the instructions for more information. For example, using the Creator field, apply HTML coding to create a hyperlink and use the added code to open the link in a new browser tab: Name, brief biographical information, and roles (if necessary) of the named creator or creators in the design and production of the work, presented in a syntax suitable for display to the end-user. Follow Dublin Core format standards: <a href=”http://dublincore.org/documents/name-representation/” target=”_blank”>http://dublincore.org/documents/name-representation/</a>. The hover text in the cataloging screen will display with a hyperlink, and the additional coding will open the page in a new browser tab.View a field description. Important:

  • Since field descriptions can be unique to a cataloging form, if you edit the description in an existing field under the Fields tab, check that those changes have applied to the Cataloging Forms tab also if you want the field descriptions to be the same.

Position Another step when setting up a new or editing an existing field is to designate the position number. The position number relates to the placement of the field in the item panel’s column view, which can be re-arranged, but it is more importantly related to the default column order of the Excel template. If you or your catalogers anticipate working in Excel, creating a hierarchy or structure to the order of fields in this template can be defined through the position number. Leaving that field blank during new field set-up will prompt the system to apply a number starting at 1000, translating to the columns at the far end of the item panel and Excel template.

Read-Only Fields Fields by default are editable. However, administrators can set up read-only fields in the cataloging form so that different fields or entire forms may be rendered as read-only for different catalogers. Read-only fields appear gray in the cataloging form and cannot be edited. When a cataloger is uploading Excel spreadsheets to create new or modify existing records, any fields that are read-only in their cataloging forms will not accept new or modified data.

To set a field as read-only:

  1. Navigate to the Cataloging Forms tab.
  2. If a cataloging form does not already exist, create a new one and add the appropriate fields.
  3. Select the field intended as read-only and select Edit.
  4. In the edit window, uncheck the box for Editable, this will render the field as read-only.
  5. Save your changes.

Make field read only

Required Fields Required fields are established in the publishing target, because it prevents items with fields that do not contain data from being published. The default for a field is to not be required, so a manual change is necessary when a desired field should be required. For more information on cataloging required fields, see Field Types: Required Fields.

To set a field as required for publishing:

  1. Navigate to the Targets tab.
  2. Select the target name from the list or create a new target.
  3. Select Map Project FieldsEnsure the field you want to require is mapped.
  4. Check the box under the Required column and Save your changes.

Set required field

Add, Edit, or Delete Fields

To add a new field:

  1. Navigate to the Fields tab.
  2. Select the Add Field at the top of the field list.
  3. Enter a field label, select a field type (do not use the Linked Work field), apply an optional default value, and enter a description of the field. You may leave the position blank to let the system auto-populate a number, or enter the preferred placement. The position number affects the column position in the item panel and Excel template. If creating a List or Linked field, you will need to connect the field with the relevant lists and sources.
  4. Select Create. Your new field should appear in the list of fields and can now be added to your cataloging forms.

Create new field

To edit an existing field:

  1. Select the field from your field list, then select the Edit, OR double-click the field to open the edit window.
  2. Apply the edits to the field as desired. Note that you cannot edit a field type if data has already been cataloged in that field without removing the data first (see Change a Field Type For a Field with Existing Data Using Excel).
  3. Select Save, and refresh the edit tab in Forum to see the changes take effect.

To delete a field:

  1. Select the field from your field list.
  2. Select the trash can icon and then select Delete.

Important: