Error in Template when generating PDF

AppSheet AppSheet Q&A
,
1

Hi,

Have not done changes to the app and am getting the following error message when generating a PDF:

Error encountered in step with name [Print invoice]: Error: 'New process 7' task 'Print Inovice' 
Body template. Expression '‏‏CEILING((COUNT([Related InvoicesDetails][InvoicesDetailID])*1.00)/15)‏‏' is invalid due to: Unable to find function '‏‏CEILING', 
did you mean 'CEILING'?. Error: 'New process 7' task 'Print Inovice' Body template. 
Expression '(CEILING((‏‏COUNT([Related InvoicesDetails][InvoicesDetailID])*1.00)/15)=
([id]+1))‏‏' is invalid due to: Unable to find function '‏‏COUNT', did you mean 'COUNT'?.
Error: 'New process 7' task 'Print Inovice' Body template. 'If' expression 
'(CEILING((‏‏COUNT([Related InvoicesDetails][InvoicesDetailID])*1.00)/15)=([id]+1))‏‏' yields
 a result of type '' rather than the expected type 'Yes/No'. Error: 'New process 7' 
task 'Print Inovice' Body template. Expression '‏‏COUNT([Related InvoicesDetails]
[InvoicesDetailID])' is invalid due to: Unable to find function '‏‏COUNT', 
did you mean 'COUNT'?. Error: 'New process 7' task 'Print Inovice' 
Body templ

Screen Shot 2022-12-08 at 12.16.33 PM.png
Screen Shot 2022-12-08 at 12.16.33 PM.png1188×374 18.1 KB

2

Please contact AppSheet Support for help with this.

1 Like
3

What are you using as a template?

1 Like
4

a Word document.

5

Try unstyling all of your Start: expressions

2 Likes
6 
Error encountered in step with name [Print invoice]: Error: 'New process 7' task 'Print 
Inovice' Body template. Expression 'START: TOP([Related InvoicesDetails]
[InvoicesDetailID],[id]*15+15)- TOP([Related InvoicesDetails][InvoicesDetailID],[id]*15)'
 is invalid due to: Unable to find function 'START: TOP', did you mean 'STARTSWITH'?. 
Error: 'New process 7' task 'Print Inovice' Body template. Expression '[Order Name]' is 
invalid due to: Unable to find column 'Order Name', did you mean 'FileName'?. Error: 'New 
process 7' task 'Print Inovice' Body template. Expression '[OrderID].[Dias entregados]' 
is invalid due to: Unable to find column 'OrderID', did you mean 'Created'?. Error: 'New 
process 7' task 'Print Inovice' Body template. Expression '[OrderID].[Fechas Entregadas]
' is invalid due to: Unable to find column 'OrderID', did you mean 'Created'?. Error: 
'New process 7' task 'Print Inovice' Body template. Expression '[Quantity]' 
is invalid due to: Unable to find column 'Quantity', did yo

I did change then and got the above error.

7

Can you make sure there is no blankspace between Start: and TOP?

Start:TOP # This
Start: TOP # This not

Just trying, I don’t recall if it should work with a blankspace or not. The rest “Unable to find..” stuff is related to the Start: not being recognized

8

Hi,

Still does not work, it gives error.

Error encountered in step with name [Print invoice]: Error: 'New process 7' task 'Print Inovice' Body template. Expression 'START: TOP([Related InvoicesDetails][InvoicesDetailID],[id]*15+15)- TOP([Related InvoicesDetails][InvoicesDetailID],[id]*15)' is invalid due to: Unable to find function 'START: TOP', did you mean 'STARTSWITH'?. Error: 'New process 7' task 'Print Inovice' Body template. Expression '[Order Name]' is invalid due to: Unable to find column 'Order Name', did you mean 'FileName'?. Error: 'New process 7' task 'Print Inovice' Body template. Expression '[OrderID].[Dias entregados]' is invalid due to: Unable to find column 'OrderID', did you mean 'Created'?. Error: 'New process 7' task 'Print Inovice' Body template. Expression '[OrderID].[Fechas Entregadas]' is invalid due to: Unable to find column 'OrderID', did you mean 'Created'?. Error: 'New process 7' task 'Print Inovice' Body template. Expression '[Quantity]' is invalid due to: Unable to find column 'Quantity', did yo
9

I think there is a problem with the way AppSheet parses the template, so please contact support

2 Likes
10

Thanks