Report Template Syntax for combine two diff tables not working

AppSheet AppSheet Q&A
, ,
1

I make a report generator and tries to combine two different tables however it returns error. I am not sure whether I am doing it right with the syntax. Can anyone help?
Here is the link: https://docs.google.com/document/d/11vcTijxfSmljMImp4rWyBpRdtMMYqGS-vaHfb6W4R8E/edit?usp=sharing

1 Like
2

What is the error message? One thing.. you are using this syntax here and there <<Report Generator Aduan[Receiver Name]>> where the result is a list. You probably need to see one value from that table and it would be better to use for example LOOKUP().

3

It is not a list though, It is supposed to send back the information that user fill in for the report generator table.

Error message when testing:

  • Error 1 : Task ‘Send an email’ Attachment template. Expression ‘W‏‏ork Order No‏‏’ is invalid due to: Expression refers to undefined field.
  • Error 2 : Task ‘Send an email’ Attachment template. Expression ‘N‏‏o Telefon Pengadu’ is invalid due to: Expression refers to undefined field.
  • Error 3 : Task ‘Send an email’ Attachment template. Expression ‘Jaba‏‏tan Pengadu’ is invalid due to: Expression refers to undefined field.
  • Error 4 : Task ‘Send an email’ Attachment template. Expression ‘Ca‏‏p Masa’ is invalid due to: Expression refers to undefined field.

More details for this:

Nadhirah_0-1708583273362.png
Nadhirah_0-1708583273362.png921×625 42.9 KB

Nadhirah_1-1708583314592.png
Nadhirah_1-1708583314592.png293×465 11 KB

User should be able to select multiple documents and generate report for each but value for the name and position should stay same for all report. Can I know more about the VLOOKUP tho?

4

When you are using a formula where the syntax is TableName[ColumnName] as you have Report Generator Aduan[Receiver Name], the result is always a list, even if it has only value as a result. The result is not a string, it’s a list.

As per the error message, it sounds the template is not able to find those columns from your table you are referring. First check that the <<Start:[Work Order], [Report Generator Aduan]>> is correct. [Report Generator Aduan], what is the column type? Is the [Work Order] generating list of Key column values with your SELECT()?

5

Report Generator Aduan is another table I am referring to. Another table is Work Order. Sorry, I did not quite understand your last question.

6

So.. your syntax is then wrong. When using Start: expression, you can only refer to one table and the result needs to be a list of key column values.. even if you have just one record. Write it like <<Start: YourTableName[KeyColumnName]>> if you don’t need to filter any rows away. Then check if it still throws an error.

7

PM saya jika perlu bantuan. Saya lihat ada syntax yang salah.