Real People, 24/7

Expression Field Mapping Guide

Let's say you are trying to match the NetSuite customer Entity ID to the Zendesk organization name in Step 3 Field Mapping.

To use NetSuite EntityID instead of the company name, you must map "EntityID" to "Organization: Name." 

In Step 3, you can enable our expression field mapping feature, which can combine fields, in this use case, EntityID and company name. 

mceclip0.png

Next, if this route is chosen, map the following expression to the Organization name using Customer mapping in Step 3.

mceclip2.png

Field Mapping Expression: record.EntityID + ' ' + record.CompanyName

mceclip1.png

That's it! You can now Reset Sync Process and get back to automating your data.

Another use case could be around:

Use days to segment your data using expression field mapping areas or filtering boxes in Step 5.

To filter on x months ago, convert to the number of days and use this method below.

for 1 month ago
to_date("30 days ago")for 24 months ago
to_date("712 days ago")for 60 months ago
to_date("21360 days ago")

Many more expressions can be made by using the JEXL scripting library to evaluate the expression. 

Our product/platform team can also evaluate the expression if you send it to us once you have tried it.

Need Some Help with a Human Touch?

Check out the options below for contacting our support team and finding the answers you need to help you with your SyncApps integrations. 

Help Center & Email is 24/7 to support@cazoomi.com | Live Chat & Phone is scheduled 

FAQs 

Check out these Help Desk articles for answers to frequently asked questions.

Get Started | Login Issues | Pricing

Have more questions? Submit a request

Comments