Getting started with LeadsBridge formulas

Formulas allow you to build algorithms for your Bridge fields. With formulas, you can apply changes to the lead data such as location, translation values, split/explode data, the CAT number format, etc.

The available Formulas can be grouped into different categories:

1. Add/Delete prefix formulas: used to add or remove a prefix before a specific parameter
2. Boolean formulas: they return 0/1 or TRUE/FALSE, depending on the logic you set up
3. Date/Time formulas: used to change the date and time format
4. Phone number formulas: used to remove or add the prefixes or to change the phone number format (+CAT; +C-A-T, etc…)
5. String formulas: they can return a string with specific characteristics. You can split the full name into first and last names or return a string with only numbers and replace characters.
6. Dealer formulas: return the maximum and the minimum price of available cars and the style of the first available car in the BlackBook service using the UVC for the search.
7. Text formulas: those functions help you to sanitize emoji and characters in your source text, return a string only with alpha-numeric characters and spaces; implode or explode the text, etc…
8. Utils formulas: you can return a random IP, a country code, a US State, set the default value to the source text if it is populated with the empty value,…

Formula How-To Guides

• How to split the Full Name into First and Last Name
• How to change the date/time format
• How to add the country prefix to the phone number
• How to delete the phone number prefix
• How to set a default value to a field
• How to replace a text within a field
• How to split a text string
• How to remove undesired characters
• Value Lookup from CSV

Related Articles

• Comprehensive Fields Mapping Guide
• Fields Mapping - How to map multiple fields in one
• Fields Mapping - Adding spaces between fields

• Formulas.jpg40 KB