Hi Everyone -
I'm integrating HubSpot with Quickbase using Zapier.
When triggered, a new Company record is created just fine. However, I have a data rule in place on the Companies table in Quickbase that typically prevent duplicate Companies from being created. It's not working with this integration and in testing, I was able to create a duplicate Company. Does anyone have suggestions or experience with Zapier integrations and have a suggestion?
This is my Data Rule in table settings for Companies:
If(
IsNull([Record ID#]) and
Size(GetRecords("{6.EX.'" & [Company Name] & "'}")) > 1, "A COMPANY ALREADY EXISTS WITH THIS NAME.")
I commented out the "IsNull" line just to test, and it still created a duplicate record. Sounds like a timing issue but not sure how to correct.
