Workflow error (I´m lost...)

[Aparicio_Pineyr]

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.”,

[Aleksi]

You have unmatch of Start & End pairs. Please check that every <Start:> have the << End >> and the opposite as well.

[Aparicio_Pineyr]

Hi @Aleksi how are you?
This is the expression and I don´t see the missing <>.

<<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 >> in this chat is not showing the End word and the double << >>

[Steve]

Try putting your <<Start>> expression all in a single line:

<<START: ORDERBY(FILTER("Data",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>>

[Aparicio_Pineyr]

Hi @Steve how are you?
This is the error that shows with your expression:

“Errors”: "Error: Workflow rule ‘TEST’ action ‘Action 1’ Attachment template. Contains start token ‘<<’ without matching end token ‘>>’ Error: Workflow rule ‘TEST’ action ‘Action 1’ Body template. Contains start token ‘<<’ without matching end token '>>

[Steve · Accepted solution]

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>>

[Aparicio_Pineyr]

It seems to be working.
Thanks a lot!

[Aleksi]

Just checking… is the “_ComputedKey” your key column?

[Aleksi]

I still believe the reason is not the way you typed it. It should not have anything to do with the error. Maybe there was something wrong with your original formula and you fixed it “by mistake” when retyping that formula. Though glad you were able to fix it!

[Aparicio_Pineyr]

Yep…minor mistake that now it´s been solved!
Thank guys!