Unable to find column 'Latest CheckInOut DateTime'

AppSheet AppSheet Q&A
1

I have an App where I’m a bit stumped by an odd error. In a table within a template I have the following formula:

<<ANY(Select([Related CheckInOuts][Photo],AND(
[Direction]=“Check Out”,
[CheckInOutCreation]=[_ThisRow].[Latest CheckInOut DateTime]
)****))>>

But the template crashes the app with this error

New process’ task ‘Email Tenant Key Report’ Body template. Expression ‘ANY(Select([Related CheckInOuts][Photo],AND([Direction]=“Check Out”,[CheckInOutCreation]=[_ThisRow].[Latest CheckInOut DateTime])))’ is invalid due to: Error in expression ‘[_ThisRow].[Latest CheckInOut DateTime]’ : Unable to find column ‘Latest CheckInOut DateTime’.

So I tried just

<<[Latest CheckInOut DateTime]>>

in the app and that worked fine. But this gives the same error

<<[ThisRow].[Latest CheckInOut DateTime]>>

my understanding is that in this context [_ThisRow] should be meaninless. What even stranger is I’ve put the first formula in a virtual column and it works fine :thinking:

Anyone any ideas?

2 
<<ANY(Select([Related CheckInOuts][Photo],AND(
   [Direction]="Check Out",
   [CheckInOutCreation]=[_ThisRow-1].[Latest CheckInOut DateTime]
)))>>
1 Like