Forum Discussion

ToddMolino's avatar
ToddMolino
Qrew Cadet
6 months ago

HubSpot to Quickbase via Zapier

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. 

2 Replies

  • ToddMolino's avatar
    ToddMolino
    Qrew Cadet
    6 months ago

    Thanks for your feedback Mark. I went ahead and grabbed the Company ID in HubSpot and brought that over to Qbase in the Zap, then made that one unique instead. It was a better fit for this client. Thank again and Happy Hanukkah!