This Forum Post will show you how to change the colour and size of the Map Pins based on a Person’s Job Title. The same concept could also be applied to show you the Industry of an Organisation, or ...
- Welcome to the Knowledge Base
- Introduction
- Training
- Getting Started
- Preferences
- Activities
- Cases
- Forecasts & Quotas
- Importing Data
- Leads
-
Marketing
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Products
- Mailshots
- Upload Library
- Templates
- Event Management
- Compliance Records
-
Spotler Integration
- What is Spotler?
- Navigating your Spotler homepage
- GatorMail
-
GatorLeads / Web Insights
- Tracking Code
- Setting up the Plugin
- Viewing Web Insights Data on your Form Layouts
- Domain Names and Online Activities
- Reporting incorrect Leads created through Web Insights
- Reporting on Web Insights data
- Using UTM Values
- Why aren’t Online Activities being created in the database?
- Why is GatorLeads recording online activities in a foreign language?
- GatorSurvey
- GatorWorkflow
- GatorPopup
- Opportunities
-
Integrations
- Mapping
- Electronic Signing Tools
- Creditsafe Integration
-
Zapier
- Introduction to Zapier
- Available Triggers and Actions
- Linking your Workbooks Account to Zapier
-
Setting up Zaps
- Posted Invoices to Xero Invoices
- Xero payments to Workbooks Tasks
- New Case to Google Drive folder
- New Case to Basecamp Project
- New Workbooks Case to JIRA Ticket
- Jira Issue to new Case
- 123FormBuilder Form Entry to Case
- Eventbrite Attendee to Sales Lead and Task
- Facebook Ad Leads to Sales Leads
- Wufoo Form Entry to Sales Lead
- Posted Credit Note to Task
- QuickBooks Online
- Survey Monkey responses to Tasks
- Multistep Zaps
-
Email Integrations
- Email Dropbox
- Workbooks Exchange Server Sync
- Workbooks Outlook Connector
- RevenueGrid Intelligence and Engage
-
Event & Webinar Integration Tools
- GoToWebinar
- ON24
- Microsoft Office
-
Outreach
- Installation
- Outreach Authentication
- Sync People to Outreach Prospects
- Sync Organisations to Outreach Accounts
- Sync Workbooks Opportunities to Outreach
- Sync Tasks/Activities from Workbooks to Outreach
- Sync Outreach Sequences to Workbooks
- Sync Outreach Sequence States to Workbooks
- Sync Outreach Sequence Step Numbers to Workbooks
- Sync Prospects/Accounts/Opportunities from Outreach to Workbooks
- Sync Outreach Tasks/Calls/Meetings to Workbooks
- Scribe/Workbooks Connector
- RingCentral
- Auditing
- Comments
- People & Organisations
- Projects
-
Reporting
- Introduction to Reporting
- Using Reports
- Charts
- Exporting Reports
- Advanced Reporting
- Report Snapshots
- Dashboards
-
Transaction Documents
-
Introduction to Transaction Documents
- Displaying & Adding Transaction Documents
- Copying Transaction Documents
- Transaction Documents Fields Help
- Transaction Documents Line Items Help
- Printing & Sending Transaction Documents
- Managing Transaction Document Currencies
- Managing Transaction Document Statuses
- Setting a Blank Default Currency on Transaction Documents
- Credit Notes
- Customer Orders
- Invoices
- Quotations
- Supplier Orders
- Contract Management
- Sagelink
-
Introduction to Transaction Documents
- Auditing
-
Configuration
- Introduction to System Administration
- Users & Security
- Preferences
- Database
- Accounting
- Email & Integration
-
Customisation
- Creating & Modifying Picklists
- Theme
-
Record Types
- Creating Custom Fields
- Report-based Custom Fields
- Linked Fields & Reference Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- Custom Records
- Automation
- PDF Configuration
- Contact Support
- Releases & Roadmap
Changing the size/colour of Map Pins
It is possible within the Report to change the colour and size of the Map Pins with custom criteria which is applied through a calculated column, like other CSS Styling.
Colour coding Map Pins is made of two parts:
- -wb-map-pin-color - this defines the colour of the pin.
- -wb-map-pin-scale - this defines the size of the pin.
The colours are defined through Hexadecimal values, a few examples include:
- Red: #c12e28
- Yellow: #edc20b
- Blue: #3f7ec1
- Green: #38a582
- Black: #1a1e25
- White: #ffffff
Note: For a complete guide on Hexadecimal colours we would recommend referring to guide such as W3 Schools.
The Scale of the Pin can be set anywhere between 0.5 and 3
For example, to define a pin to be blue and standard sized, you use:
"-wb-map-pin-color:#3f7ec1; -wb-map-pin-scale:1"
For a pin to be green and extra large, you use:
"-wb-map-pin-color:#38a582; -wb-map-pin-scale:3"
The easiest way to set up the colour coding that depends on something like an Organisations type (Head Office or Subsidiary) or a Person's Job Role, will be through a CASE statement such as below:
CASE WHEN person_job_role = 'Director' THEN '-wb-map-pin-color:#38a582; -wb-map-pin-scale:1.2;' WHEN person_job_role = 'Manager' THEN '-wb-map-pin-color:#c12e28;-wb-map-pin-scale:1;' ELSE '-wb-map-pin-color:#3f7ec1;-wb-map-pin-scale:0.8;' END
The above translates to;
- When the Person’s job title is Director then the Map Pin will be Green and Large
- When the Person’s job title is Manager then the Map Pin will be Red and Regular sized.
- Otherwise the pin will be blue and small.
To then apply this formatting, open your Map Position report column, open the Style tab, and change the Cell conditional style to 'Calculated conditional styling', then select your calculated column.
You can find a worked example of changing the colour and size of the Map Pin based on a Person’s Job Title in our Forum.