Skip to main content

Common Features

In any complex application, there will be features whose UI, behavior and often the implementation is shared across the occurrences. Brobench is no different. We have many features which repeat through the app and will go through them here.

Read-only Connections​

You can identify a Connection as Read-only. It is shown as Lock icon in the Connection Menu.

If you try to execute any writable operation like editing records, or executing Apex with insert/update/delete scripts, app the throw below error

To temporarily disable the Read-only flag, Click on the Connection Menu -> Disable Read-only -> <Disable Option> or Edit the connection to turn off the Read-only flag. After the said time, Connection will revert to Read-only again.

Datagrid​

Datagrid is used throughout the app and is designed to be consistent across. Here are some of the Datagrid features you would want to know about.

All most all Data grids allow you to search for a particular row of data using search. Some grids also allow you filter columns. Both usages follow a common thread of behavior as outlined here.

  • Search text must be more than single char
  • Enter any text to filter records. Data is considered matched if any searchable column cell value contains the search term
  • Search term separated by space will be treated multiple sub-terms, which would a data cell if both terms matches that cell. For ex., entering contact role would match OpportunityContactRole, ContactContactRole but not Contact or AccontRole
  • Special chars in the cell values are replaced with space, and each word in the cell value is matched against the search term
  • Enclose in quotes (single or double) to do exact match. For ex., "Task" or 'Task'
  • Start with ^ to do starts with match. For ex., ^Account would match Account and AccountContactRole but not My_Account__c
  • Start with $ to do ends with match. For ex., $Account would match Account and My_Account but not AccountContactRole
  • Enter multiple search terms separated by comma (,) to show matches which matches any of the terms. For ex., entering Contact,Account would match Account, Contact, OpportunityContactRole etc.,

Datagrid Fields Filter​

If Datagrid tend to have a lot of columns, especially like SOQL Datagrid, app enables Filter Fields search input. Search term entered there will be used to find matching fields and show only those columns. The search behavior is same as Data Search so refer to the above section to know how to search

Datagrid Compare Values​

Compare Values feature helps you compare any two cells in Datagrid. If cells you want to compare are adjacent, select those two cells, right-click in the cells, select Compare -> With Each Other to open the compare values dialog.

If cells are not-adjacent, you can copy one of the cell contents into clipboard and compare with the other cell via Compare -> With Clipboard

Datagrid Export Data​

All Data grids allow you to export data. To export Right-click on the datagrid -> Export Other -> <export option>. You can select the appropriate export option as per your needs.

Brobench supports exporting to the following formats.

  • CSV Files
  • Excel Files
  • Google Sheet

Tabs Navigation​

Right-click on a Tab label to show a tab menu which allows you to close tabs and navigate to tabs. This is useful if there are a lot of tabs and some tabs are scrolled left or right out of view. The tabs are shown in the Order they are shown in UI so you can visualize where you are. Current tab in the List is also suffixed with a *

DateTime Values​

All date time values are formatted into your preferred Timezone. By default, the app uses current Connection Salesforce Timezone. You can set your own preferred Timezone in App Menu -> Settings -> Preferences -> Timezone. Reload the page after updating the setting. After that, all date times should be shown in this time zone.

If you hover over a Datetime value, it should show a Popover panel with datetime formatted in various timezones and formats, as shown below.

Ability to set custom formatting for dates, date times and numbers is coming in upcoming releases

Themes​

Brobench supports both light and dark themes and defaults to your system's choice. If you want to override to specific theme, you can select it via App Menu -> Themes -> <choice>

Theme Options​

There are 3 options you can set the app to System, Light or Dark. More may be added in the future.

System​

System option will use whatever theme your system has configured with, either Light or Dark. This mode is the default mode.

Light​

Light option overrides the app theme to Light mode, and it is used even if your system is set to Dark theme.

Dark​

Dark option overrides the app theme to Dark mode, and it is used even if your system is set to Light theme.