Automation - send more than 7 rows triggered at once with custom message

System

This discussion was created from comments split from: Multiple Update Requests In One Email.

Ibrahim Khaleel

Hi Andree,

As per below comment
"If seven or more rows are triggered at once, the custom subject and body will be removed."

Is it possible to send more than seven rows trigger at once with custom message and updating specific rows.

Kindly let me know if possible or any alternative solution.

Thanks for support as always,

Best regards.

jmyzk_cloudsmart_jp

Hi @Ibrahim Khaleel

I added the following helper column to send update requests triggered by more than six rows at once, keeping the custom message.

[Row ID]
[RANKEQ] ==IFERROR(RANKEQ([Row ID]@row, COLLECT([Row ID]:[Row ID], Send:Send, true), 1), "")
[Retry]

The RANKEQ column ranks the rows by Row ID or any unique number whose Send column is checked.

https://app.smartsheet.com/b/publish?EQBCT=87532a99a6cf4bbe94ec5b3440efbf5c

Then, use the following Automation Workflows.

For the first six rows, the second workflow will be triggered.

For the seven and beyond, Retry will be checked, and update requests will be sent.

The "Update Request for less than 7 rows" automation has another condition not shown above: "Retry is not checked," as unchecking "Retry" could trigger an update request again.

The "Check Retry for more than 7 rows" automation has a RANKEQ <= 7 condition to check the Retry.

The emails have been received.

Custom message by "Subject {{Task }} and body Task: {{Task}}" was not removed.