Page tree
Skip to end of metadata
Go to start of metadata

Linked Fields

Linked Fields are a special Data Type that automatically pulls the values in the fields from one table, called "source table", into another table, called "target table". Linked Fields help avoid duplication and ensure that Records dynamically reflect any changes that occurred in other places within the infrastructure. For example, a Case table would include Linked Fields from a source table, typically the User table, which provide access to the submitter's full name, telephone number, email address etc. from the values in the User record.

Linked Fields can be configured to automatically update when the value in the source table changes or to save the old value. In either case, they retain the display attributes, permissions, and size restrictions of the source fields. You can copy or link fields from another record in the current table, another table within the current KnowledgeBase or even an external database. Fields that have been linked from another table are marked as "Link to" in the data type column at Setup > Tables > select Table to edit > Fields.

Several different kinds of Linked fields appear at the bottom of the "New" drop-down on the Fields tab in the Table wizard at Setup > Tables > select Table to edit > Fields.

  • Link to single field. Links to one field in another table. Seldom used because you will often find you want to add more fields later and have to redo it.
  • Link to selected fields. The most common way to pull in fields from a single record in another table, for example user information in a case or asset. Can also be used to pull in multiple fields from records as part of a multi-to-multi relationship. In this case it is displayed as an embedded table rather than as separate fields.
  • Link to all fields. Pulls all fields in and if new fields are added to source table they are automatically added to the set of target fields.
  • Single field from multiple tables. Used for the Assigned To fields to allow an issue to be assigned to a Team or an individual and for other situations in which a single field should display values from more than one table.
  • Related table. Shows one of the above relationships from the other direction. For example, when the Assigned To field is used to assign each Issue to a user, a Related table shows all the Issues that were assigned to her.

Agiloft
CONTENTS
  • No labels