Since some automation actions are "terminal", meaning that no other actions can happen after these, I tried making several independent automations that all trigger off "When rows are added". Here's my 3 workflows that all trigger on New Row: * 10 New record, Set Status - Actions: Change a cell * 15 New record, Set Due Date - Actions: Record a date * 20New record, Email Manager - Actions: Alert someone That seems to work as the three workflows all seem to have executed. But apparently not in the order I need. The email received was shows the record prior to the actions 10 and 15 happening. How can one enforce the order they happen in?

Multiple Actions on "New Record"?

Since some automation actions are "terminal", meaning that no other actions can happen after these, I tried making several independent automations that all trigger off "When rows are added".

Here's my 3 workflows that all trigger on New Row:

10 New record, Set Status - Actions: Change a cell
15 New record, Set Due Date - Actions: Record a date
20New record, Email Manager - Actions: Alert someone

That seems to work as the three workflows all seem to have executed. But apparently not in the order I need. The email received was shows the record prior to the actions 10 and 15 happening.

How can one enforce the order they happen in?

Find more posts tagged with

Automations

Accepted answers

All comments

Hollie Green

The only way I can think of is to have 4 helper columns.

10 new record helper column - Add an additional action to change this helper column to a 1 when the action runs

15 new record helper column - Add an automation to have the cell in this column to 1 when the 15 new automation would typically run

20 new record automation - Add an automation to have the cell in this column to 1 when the 20 new automation would typically run.

Automation helper - Add a sum formula to sum the 3 helper columns

Change your 15 new record automation to run when the Automation helper column = 2 and add the criteria to change 15 new helper column to a 2

Change your 20 new record automation to run when the automation helper column = 3

ckrusen

I guess I could have 1 helper column "Automation state". The work flows would be:

10 New Record.

Trigger: New row added.

Actions: Change cell value ('Status' to New, 'Auto State' to 10)

20 New Record, Set Due Date.

Trigger: Rows Changed ('Auto State' changes to 10)

Condition: 'Due Date' is blank

Actions: Record date into 'Due Date'

30 Email Contact.

Trigger: Rows Changed ('Due Date' changes to anything

Condition: 'AutoState' is 10

Actions:

1) Alert Someone

2) Change cell value ('AutoState' to 20)

I think that should work. Thanks for the idea to use helper column

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.