Automated Bot Email to send PDF - Error Expression Invalid

Hi, i'm trying to automate sending PDF of a report from my AppSheet used for Inventory.

Below are the errors:

Error 1 : 'Handle Daily event' task 'Daily Inventory Report' Attachment template. Expression '[Name]' is invalid due to: Unable to find column 'Name'.

Error 2 : 'Handle Daily event' task 'Daily Inventory Report' Attachment template. Expression '[Description]' is invalid due to: Unable to find column 'Description'.

Error 3 : 'Handle Daily event' task 'Daily Inventory Report' Attachment template. Expression '[Image]' is invalid due to: Unable to find column 'Image'.

Error 4 : 'Handle Daily event' task 'Daily Inventory Report' Attachment template. Expression '[Total Stock Available]' is invalid due to: Unable to find column 'Total Stock Available'.

Error 5 : 'Handle Daily event' task 'Daily Inventory Report' Attachment template. Expression '[Inventory Change Log]' is invalid due to: Unable to find column 'Inventory Change Log'.

Error 6 : 'Handle Daily event' task 'Daily Inventory Report' Attachment template. Start expression '[Inventory Change Log]' 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've triple checked and the Column names are correct, but it is not reading correct, can i know what is happening here that i'm doing wrongly. TIA.

AppSheet Error.png

Solved Solved
0 4 222
1 ACCEPTED SOLUTION

Ok, yep, that's definitely your problem then.

So, the desired output of the PDF is a list of all Items and their [total stocks available]?

You would need to use a START expression to iterate across all records in the Item Table.

https://help.appsheet.com/en/articles/961746-template-start-expressions

At its very simplest, this could just be:

<<START: Items[Item ID]>>  <<[name]>>  <<[total stock]>> <<END>>

View solution in original post

4 REPLIES 4
Top Labels in this Space