Automations Dilema

My team implements software applications. Often the application we install consists of numerous 'parts'. Each 'part' has an accompanying build sheet:

We use Control Center to stand up a project and it will contain all or most of these sheets. We have automation on the sheets when a date is missed. The problem is the automation runs on all of them and if the same person is on multiple sheets, and meets the criteria, they get an email. One person might get 15 emails - then they basically ignore them.

We tried building 1 sheet with the contents of all the fields from all the logs (sheets), but it was unruly.

I am trying to devise a way to 'collect' all the conditions that result in an email and send them in 1 email.

Any suggestions would be appreciated.

Dan

Find more posts tagged with

Automations

Accepted answers

All comments

Stefan

Hi @dpm1028,

did you think about using a report to collect all the rows with dates missed and asssigned to that person?
You could send this report on a regular basis, or put it on a dashboard etc.

Hope this helps

Stefan

dpm1028

Hello Stefan,

I had thought about it, but was not sure how I would do that. Build logic in a report that matches the logic in the sheet automations, then build an automation for the report?

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.