Choosing cell types

Multiple types of cells are available to use in Company Planner boards. Before creating a board, you need to determine which types of cells it will contain, based on the functionality you want to build into the board.

The basic cell types are Grid, Map, RouteMap, LoadInformation, ReportViewer, SQLGrid, WebBrowser, BranchTree, BrokerageAssets, and TripAudit.

The TripAudit cell is a custom cell type. Do not use it unless advised to do so by your Trimble Support representative.

Cell types have specific events and actions. Some cells have options. The options you can set are dependent on the cell type. All cell types support Subscriptions.

For details on the options supported for specific cell types, see Setting cell options.

Grid

The Grid cell displays grid-based data. Any scroll view can be used as the source for the data in a Grid cell.

These cells use established board views to pull a set of pre-defined columns. For more information on board views, see Defining and managing board views.

Events/Actions associated with the Grid cell

Events Actions

RowCellClicked

LocateDataRow

GroupRowSelected

FilterOnParentKey

RowClicked

FilterDataCustom

DragDrop

RefreshData

CustomMenuCommand

AssignCarrierACS, OpenTripFolder/ OpenTripFolderNew, OpenOrderEntry/ OpenOrderEntryNew. DispatchSendToTruck, DispatchDontSendToTruck, PostLoadToFBI, AddCarrierBid, AssignAssets, OpenCarrierAdvance

ACSSaved

AssignCarrier, AssignDriver, AssignDriver2, AssignTractor, AssignTrailer, AssignTrailer2

CheckCallAdded

AddCheckCall

Grid cells support different types of functionality. When you create a board, you can select the functions you want in this type of cell. Grid cell options appear on these tabs:

  • Grid Options

  • Mapping

  • Menu Commands

Grid cells support menu commands.

You use them to define custom menu commands or add row buttons that trigger specific actions. Menu commands are used with Subscriptions. For each command you add, you can select the Show as a Button checkbox. When it is selected, the command appears as a button in each row. When the checkbox is cleared, the command is added to the right-click shortcut menu.

Map

The Map cell provides visualization of data from other cells using only latitude and longitude data. It does not geocode or add map information. The current map providers are ALK, Google, and Esri.

Events/Actions associated with Map cells

Events Actions

AfterCellControlLoaded

UpdateMapData

MapMarkerClicked

MapFindPoint

ToggleMapLayer

Map cells support different types of functionality. When you create a board, you can select the functions you want in this type of cell.

Map cells do not support menu commands.

RouteMap

The RouteMap cell displays a map of the selected leg and the last check call location.

Events/Actions associated with RouteMap cells

Events Actions

AfterCellControlLoaded

RefreshData

MapLeg

RouteMap cells use the same options as Map cells.

RouteMap cells do not support menu commands.

LoadInformation

The LoadInformation cell displays order information about a particular load, such as stops, assignments, pay details, and carrier offers. It accepts the order number as a parameter.

Events/Actions associated with LoadInformation cells

Events Actions

AfterCellControlUpdated

FilterData

RefreshCheckCalls

RefreshCarrierBids

LoadInformation cells do not support menu commands.

ReportViewer

The ReportViewer cell displays an SSRS report and can passed parameters.

Actions associated with ReportViewer cells

  • FilterData

  • RefreshData

ReportViewer cells support different types of functionality. When you create a board, you can select the functionality you want available in this type of cell.

ReportViewer cells do not support menu commands.

SQLGrid

The SQLGrid cell displays the result of a raw SQL command. The retrieved data can be filtered.

Events/Actions associated with SQLGrid cells

Events Actions

AfterCellControlUpdated

RefreshData

RowActivated

OpenTripFolder/OpenTripFolderNew

RowCellClicked

OpenOrderEntry/OpenOrderEntryNew

RowClicked

FilterData

CustomMenuCommand

FilterData

SQLGrid cells support different types of functionality. When you create a board, you can select the functionality you want available in this type of cell.

SQLGrid cells support menu commands.

WebBrowser

The WebBrowser cell displays a web browser, using URL parameters that can be set to filter data.

Actions associated with WebBrowser cells

  • FilterData

  • RefreshData

WebBrowser cells support different types of functionality. When you create a board, you can select the functions you want in this type of cell.

WebBrowser cells do not support menu commands.

BranchTree

The BranchTree cell displays executing terminals and booking terminals, as defined in the branches table. It takes into consideration the branches being assigned to the currently logged in user. This allows the user to have a subset of what they originally manage.

Events/Actions associated with the BranchTree cell

Events Actions

AfterCellControlLoaded

SetBrokerBranch

RowClicked

SetBrokerBranch

RowCellClicked

SetBrokerBranch

BranchTree cells do not support menu commands.

BranchTree cells support options for specifying a date range for data retrieval.

Tree options supported by BranchTree cells

Option Functionality

Start Date

Specify the start date for the retrieved data.

Options are:

  • Genesis
    Select the checkbox to use 01/01/50 00:00 (January 1, 1950) as the start date.

  • Days Back
    Enter the number of days back from the current date.

End Date

Specify the end date for the retrieved data.

Options are:

  • Apocalypse
    Select the checkbox to use 12/31/49 23:59 (December 31, 2049) as the end date.

  • Days Back
    Enter the number of days forward from the current date.

BrokerageAssets

The BrokerageAssets cell is used for Brokerage setup. When given an order number, leg header number, origin, destination, and search radius, the cell returns a set of carriers qualified to be assigned the supplied order. These carriers are the carriers most likely to be able to cover the load.

Events/Actions associated with BrokerageAssets cells

Events Actions

AfterCellControlLoaded

FilterData

AfterCellControlUpdated

AddCarrierBid

DragDrop

AddCarrierBid

AddCarrierBidRequested

AddCarrierBid

CarrierBidAdded

AddCarrierBid

BrokerageAsset cells do not support additional functionality options.