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, ReportViewer, SQLGrid, and WebBrowser.
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 Creating and managing 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.
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.