email automation for children

Hello,

I am interested in creating automation to send an email when a date is past. I would like the automation to focus on the lowest level of hierarchy to assess whether the date has passed. I intend to make one assumption that a parent row always has "Knowledge Sessions" to indicate the automation follows.

Notice the red "Knowledge Sessions". I would like to assess the date for any rows at the lowest level beneath "Knowledge Sessions" and send an email if needed.

So "Proof of Concept 9am - 12pm" would be assessed. As would: "ETM Overview - 2pm-4pm -" and "EWS & EWS Inbound Interface - 1pm-4pm "

But not "Day 1- Proof of Concept/Intro ETM"

Is that possible?

Thanks,

Dan

Find more posts tagged with

Automations

Accepted answers

All comments

Matthew_Lanterman

Have you tried a helper column that defines which level the row is at? You could include/exclude certain rows based on their hierarchy location in the condition block of the automation.

=COUNT(ANCESTORS))

Or you could define which row is the parent and include / exclude the row in the automation that way

=PARENT([Primary Column]@row)

dpm1028

THANK YOU.

Let me see if I understand.

If I COUNT Ancestors, could I then create an automation based on the highest number?

I'm wondering if a combination will work:

Can I define the PARENT as the "Knowledge Session" row then use hierarchy to determine the lowest level? My fear is that the PARENTs can change. In the image there are 2 below "Knowledge Session" but in practice there may be only 1 or more than 2.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.