The automatic fields that connect two modules cant be used for functions.
I am trying to run a function that will search account notes, if there is no note created in the last 500 days I want it to send an email template I create to the contacts connected to that account. The issue is the fields connecting these two modules can't be targeted.
In English I'm trying to create the following logic statement.
Today date= Current date
Past date = Current date - 500days
AccountId = current clients household (cant do this step)
Account note list= list of 'Accountid' 'notes' (can't do this step since notes isn't a module I can access and isn't a value in the accounts module, where the hell are they kept anyway 🤷🏿)
note date list= Date modified for "account note list"
if any item in note date list after "past date"
"false"
else
"true"
if "true" send an email template to all contacts related to householdid.
This seems simple enough but without the ability to target fields like notes and containing contacts for accounts I'm at a loss on how to do this.