Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday : SmartConnect Update Blank Data


Today’s Tech Tuesday discusses the Update Blank Data feature. This feature can be used from the SmartConnect Mapping window.

This can be used to determine when updating records whether blank data should over-write fields. If Update Blank Data is checked, a blank field mapped to a destination field will cause the destination data store to be updated with the blank value. If Update Blank Data is unchecked, blank fields mapped to destination fields will not cause destination data source information to be over-written with blank values.

By default, Microsoft eConnect and CRM do not send blank data values to the stored procedures so there is no mechanism to remove a blank value once the data has been set. If you need the data to be blank, SmartConnect gives you that option with the Update Blank Data checkbox.

4 Comments

  1. Manny on November 18, 2016 at 5:50 pm

    Does this work with CRM Option sets?

  2. Maryna on August 20, 2020 at 7:13 pm

    This option doesn’t seem to work for us. Blank values are not updated in Destination whether the Update Blank Data is checked or not.

  3. Alex Tayurskiy on February 5, 2021 at 11:17 am

    CRM connector doesn’t clear picklist values

Leave a Comment





RECENT POSTS


2021 Q4 Promotions
Connect with us at Directions EMEA 2021 in Milan!
eOne at Summit North America 2021
Employee Spotlight: Megan Tripp, Business Development Representative
eOne is now compatible with Microsoft Dynamics GP October 2021 Release

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.