Difference between revisions of "Related Information"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 46: Line 46:
To add an '''Object-Based''' Related Information Section:
To add an '''Object-Based''' Related Information Section:
#Click '''Designer > Objects > {object} > Forms > {form}'''
#Click '''Designer > Objects > {object} > Forms > {form}'''
#Click the '''New Related Information''' link
#Click the ''New Related Information'' link
#Provide the information below
#Provide the information below
#:;Information Source:Object
#Click '''[Save]'''.<br>The name of the Related Information section appears in the Form
#:;Object Name:Name of the Object
 
#:;Title:Title for this information; The page expands to display additional fields.
:::;Information Source:Object
#:;Specify Fields to Link:
:::;Object Name:Name of the Object
#::* Select the first field from the list of those available in the selected object
:::;Title:Title for this information; The page expands to display additional fields.
#::* Select the second field, which contains the ID
:::;Specify Fields to Link:
#::: '''Note:''' If the first field selected was a [[Multi Object Lookup]] field, then '''ID''' is the only valid choice. If any other choice is made, the Related Information section will be empty.
::::* Select the first field from the list of those available in the selected object
#::*Optionally, click the (+) icon to add additional linked fields
::::* Select the second field, which contains the ID
#::*Click the [-] button to remove linked fields
::::: '''Note:''' If the first field selected was a [[Multi Object Lookup]] field, then '''ID''' is the only valid choice. If any other choice is made, the Related Information section will be empty.
#::''Learn more: [[#About the Specify Fields to Link Option|About the Specify Fields to Link Option]]''
::::*Optionally, click the (+) icon to add additional linked fields
#:;Select Fields to Display:Select fields in the list of those Available, and click the right-arrow button to move them to the Selected column; Optionally, click the up- or down-arrow buttons to change the order in which the fields appear
::::*Click the [-] button to remove linked fields
#:;Sort By: Choose a field to determine the sort order of the records, and choose either Descending or Ascending order
::::''Learn more: [[#About the Specify Fields to Link Option|About the Specify Fields to Link Option]]''
#:;Additional Sort By:Optionally, choose a second-level sort
:::;Select Fields to Display:Select fields in the list of those Available, and click the right-arrow button to move them to the Selected column; Optionally, click the up- or down-arrow buttons to change the order in which the fields appear
#::*Choose a field to determine the sort order of the records, and choose either Descending or Ascending order
:::;Sort By: Choose a field to determine the sort order of the records, and choose either Descending or Ascending order
#;Scrolling Window Size: Define the number of rows to display by selecting a Scrolling Window Size; Choose from:
:::;Additional Sort By:Optionally, choose a second-level sort
::::*Choose a field to determine the sort order of the records, and choose either Descending or Ascending order
::;Scrolling Window Size: Define the number of rows to display by selecting a Scrolling Window Size; Choose from:
#::*No Scrolling, Show all Rows
#::*No Scrolling, Show all Rows
#::*5 Records, Scroll Window
#::*5 Records, Scroll Window
Line 70: Line 72:
#::*40 Records, Scroll Window
#::*40 Records, Scroll Window
#::*50 Records, Scroll Window
#::*50 Records, Scroll Window
#Click '''[Save]'''.<br>The name of the Related Information section appears in the Form


===Report-Based Related Information Section===
===Report-Based Related Information Section===

Revision as of 23:09, 22 June 2012

View Data: Workspace > {object} > {record} > Related Information
Customize: Designer > Presentation > Forms > {form} > Related Information

When a record is displayed, this section displays related records--records in other objects that contain a Lookup to the current record. The result is a 360-degree view of the current record that surveys all relevant data.

Viewing Related Records

When viewing a Customer, for example, the Related Information section shows you all Orders the Customer has made:

File:Customer orders.jpg

That view is made possible by the fact that the Orders object has a lookup to Customers:

Lookupexample.png

A Related Information section is automatically created for all objects, although you may choose to hide that information when a record is displayed in a Form. You can also create additional (optional) Related Information Sections.

Learn more: Object Relationships

Default Related Information Section

Default Related Information Sections are created automatically in the platform, and include the following subsections:

As additional Object relationships are added, the related records are displayed in a new section. Each new section uses the Object name as the heading title, and can include the following built-in Actions:

Additional Related Information Sections

Related Information Sections can be added based on Objects or Reports.

Compare to record Sections and Subforms.

Lock-tiny.gif

Users that have the Customize Objects permission can can develop personalized sections in records 

A new Related Information section can be created for any object that is the target of a Lookup. (For most Lookups, related records appear in the default Related Information section. But you can remove them from there before creating a separate section.)

Notepad.png

Note: The Multi Object Lookup is a special kind of Lookup that does not generate a Related Information section automatically. To show records related by that kind of relationship, you create the Related Information section manually, in the object which has become the target of a Multi Object Lookup.

Adding Action Buttons to a Related Information Section

When you create an additional Related Information Section, you can also add Action buttons to those sections.

Learn more: Manage Related Information

Object-Based Related Information Section

To add an Object-Based Related Information Section:

  1. Click Designer > Objects > {object} > Forms > {form}
  2. Click the New Related Information link
  3. Provide the information below
  4. Click [Save].
    The name of the Related Information section appears in the Form
Information Source
Object
Object Name
Name of the Object
Title
Title for this information; The page expands to display additional fields.
Specify Fields to Link
  • Select the first field from the list of those available in the selected object
  • Select the second field, which contains the ID
Note: If the first field selected was a Multi Object Lookup field, then ID is the only valid choice. If any other choice is made, the Related Information section will be empty.
  • Optionally, click the (+) icon to add additional linked fields
  • Click the [-] button to remove linked fields
Learn more: About the Specify Fields to Link Option
Select Fields to Display
Select fields in the list of those Available, and click the right-arrow button to move them to the Selected column; Optionally, click the up- or down-arrow buttons to change the order in which the fields appear
Sort By
Choose a field to determine the sort order of the records, and choose either Descending or Ascending order
Additional Sort By
Optionally, choose a second-level sort
  • Choose a field to determine the sort order of the records, and choose either Descending or Ascending order
Scrolling Window Size
Define the number of rows to display by selecting a Scrolling Window Size; Choose from:
    • No Scrolling, Show all Rows
    • 5 Records, Scroll Window
    • 10 Records, Scroll Window
    • 20 Records, Scroll Window
    • 30 Records, Scroll Window
    • 40 Records, Scroll Window
    • 50 Records, Scroll Window

Report-Based Related Information Section

To add a Report-Based Related Information Section:

  1. Click Designer > Objects > {object} > Forms > {form}
  2. Click the New Related Information link
  3. Provide the information below
  4. Click [Save].
    The name of the Related Information section appears in the Form.
Information Source
View/Report
Report Name
Enter a Report Name, or use the Lookup Lookupicon.gif icon to find a Report name; The page will refresh to display additional information
Title
Enter the Title for this section
Specify Fields to Link
Select the first field from the list of those available in this object selected, and then select the second field, which contains the ID
  • Optionally, click the (+) icon to add additional linked fields
  • Click the [-] button to remove linked fields
Learn more: About the Specify Fields to Link Option
Scrolling Window Size
Define the number of rows to display by selecting a Scrolling Window Size; Choose from:
  • No Scrolling, Show all Rows
  • 5 Records, Scroll Window
  • 10 Records, Scroll Window
  • 20 Records, Scroll Window
  • 30 Records, Scroll Window
  • 40 Records, Scroll Window
  • 50 Records, Scroll Window

Specify a Linking Field for a Join

Use this section to define a "join" between objects. When a join is defined, two objects become related.

Learn more: Define Join Relationships
Considerations
  • Joins are based on a set of field visibility lookups, name fields and fields succeeded by a ‘#’
  • Joins are also possible on the fields which are part of the object Index
  • In the case of multiple fields in the object index, only the first field is considered for joining
  • A total of three joins can be specified

Managing Related Information Sections

Display Settings