Email Attachment Error

[Dave_Willett]

Hi guys.
I’m getting the following error:

• Error 1 : ‘Handle updated Ticksheet record’ task ‘Send an email’ Attachment template. Expression ‘Select([Ticksheet][ID],TRUE)’ is invalid due to: Unable to find column ‘Ticksheet’.
• Error 2 : ‘Handle updated Ticksheet record’ task ‘Send an email’ Attachment template. Start expression ‘Select([Ticksheet][ID],TRUE)’ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table.

I don’t understand it because the table “Ticksheet” does exist and [ID] is the key column.
Could anyone advise please.

Thanks

[mateo · Accepted solution]

Dave_Willett:

Select([Ticksheet][ID],TRUE)

Maybe try Select(Ticksheet[ID],TRUE) - when you put Ticksheet into square brackets appsheet treats it like a column not table I guess

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Dave_Willett]

Thanks Mateo, that works.

Regards