Error with attachment template

Hello,

I have an attachment template:

But appsheet provides this error in the audit log when I try to run this report:

“Errors”: "
Error: Report ‘Timesheet’ action ‘Email Timesheets’ Attachment template.
Expression ‘[Supervisor]’ is invalid due to: Unable to find column ‘Supervisor’.
Error: Report ‘Timesheet’ action ‘Email Timesheets’ Attachment template.
Expression ‘[Project]’ is invalid due to: Unable to find column ‘Project’.

This error message continues on to the final column.
I have noticed that it does not include the first column “Employees”

I am unsure what the issue is. I originally thought it was that my select expression was incorrect but I cannot see why.
<<Start: Select(Timesheet[Timestamp],[Timestamp]>Today()-7)>>
Timesheet is the spreadsheet table
[Timestamp] is the key column in the table

If you see the issue please let me know.
Thank you

The expression in general looks good. Could you please mention if the timestamp is datetime or date type column? If it is datetime type, may be you could wrap it with DATE()

<<Start: Select(Timesheet[Timestamp],DATE([Timestamp])>Today()-7)>>

1 Like

Hi @Suvrutt_Gurjar

The Timestamp column is DateTime type

The << End >> should be inside of your table… Column “Notes” should be <<[Notes]>><< End >>

4 Likes