Perform math in a delivery value

LeadConduit allows you to perform math on values received into your flow and send the outcome to a delivery field, in any delivery step. This is useful when you need

This article shows an example and gives a reference for you to learn more.

Let’s say that you work for a lender, and you are receiving leads for borrowers on homes; your flow fields include “mortgage.loan.amount”, i.e., the loan amount requested, and “property.value”, but your leads need to include the percentage of that property value (property.value) that is requested to be loaned. Let’s also say your CRM is set up to receive this value in the the Loan to Value or “LTV” field, computed as the following mathematical formula:

mortgage.loan.amount/property.value * 100

To send the computed value in your CRM delivery step:

• Edit the flow, click on the CRM delivery step, and pick “Edit Field Mappings”
• Create a new mapping by clicking “+” on any line and insert the right hand side value: the field received by your CRM, “LTV”
• In a separate text editor on your laptop, prepare a line with the formula above to paste into the mappings all at once. Here is how our example formula would look, surrounded by curly brackets and naming flow fields with “lead.” prepended
  {{ math "(lead.mortgage.loan.amount / lead.property.value) * 100 " }}
• Cut and paste the formula all at once into the left hand value of your mapping:

• Click OK and save your flow.

Many more mathematical functions are available in LeadConduit, and you can even do rudimentary formatting, averaging and rounding of values in your flow, before sending. For more information, see our API documentation.

• Screenshot_2024-06-25_at_12.10.01 PM.png200 KB