000029864 - RSA Archer: Sub-form field will not display as a column within Related Record table

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000029864
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: 5.5.2
IssueSub-form fields can be added to a Related Record field, however when viewing the record this column will not display within the table.
In this example, the Comment field of a Questionnaire's Comments Sub-Form is being added as a column for the Related Record table:
Add Comments Field

When the record is viewed, the Comment field is omitted from the Related Records table:
Related Records Results
CauseSub-form fields will be omitted from Related Record columns due to the fact that there could be multiple instances of the field within a single record. This makes displaying the field within the table unfeasible as the number of potential results can be variable.
WorkaroundA separate field outside of the Sub-form should be used in place of the Sub-form field. This will limit the field to a single entry and will allow Archer to use this as a column within the Related Record table.