Knowledgebase articles
- Welcome to the Knowledge Base
- Introduction
- Training
- Getting Started
- Preferences
- Activities
- Cases
- Importing Data
- Leads
- Marketing
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Products
- Mailshots
- Upload Library
- Templates
- Event Management
- Compliance Records
- Force24
- 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
- Projects
- 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
- 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
- Reporting
- Introduction to Reporting
- Using Reports
- Introduction to 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
- Configuration
- Introduction to System Administration
- Users & Security
- 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
- Sign In Customisation
- Automation
- Contact Support
- Releases & Roadmap
Applying Search filters in Calculated Columns
It is possible to replicate all of the search filters from a Landing Page within a Report Calculated Column. This article will provide some examples of the formats you will need to follow in order to replicate searches you may perform on a landing page.
The Calculated Columns all use an IF Statement to output a True of False response which can then be filtered on within the Report with a calculated criteria. In some of these calculations you will notice that the percentage (%) symbol is used – this is a wild card operator meaning that anything can take its place in the field.
Starts with
If a Person’s name starts with ‘abc’ output True otherwise False.
IF(name LIKE ‘abc%’, ‘True’,’False’)
Contains
If a Person’s name contains ‘abc’ output True otherwise False.
IF(name LIKE ‘%abc%’, ‘True’, ‘False’)
Does not start with
If a Person’s name does not starts with ‘abc’ output True otherwise False.
IF(name NOT LIKE ‘abc%’, ‘True’, ‘False’)
Or
IF(name LIKE ‘abc%’, ‘False’, ‘True’)
Does not contain
If a Person’s name does not contains ‘abc’ output True otherwise False.
IF(name NOT LIKE ‘%abc%’, ‘True’, ‘False’)
Or
IF(name LIKE ‘%abc%’, ‘False’, ‘True’)
Equals
If a Person’s town is equal to London output True otherwise False
IF(town = ‘London’, ‘True’, ‘False’)
Does not equal
If a Person’s town is not London output True otherwise False
IF(town != ‘London’, ‘True’, ‘False’)
NOTE – Like with Landing Page Filters we would recommend using an equals calculation rather than a starts with or contains calculation as this will return Report results much faster.
Is not blank
If a Person’s town is not blank output True otherwise False
IF(town IS NOT NULL AND town != ‘’, ‘True’, ‘False’)
Is blank
If a Person’s town is blank output True otherwise False
IF(town IS NULL OR town = ‘’, ‘True’, ‘False’)
Is on or after
If a Created at date is on or after 1st January 2018 output True otherwise False.
IF(created_at >= ‘2018-01-01’, ‘True’, ’False’)
Is after
If a Created at date is after 1st January 2018 output True otherwise False.
IF(created_at > ‘2018-01-01’, ‘True’, ’False’)
Is before
If a Created at date is before 1st January 2018 output True otherwise False.
IF(created_at < ‘2018-01-01’, ‘True’ ,’False’)
Is on or before
If a Created at date is on or before 1st January 2018 output True otherwise False.
IF(created_at <= ‘2018-01-01’, ‘True’, ’False’)