The Default When NULL feature in SyncSmart enables users to set a default value for specific fields when no value is provided in HubSpot. This ensures data consistency and reduces manual data entry by automatically populating empty fields with predefined values.

Key Features

  • Configurable via SyncSmart UI: Users can easily enable and configure the Default When NULL functionality within the SyncSmart interface.

  • Applies to Specific Field Types: This feature supports text, dropdown, and number fields.

  • Ensures Data Consistency: Prevents empty values by applying a default where necessary.

  • HubSpot to NetSuite Sync Only: The functionality is only available when syncing records from HubSpot to NetSuite.

How It Works

  1. Access the SyncSmart UI: Navigate to the SyncSmart settings and locate the Default When NULL configuration option.

  2. Select the Target Field: Choose the HubSpot field that should have a default value when empty.

  1. Define the Default Value: Enter the default text, select a dropdown option, or specify a numeric value.

  2. Save and Apply: Once configured, SyncSmart will automatically apply the default value when syncing records from HubSpot to NetSuite.

Example Use Case

A customer wants to ensure that every new company created in HubSpot is assigned a subsidiary in NetSuite. If the subsidiary field is empty in HubSpot, the Default When NULL feature can be used to assign a predefined subsidiary value, ensuring seamless data integration.

Limitations

  • This feature is not supported for NetSuite to HubSpot syncing.

  • Only applicable to text, dropdown, and number fields.

  • The default value must be manually configured within the SyncSmart UI.

Conclusion

The Default When NULL feature enhances the reliability of HubSpot to NetSuite data synchronization by ensuring that critical fields never remain empty. By leveraging this feature, businesses can maintain data integrity and streamline their integration processes.