Dynamic Fields Issue - Subject Line Issue

C. Colin Schultheis

So... intermediate knowledge of Smartsheet.

Weird issue. I've tried messing with the syntax and arrangement...

Subject 1: "{{MeetingID}} - Notes"

Automation Email Subject 1: "Changes to Meeting Log - Project: Project Meeting Minutes"

Subject 2: "{{MeetingID}} - Action Assigned"

Automation Email Subject 2: "Team Huddle - Enterprise Apps - 06/10/21 - 09:30 AM - 10:00 AM - Action Assigned"

I'm confused.

Andrée Starå

@C. Colin Schultheis

This is probaly why.

Placeholders will generate separate notifications when using placeholders with Alert or Update Request actions in change-based workflows if six or fewer rows are triggered simultaneously. If seven or more rows are triggered at once, the custom subject and body will be removed.

Make sense?

Andrée Starå

Hi @C. Colin Schultheis

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

C. Colin Schultheis

https://community.smartsheet.com/discussion/comment/294554#Comment_294554

Here is the side by side of the two. The "action assigned" subject is fine. the Meeting notes is not.

Could it be that I'm returning multiple rows? that doesn't make a lot of sense, but might explain it.

Either way, I hate it.

Mike Wilday

Can you provide a sample of the data you are pulling this from? It might help sculpt the solution. The headers and some sample info would be very helpful in deciphering what's going on.

C. Colin Schultheis

@Mike Wilday if it helps, it is the same exact sheet.

That's what is so confusing.

The difference I see:

1) Meeting notes-- sends several rows

2) Action item -- sends a single row

META-- Replace MS OneNote, run all meetings from Smartsheet and have the data filed/organized and reportable in a meaningful fashion. That requires a certain aesthetic. Right now, the FUNCTION works well, but the subject is not ideal or customized in #1. #2 is perfect.

If you still need details, I can send them. I've been doing database builds for about 25 years or so and it's taking me a moment to figure out the workarounds to the shortcomings of Smartsheet

Andrée Starå

@C. Colin Schultheis

This is probaly why.

Placeholders will generate separate notifications when using placeholders with Alert or Update Request actions in change-based workflows if six or fewer rows are triggered simultaneously. If seven or more rows are triggered at once, the custom subject and body will be removed.

Make sense?