Im currently working on a clay table that is supposed to create a note in hubspot once but afterwards just update that note, instead of creating new ones, every time new information appears.
However, i cant achieve that because clay straight up blocks any formula that relates to a dependency the column itself created.
I only wanna run the "create note" column if there is no Note ID present. That Note ID is created once the "create note" column runs once. after that I would like to just use the created Note ID to update the note, instead of creating new ones. It's not possible for this logic to produce an infinite loop, because its just a regular "if this then that, else that" logic. I've been looking for a workaround for hours now, but Clay just categorically denies me.
Is there a way to do this??
