Joshfi

Thanks LuisArturo (Clay), yeah, I was hoping to identify it directly via Clay as the 'nth' (first) Deal. I ended up using a custom code workflow on the HubSpot side to identify the first deal then set some properties, so now I have exactly what you're referring to 👍

Yeah, that doesn't work. Even if I put a limit of 1, it returns 'Found 500 associations' (but there are 14782). Here is the table: https://app.clay.com/workspaces/356860/workbooks/wb_PEN9fXH2E4SE/tables/t_avTonERYNDPk/views/gv_A9iTPtGRJR3U

What if the company has 15,000+ Deals? It looks like the max is 20 associated records? It only needs to retrieve and return the properties for one (the first) Deal.

Ah! Thanks Bo (Clay), much appreciated! Makes complete sense now. As you shared, this is the final formula I used to get the full unix timestamp:

Given Unix timestamp limitations, is there a better way to generate and sync this date?

🎉 Ok, yes, it's possible. This is what I used to have a single column sync the current enrichment date to HubSpot:

Appending the 000 seems wonky but that's the only way I got it to work. Would love to know if there's a better way!

Is it possible though to just set a formula using a UNIX timestamp in the original New Enrich Date column?

Ok, I was finally able to get it by adding the Clay date formmater column to change the Enrich date moment().format('') to a Unix timestamp.