LinkedIn
Twitter
I'm going through some courses at AppSheetTraining.com and in the current lesson, they use [_THISROW-1] in a document template. They explain that the minus one takes the expression back to the previous context, in this case, the Employee table.
I feel like something is not quite clicking for me to fully understand [_THISROW-1], and was hoping someone could perhaps this use case in a different way. My assumption is that in the previous <<Start>> statement, the context was the Employee table, but at the same time, the first use of [_THISROW-1] is before the initial <<Start>> statement terminates, it's inside a TemplateIf statement.
[_THISROW-1] is used again in another <<Start>> statement, but given the above paragraph, i have confused myself as to why and when one would use [_THISROW-1], and what exactly it's doing
