Solved: Workflow will SMS but not email

Mike_T · 03-20-2021 07:27 PM

I copied a workflow. Changed the source table. Updated all the new fields <>, etc.
It is triggered based on Adds Only. So I go into the app, submit a form.

The workflow fires off the SMS …no problem.

But no email!

Was working fine on the original workflow. Anything I should be looking for that would prevent an email?

I am using a template. At first I built my own and added the doc ID. When that didn’t work, I had appsheet create the template and I just copied and pasted my original content. Any ideas?

Steve

Use TEXT() to generate a custom-formatted timestamp, rather than using the raw DateTime column value. For instance, rather than:

[DateTime]

use:

TEXT([DateTime], "YYYYMMDDHHMMSS")

See also:

View solution in original post

Steve

Have you checked your spam folder?

What does the workflow log tell you?

Mike_T

Steve,

Again if I could think like you (rational human) I would have thought to check the log. Found a misspelled column name in my template!

Thanks for the reply and solution!

Mike

Steve

There’s so much to consider when troubleshooting! It’s often good to have someone around to give you a little nudge.

Mike_T

Quick followup question regarding the archiving and naming in Workflow…

Any suggestions where I could include the date in the name of the archived pdf? Currently I’m using a datetime type field in the Attachment Name. It’s breaking the date into a folder hierarchy. i.e. 3/21/2021 8:00:00 PM gives me a folder structure of Attachments/Reports/3/21/ 2021 8-00-00 PMfilename etc.

I’ll try to use an expression in the Attachment name field and see what happens but it doesn’t expressly state this is allowed.

Thought I would ask before I break something else.

Steve

Use TEXT() to generate a custom-formatted timestamp, rather than using the raw DateTime column value. For instance, rather than:

[DateTime]

use:

TEXT([DateTime], "YYYYMMDDHHMMSS")