Workflows didnt auto send

[Ignacio_Engelb1]

Hi, I have the following issue in the workflows of my app.
As context I defined the value of a variable as the triggering action to send a pdf report to an email.
As you can see in the attached images even though the condition is true, the report is not sended, I have to force the action in the aforementioned worflow in order to receive it in my email. I have already checked the audit log and there are not no evident errors.
What could I be missing?

Thank you in advance!

[Aleksi]

Have you deployed the app?

[Ignacio_Engelb1]

Yes, is already deployed.

[1minManager]

So 2 possiblilites

If the table has multiple rows and [Status]=1 on any other row then the workflow won’t run

Also it looks like you it set to updates_only. So its only if [Status] changes to 1 will it trigger

Simon@1minManager.com

[Aleksi]

@1minManager May I ask why do you think it won’t send the email if it has multiple rows? When the option “Update event” is set to Updates_Only, it should send the email every time when you update the record if the Status=1… it doesn’t matter what column you are updating.

[1minManager]

Hi @Aleksi

So I’ve had it a few times where, say a table have 100 rows, Row 1 has already got [Status]=1. An action sequence then runs to write 1 to [Status] on row 100 then clears it. In my experience the workflow will not trigger.

[1minManager]

No not necessarily. I’m just saying that I’ve had workflows that don’t trigger if the data in the column that changes matches data from the same column but in a different row.

So normally in my tables I have a column called [REPORT]. Specifically so I can write something in there to trigger an emailed PDF. So I’ve definately had it where a workflow sequenece would write “Send Report” then clear it in the [Report] column. Yet the email was never sent despite being set to CHANGE with the trigger of [Report]=“Send Report”. When I check the table there were always at least one and sometimes multiple rows where [Report]=“Send Report”. Clearing them all fixed the issue.

Is this a bug then

[Aleksi]

@1minManager So you are asuming that @Ignacio_Engelberger has an action button that set the Status field with the number 1?

[Aleksi]

I have never tried exactly in that way. I normally write that value like USEREMAIL()&"_"&NOW() so I can read the person who made it and when. Because of NOW() I don’t need to clear that value later.

[1minManager]

@Aleksi thats an interesting way to do it. I might use that someday

I do it that way because sometimes I have multiple different reports that can run on one table. So different text can trigger different reports.

[Aleksi]

For that purpose you could write “PurposeA_”&USEREMAIL()&"_"&NOW() with the action button

[Ignacio_Engelb1]

Sorry for the delay, but I have been trying to solve the issue. I removed the condition, so it must be activated with “updates only”, but even then, when I edit the rows it is not sent automatically either, it is only sent when forced to send manually. Can you elaborate more in how place a button to force the sending please.

[Aleksi]

Then the reason is somewhere else. Have you checked the reason from the Audit history details?

[Ignacio_Engelb1]

I have been trying to see the details of the workflow in the audit log, but for some reason it is not loading, I will try later to see if works then.