Alan Talavera

That did it! Thanks Bo!

Also, the formula in "ESP Type" is case sensitive, so "DNS Records" does need to convert to lower case to ensure accurate output.

Yes-- the ESP Type column is working as expected, its just returning other currently because the DNS records column is not working. My goal is to combine all of the "data" fields of the array into a single string and save it in the "DNS Records" column. Is that possible in clay?

I think in order to accomplish what I'm trying to do, I would need to combine all "data" fields under "Answer" for "HTTP API" into a single lower case string. Just not sure how to do that.

Mark, would you please take a look at the table again? Having a bit of trouble with implementing on the column titled "Account Row Position" under the lead table. https://app.clay.com/workspaces/154918/workbooks/wb_3dz7XjW4G8vh/tables/t_KeCWgogogAba/views/gv_ewvsaXfb82x3 I'm expecting it to count to 4 on this view, but can't get it to iterate through the list correctly. Probably a syntax issue, but I can't figure out exactly what I'm doing wrong.

Thank you-- I'm poking around as we speak to test it, but things are starting to make sense for me now. Really appreciate your help! 🙌

Thanks Mark, that makes sense-- and I think you're right, it probably is an artifact from running it under that name earlier, I did rename it after the first run IIRC

Does this formula logic still apply? Also, I noticed the 'Unique ID' string is bracketed in the formula. If I'm calling the records 'AccountUID' or 'LeadUID' would I need to adjust that string accordingly?

Hey Mark, that's a bit different from what I was going for actually. The goal was to count the number of appearances and assign position in the count. That way I can apply it to domains and count the number of prospects per email domain and restrict to less than 4 for example.