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
- Desktop Environment
- Preferences
- Activities
- Cases
- Forecasts & Quotas
- Importing Data
- Leads
-
Marketing
- Introduction to Marketing
- Mailing Lists
- Mailshots
- Marketing Campaigns
- Products
- Upload Library
- Templates
-
Workbooks 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?
- Using HubSpot with Workbooks
- Event Management
- GatorMail Integration
- Opportunities
- Creditsafe Integration
- People & Organisations
- Electronic Signing Tools
- Reporting
- Dashboards
- Compliance Record
- Data Enrichment
- Transaction Documents
- Mapping
-
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
- Survey Monkey responses to Tasks
- Multistep Zaps
- Outlook Connector
- Exchange Server Sync
- Workbooks Mobile Client
- Auditing
-
Configuration
- Introduction to System Administration
- Users & Security
- Database
- Accounting
- Email & Integration
- Customisation
- Automation
- PDF Configuration
- Contact Support
- Releases & Roadmap
- Workbooks Glossary
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:#000000 - this defines the colour of the pin.
- -wb-map-pin-scale:0.5 - 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
The easiest way to set up the colour coding 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.
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.