Melissa J.

no prob!

ok awesome!

Ah. You have to keep opening up the payload there. So if you click the arrow then you should see all the properties

Hey! Do a 'find contact in Hubspot' step first, and search via email. Then that will bring back all the other properties, so you can feed record ID from there into your update step 🙂

Okay gotcha. Thank you! 🙂

Hey, thank you for the update. That's interesting though, as when I first reported the issue there were no duplicate columns or anything like that. They only came to be afterwards. I'm surprised to hear that it is intended behaviour to not be able to preview/test the output of a formula column before saving it, as I've never seen this happen before. But thank you for looking into it

No worries, thank you! Appreciate it 🙂

And FYI I don't have a formula column in that table right now, I had to abandon all my attempts because there was no data. There is another formula column which was created by Clay support - I believe that's the one you are referencing when you say it's missing what to output if negative?

See my screenshot above - it only shows data for row 1 and then everything after that is either partially missing (just row 2) or completely blank.

I don't believe it to be a prompt issue because the data is not there regardless of what the prompt is