Error in Template when generating PDF

James_McFarlane · 12-08-2022 08:17 AM

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 '<u+200f><u+200f>CEILING((COUNT([Related InvoicesDetails][InvoicesDetailID])*1.00)/15)<u+200f><u+200f>' is invalid due to: Unable to find function '<u+200f><u+200f>CEILING', 
did you mean 'CEILING'?. Error: 'New process 7' task 'Print Inovice' Body template. 
Expression '(CEILING((<u+200f><u+200f>COUNT([Related InvoicesDetails][InvoicesDetailID])*1.00)/15)=
([id]+1))<u+200f><u+200f>' is invalid due to: Unable to find function '<u+200f><u+200f>COUNT', did you mean 'COUNT'?.
Error: 'New process 7' task 'Print Inovice' Body template. 'If' expression 
'(CEILING((<u+200f><u+200f>COUNT([Related InvoicesDetails][InvoicesDetailID])*1.00)/15)=([id]+1))<u+200f><u+200f>' yields
 a result of type '' rather than the expected type 'Yes/No'. Error: 'New process 7' 
task 'Print Inovice' Body template. Expression '<u+200f><u+200f>COUNT([Related InvoicesDetails]
[InvoicesDetailID])' is invalid due to: Unable to find function '<u+200f><u+200f>COUNT', 
did you mean 'COUNT'?. Error: 'New process 7' task 'Print Inovice' 
Body templ

nbsp;encountered in step with name [Print invoice]: Error: 'New process 7' task 'Print Inovice' Body template. Expression '<u+200f><u+200f>

Steve

Please contact AppSheet Support for help with this.

SkrOYC

What are you using as a template?

James_McFarlane

a Word document.

SkrOYC

Try unstyling all of your Start: expressions

James_McFarlane

@SkrOYC wrote:
Try unstyling all of your Start: expressions

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.

SkrOYC

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

James_McFarlane

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

SkrOYC

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

James_McFarlane

Thanks