I am trying to send a pdf report in a workflow and connot get this to work. The column name is correct and there is an entry in [_THISROW-6] however it comes up with an error. I have tried this for several columns and no luck. Not just with _THISROW-6 but -1, -2, -3 etc
It gives me error “Unable to find column ‘_THISROW-6’”
Any suggestions
I think [_ThisRow-x] only works with the Start expression
1minManager:
I think [_ThisRow-x] only works with the Start expression
Nope! It’s now available in any expression!
For reference, click below:
[FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()](https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-and-select/24216/43) Tips & Tricks ?
Back-references within nested queries ([_THISROW-n]) Consider a complex App formula with “nested” SELECT() expressions (SELECT() expressions within SELECT() expressions): SELECT( table[column1], … SELECT( table[column2], … SELECT( table[column3], … ) … ) … ) Let’s call the row for which this entire expression is evaluated as its App formula the Origin Row. Within this entire expression, we can refer to column values of the Origin Row by dere…