Solved: Workflow error (I´m lost...) - Page 2

Aparicio_Pineyr · 09-17-2019 04:40 PM

Hi there!
I try lots of things but still can´t figure it out what this error is…

"Errors": “Error: Workflow rule ‘TEST’ action ‘Action 1’ Attachment template. Found 1 unmatched 'End. They are: <p class=“c3”><span class=“c1”><>

Error: Workflow rule ‘TEST’ action ‘Action 1’ Attachment template. Expression ‘START: ORDERBY(SELECT(Data[_ComputedKey],AND([Year]=[_THISROW].[Year],[Month]=[_THISROW].[Month],[Day]=[_THISROW].[Day],[company]=[_THISROW].[Company],[farm]=[_THISROW].[Farm],[block]=[_THISROW].[Block],[crop]=[_THISROW].[Crop])),[crop],true)’ is invalid due to: Unable to find function ‘START: ORDERBY’. Error: Workflow rule ‘TEST’ action ‘Action 1’ Attachment template. Expression ‘[White Fly Adults]’ is invalid due to: Unable to find column ‘White Fly Adults’. Error: Workflow rule ‘TEST’ action ‘Action 1’ Attachment template. Expression ‘[White Fly Immatures]’ is invalid due to: Unable to find column ‘White Fly Immatures’. Error: Workflow rule ‘TEST’ action ‘Action 1’ Attachment template. Expression ‘[Active Aphids]’ is invalid due to: Unable to find column ‘Active Aphids’. Error: Workflow rule ‘TEST’ action ‘Action 1’ Attachment template. Expression ‘End’ is invalid due to: Expression refers to undefined field. Error: Workflow rule ‘TEST’ action ‘Action 1’ Body template. Found 1 unmatched 'End. They are: <p class=“c7”><span class=“c4 c5”><> Error: Workflow rule ‘TEST’ action ‘Action 1’ Body template. Expression ‘START: ORDERBY(SELECT(Data[_ComputedKey],AND([Year]=[_THISROW].[Year],[Month]=[_THISROW].[Month],[Day]=[_THISROW].[Day],[company]=[_THISROW].[Company],[farm]=[_THISROW].[Farm],[block]=[_THISROW].[Block],[crop]=[_THISROW].[Crop])),[crop],true)’ is invalid due to: Unable to find function ‘START: ORDERBY’. Error: Workflow rule ‘TEST’ action ‘Action 1’ Body template. Expression ‘[White Fly Adults]’ is invalid due to: Unable to find column ‘White Fly Adults’. Error: Workflow rule ‘TEST’ action ‘Action 1’ Body template. Expression ‘[White Fly Immatures]’ is invalid due to: Unable to find column ‘White Fly Immatures’. Error: Workflow rule ‘TEST’ action ‘Action 1’ Body template. Expression ‘[Active Aphids]’ is invalid due to: Unable to find column ‘Active Aphids’. Error: Workflow rule ‘TEST’ action ‘Action 1’ Body template. Expression ‘End’ is invalid due to: Expression refers to undefined field.”,

Steve

How about this?

<<START: ORDERBY(SELECT(Data[_ComputedKey],AND([Year]=[_THISROW].[Year],[Month]=[_THISROW].[Month],[Day]=[_THISROW].[Day],[company]=[_THISROW].[Company],[farm]=[_THISROW].[Farm],[block]=[_THISROW].[Block],[crop]=[_THISROW].[Crop])),[crop],true)>>
<<[Year]>>
<<[White Fly Adults]>>
<<[White Fly Immatures]>>
<<[Active Aphids]>>
<<END>>

View solution in original post