Setting Run Condition to Prevent Blank Field Write Back in HubSpot Create Contact

Irvin G. · 2026-01-13T14:16:18.451Z

Hello, if anyone could help please. I am trying to set run condition for Hubspot create contact. But I could not make the condition work where the blank field will not write back. On sample output all rows should be yes except row#3.

Setting Run Condition to Prevent Blank Field Write Back in HubSpot Create Contact | Clay

11 comments

· Sorted by Oldest

Clay Support
APP
·
·
Looking at your formula, the issue is that you want to run when totalFound is 0 AND the lookup object exists (not blank). Try this formula instead:
{{Lookup object}} && {{Lookup object}}.totalFound == 0
This will:
Return "Yes" when the lookup object exists AND totalFound equals 0 (like row 1)
Return "No" when the lookup object is missing/blank (like rows 2-3)
The key is checking that the lookup object field itself exists before checking its totalFound property. [1] [2]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help refining your run condition or have any other questions, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?
Muhammad S.
·
·
incase there is no work email how do you plan to do the lookup? Irvin G.
Clay Support
APP
·
·
You're right - if there's no work email, the HubSpot lookup won't work properly since it needs an email to search for contacts.
You'd want to modify your conditional run to check for both conditions:
{{Work Email}} && {{Lookup object}} && {{Lookup object}}.totalFound == 0
This ensures the HubSpot create contact only runs when:
A work email exists
The lookup was successful
No existing contact was found (totalFound = 0)
For rows without work emails, the action simply won't run, which is what you want. [1] [2]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with setting up your run conditions or have other questions, I’m here to assist. Would you like to share more about what you’re trying to resolve or understand?
Irvin G.
·
·
I have followed {{Lookup object}} && {{Lookup object}}.totalFound == 0 then somehow it ignored the blank with no email Muhammad S.
Clay Support
APP
·
·
You need to add a check for the work email field too. Try this formula:
{{Work Email}} && {{Lookup object}} && {{Lookup object}}.totalFound == 0
This ensures all three conditions are met:
Work email exists (not blank)
Lookup object exists
No existing contact found (totalFound = 0)
The && operator requires ALL conditions to be true, so if there's no work email, the whole condition fails and the action won't run. [1] Make sure to test with empty fields to handle edge cases properly. [2]
Clay Support
APP
·
·
Is that what you were looking for?
1
Clay Support
APP
·
·
If you still need help with your run condition or have any other questions, I’m here to assist. Would you like to provide more details about what you’re trying to resolve or understand?

Clay Support
APP
·
·
Looking at your formula, the issue is that you want to run when totalFound is 0 AND the lookup object exists (not blank). Try this formula instead:
{{Lookup object}} && {{Lookup object}}.totalFound == 0
This will:
Return "Yes" when the lookup object exists AND totalFound equals 0 (like row 1)
Return "No" when the lookup object is missing/blank (like rows 2-3)
The key is checking that the lookup object field itself exists before checking its totalFound property. [1] [2]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help refining your run condition or have any other questions, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?
Muhammad S.
·
·
incase there is no work email how do you plan to do the lookup? Irvin G.
Clay Support
APP
·
·
You're right - if there's no work email, the HubSpot lookup won't work properly since it needs an email to search for contacts.
You'd want to modify your conditional run to check for both conditions:
{{Work Email}} && {{Lookup object}} && {{Lookup object}}.totalFound == 0
This ensures the HubSpot create contact only runs when:
A work email exists
The lookup was successful
No existing contact was found (totalFound = 0)
For rows without work emails, the action simply won't run, which is what you want. [1] [2]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with setting up your run conditions or have other questions, I’m here to assist. Would you like to share more about what you’re trying to resolve or understand?
Irvin G.
·
·
I have followed {{Lookup object}} && {{Lookup object}}.totalFound == 0 then somehow it ignored the blank with no email Muhammad S.
Clay Support
APP
·
·
You need to add a check for the work email field too. Try this formula:
{{Work Email}} && {{Lookup object}} && {{Lookup object}}.totalFound == 0
This ensures all three conditions are met:
Work email exists (not blank)
Lookup object exists
No existing contact found (totalFound = 0)
The && operator requires ALL conditions to be true, so if there's no work email, the whole condition fails and the action won't run. [1] Make sure to test with empty fields to handle edge cases properly. [2]
Clay Support
APP
·
·
Is that what you were looking for?
1
Clay Support
APP
·
·
If you still need help with your run condition or have any other questions, I’m here to assist. Would you like to provide more details about what you’re trying to resolve or understand?