View your data
Display objects, records, tasks, files, and more in organized tables
Create saved views
Save personalized table views with specific columns, filters, and sorting
Export data
Export table data to CSV, Geopackage, Geodatabase, and more formats
Share on your public website
Make table views accessible to residents for transparency and information sharing
Working with tables
Use tables to manage key workflows and gain insights from your data. Tables are flexible and can be customized to match your unique workflows, which means you and your team can easily:- Track properties in flood zones with outstanding inspections to quickly identify properties that need follow-up
- Monitor inspection status and follow up on incomplete items to stay on top of pending work and close the loop
- Find Elevation Certificates and permits by property or date to locate critical documents when you need them
- Share filtered property data with residents through public views to promote transparency and keep your community informed
Types of tables
Forerunner provides tables for different types of data:| Type | Description |
|---|---|
| Objects | View and manage objects in your community, including properties, custom objects like stormwater systems, and other geospatial datasets. Each object can have records, files, and associated data. |
| Records | Track records organized by category such as inspections, permits, mailings, SI/SD tracking, code cases, complaints, and many more. |
| Workflows | Manage and track workflow configurations and automation rules for your team’s processes. |
| Tasks | Monitor task assignments, track progress, and manage workflows across your team. |
| Files | Browse and manage document uploads, Elevation Certificates, and other files attached to your data. Image metadata columns (timestamp, location, orientation) are available for uploaded photos. |
Key features
Tables in Forerunner are interactive and easy to use:- Navigate to the table you want to view (Objects, Tasks, Files, etc.)
- Select a saved view from the dropdown, or use the default view
- Filter the data to show only what you need
- Sort by any column to organize your data
- Customize columns by adding, removing, or reordering them
- Export your filtered data when you need to share or analyze it elsewhere
- Save your configuration as a new view for future use
Table header controls
Every table includes a header with powerful controls:- Saved views dropdown - Switch between different views
- Filter button - Add and manage filters (shows count badge when active)
- Columns button - Add or remove columns from your view
- Row count - See the total number of items in your filtered view
- View on map - Open the current table data on the map (when available)
- Export data - Download your data in various formats
- Add new - Create new records (context-dependent)
Column interactions
Each column header provides options to:- Sort ascending or descending
- Hide the column
- Reorder by dragging
- Resize by dragging the column border
- Auto-fit width by double-clicking the resize handle
Row selection
When available, you can:- Select individual rows using checkboxes
- Select all items for bulk operations
- Perform actions on multiple items at once