Hi,
I am trying to get an email report to run for a slice. I have created a template for it, however I am wondering if my โIFโ expression is wrong. I currently have it set to โISNOTBLANK(โvalue_0โ)โ for my slice, and I am not receiving any emails when I press run. Should the value of the expression be something else.
Solved! Go to Solution.
Remove the square brackets surrounding โEndโ.
What are you seeing in the Audit History as described in this article https://help.appsheet.com/en/articles/961739-troubleshooting-workflow-emails
The Audit History is always the first thing to check when a workflow rule or report is failing.
It saying there is an unmatched start:
Properties:
{
โAppTemplateNameโ: โNewApp-983543โ,
โAppIdโ: โ7216ecbf-26d1-4a4c-bd74-8e81643585d4โ,
โAppTemplateVersionโ: โ1.000331โ,
โRuleNameโ: โKensingtonโ,
โEventTypeโ: โScheduledโ,
โInvokedByโ: โEditorRunButtonโ,
โServerโ: โprodv2-lb-3โ,
โEventMatchโ: โWorkflow event successfully matchedโ,
โConditionโ: โ=ISNOTBLANK(โvalue_0โ)โ,
โMatchesConditionโ: โTrueโ,
โActionNotPerformedโ: โ5 errors present.โ,
โActionResultsโ: โCreated 1 ActionResultsโ,
โAction Nameโ: โKensington Emailโ,
โRecordedAtโ: โ2019-07-19T20:45:32.3254283Zโ,
โErrorsโ: โError: Workflow rule โKensingtonโ action โKensington Emailโ Body template. Found 1 unmatched โStartโ. They are: <p class=โc0โ><span class=โc14โ><<Start: FILTER(Kensington, true)>>
Above is an upload of the template I used.
You are missing the << END >> in the last cell of the row.
<<[Tech]>><< End >>
Added the <>
You may have more than one problem in your template, but that is definitely a problem.
Try fixing that problem and see if there are other problems in your template.
When you save your application in the Editor, you should choose the โSave and verify dataโ option.
That will ensure that the templates are verifies when you do the save.
Try the following:
Made the changes and I got this error result:
Errors": โError: Workflow rule โKensingtonโ action โKensingtonโ Body template. Found 1 unmatched โStartโ. They are: <p class=โc19โ><span class=โc6โ><<Start:Filter(Patrol, true)>><<[Patrol Action>>
Error: Workflow rule โKensingtonโ action โKensingtonโ Body template. Expression โStart:Filter(Patrol, true)โ is invalid due to: Unable to find function โSTART:FILTERโ, did you mean โFILTERโ?. Error: Workflow rule โKensingtonโ action โKensingtonโ Body template. Expression โ[Patrol Actionโ is invalid due to: Expression refers to undefined field. Error: Workflow rule โKensingtonโ action โKensingtonโ Body template. Expression โ[Time]โ is invalid due to: Unable to find column โTimeโ. Error: Workflow rule โKensingtonโ action โKensingtonโ Body template. Expression โ[Tech]โ is invalid due to: Unable to find column โTechโ. Error: Workflow rule โKensingtonโ action โKensingtonโ Body template. Expression โ[End]โ is invalid due to: Unable to find column โEndโ.โ,For reference, the slice name is Kensington
The Columns:
[Patrol Action]
[Time]
[Tech]
condition is set to ISNOTBLANK(โvalue_0โ)
You did not remove the first << START >> or the final << END >> at the bottom of the template.
In fact, you did not follow step 4 either.
I made the changes as instructed, yet my results still ended in error:
and I ended up with the same result after attempting to run it:
โErrorsโ: โError: Workflow rule โKensingtonโ action โKensingtonโ Body template. Found 1 unmatched โStartโ. They are: <p class=โc8โ><span class=โc17โ><<Start:Filter([Patrol], true)>><<[Patrol Actions]>>
Error: Workflow rule โKensingtonโ action โKensingtonโ Body template. Expression โStart:Filter([Patrol], true)โ is invalid due to: Unable to find column โPatrolโ. Error: Workflow rule โKensingtonโ action โKensingtonโ Body template. Expression โ[Patrol Actions]โ is invalid due to: Unable to find column โPatrol Actionsโ. Error: Workflow rule โKensingtonโ action โKensingtonโ Body template. Expression โ[Time]โ is invalid due to: Unable to find column โTimeโ. Error: Workflow rule โKensingtonโ action โKensingtonโ Body template. Expression โ[Tech]โ is invalid due to: Unable to find column โTechโ. Error: Workflow rule โKensingtonโ action โKensingtonโ Body template. Expression โ[End]โ is invalid due to: Unable to find column โEndโ.โ,Remove the square brackets surrounding โEndโ.
User | Count |
---|---|
41 | |
25 | |
25 | |
16 | |
12 |