SkipField();

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 Salesforce.com 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