← Script library

UI Actions

Show Related Records

Add a form button to open a popup showing related records from another table.

JavaScript
// Client-side code
function showRelatedRecords() {
  var sysId = g_form.getUniqueValue();
  var recordNumber = g_form.getValue('number');

  // Configuration: Define related table and relationship
  var relatedTable = 'sc_task';
  var relationshipField = 'request_item';

  // Build query for related records
  var query = relationshipField + '=' + sysId;

  // Open popup with related list
  var dialogClass = GlideModal ? GlideModal : GlideDialogWindow;
  var dialog = new dialogClass('related_records_dialog');
  dialog.setTitle('Related Tasks for ' + recordNumber);
  dialog.setPreference('table', relatedTable);
  dialog.setPreference('query', query);
  dialog.setPreference('sysparm_view', 'default');

  // Set dialog size
  dialog.setWidth(800);
  dialog.setHeight(600);

  dialog.render();

  // Alternative: Open in new window
  /*
  var url = '/' + relatedTable + '_list.do?sysparm_query=' + query;
  window.open(url, '_blank', 'width=1200,height=800');
  */
}

How to use it

1. Create a new UI Action on your table 2. Set Name to "Show Related Records" 3. Check "Form button" checkbox 4. Check "Client" checkbox 5. Set Order: 150 6. Add condition: !current.isNewRecord() 7. Paste the code above 8. Customize relatedTable and relationshipField variables 9. Optionally create a custom UI Page for better formatting 10. Test by opening a record with related records

Adapt the table names, fields, and conditions to your instance. Test the behavior in a development environment before using it in production.