Formula will omit sending the field to the destination system


Example 1:

##BlankValue(DBLookup('DESTDS', 'User', 'Alias', "Salesperson", 'Id'), SkipField())

Will send the Id of the User with alias as in the Salesperson field only when this user exists in the destination, otherwise it will skip the field and not send it to the destination at all (leaving the value that is already set or letting the destination generate a default value if it is a new record). This could be used with MS Dynamics NAV Customer as source and Account as destination.

Example 2:


        ##IF(EQUALS("Type",2), DBLOOKUP('DESTDS','product','productnumber',"No.",'productid'), SkipField())

        will send the productid corresponding to item "No." to the destination for lines with Type = 2 and it will skip the field for all other lines. This could be used

       with MS Dynamics NAV invoice lines as source and MS Dynamics CRM invoicedetail as destination.


  1. Getting Started
  2. Documentation
  3. HowTo
  4. Standard Integrations


Service News can now be found on our Product Updates Blog 


Remember to Subscribe to our Product Updates Blog to receive updates and product news.





Wheeled by Wagn v. 1.9.1