James F.

David J. you could share your feedback about this here too if you want.

I've submitted this as a feature request. Right now, the only option is complex conditional logic. If trying to enrich or update 5+ fields in HubSpot, it gets ridiculous. Having the ability to just "Only update unpopulated fields" would solve 99% of these issues, without compromising any flexibility.

The current workaround for this is to ensure all the fields from HubSpot go into a column, all the enriched versions go into a column, and then all of the consolidated values need to have a column. Each consolidation column needs complex conditional logic. Retaining these fields across multiple tables (due to column limits) makes it super tedious and needlessly complex to manage. A simple toggle like the "Ignore blank values" one would allow me to enrich without any worry at all (a value is better than no value every time) and create logic only when needed.

I would like clarity on how this works. If I am updating fields that already have existing values in HubSpot, do they get overwritten or not?

My understanding of that toggle was that it was to prevent overwriting fields if the data in the variable was blank. So it wouldn't update a field with a blank value. Is that correct?