LinkedIn
Twitter
I'm trying to create an invoice using automation creating an HTML file, I'm trying to find out and try according to the instructions. and this problem arises, in PDF GDOC im tryin using <<Start:[colum name]>> <<End>> and its works but in HTML i found problem here
this when i trying in PDF
Error encountered in step with name [Print Bill]: Error: Task 'Print Bill' Body template. Expression 'Start:[Room Occupied]' is invalid due to: Unable to find table 'START:', did you mean 'Guest'?. Error: Task 'Print Bill' Body template. Expression '[Room No]' is invalid due to: Unable to find column 'Room No', did you mean 'Amount'?. Error: Task 'Print Bill' Body template. Expression '[Room Type]' is invalid due to: Unable to find column 'Room Type', did you mean 'Room Occupied'?. Error: Task 'Print Bill' Body template. Expression '[Arrival Date]' is invalid due to: Unable to find column 'Arrival Date'. Error: Task 'Print Bill' Body template. Expression '[Departure Date]' is invalid due to: Unable to find column 'Departure Date'. Error: Task 'Print Bill' Body template. Expression '[Extra-bed]' is invalid due to: Unable to find column 'Extra-bed'. Error: Task 'Print Bill' Body template. Expression '[Amount Ext Bed]' is invalid due to: Unable to find column 'Amount Ext Bed', did you me
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<!-- <title>A simple, clean, and responsive HTML invoice template</title> -->
<style>
.invoice-box {
max-width: 800px;
margin: auto;
padding: 30px;
border: 1px solid #eee;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.15);
font-size: 16px;
line-height: 24px;
font-family: 'Helvetica Neue', 'Helvetica', Helvetica, Arial, sans-serif;
color: #555;
}
.invoice-box table {
width: 100%;
line-height: inherit;
text-align: left;
}
.invoice-box table td {
padding: 5px;
vertical-align: top;
}
.invoice-box table td.Amount {
padding: 5px;
vertical-align: top;
color: rgb(31, 30, 98);
font-weight: bold;
text-align: right;
font-size: 14px;
}
.invoice-box table tr.invoice td:nth-child(2) {
text-align: right;
}
.invoice-box table tr.top table td {
padding-bottom: 20px;
}
.invoice-box table tr.top table td.title {
font-size: 45px;
line-height: 45px;
color: #333;
}
.invoice-box table tr.information table td {
padding-bottom: 40px;
}
.invoice-box table tr.heading td {
background: #eee;
border-bottom: 1px solid #ddd;
font-weight: bold;
font-size: 12px;
}
.invoice-box table tr.details td {
padding-bottom: 20px;
}
.invoice-box table tr.item td {
border-bottom: 1px solid #eee;
font-size: 11px;
}
.invoice-box table tr.item.last td {
border-bottom: none;
}
.invoice-box table tr.total td:nth-child(2) {
border-top: 2px solid #eee;
font-weight: bold;
}
.invoice-box table tr.payinfo td:nth-child(2) {
border-top: 2px solid #eee;
font-weight: bold;
color: rgb(31, 30, 98);
font-size: 14px;
text-align: right;
}
only screen and (max-width: 600px) {
.invoice-box table tr.top table td {
width: 100%;
display: block;
text-align: center;
}
.invoice-box table tr.information table td {
width: 100%;
display: block;
text-align: center;
}
}
/** RTL **/
.invoice-box.rtl {
direction: rtl;
font-family: Tahoma, 'Helvetica Neue', 'Helvetica', Helvetica, Arial, sans-serif;
}
.invoice-box.rtl table {
text-align: right;
}
.invoice-box.rtl table tr td:nth-child(2) {
text-align: left;
}
</style>
</head>
<body>
<div class="invoice-box">
<table cellpadding="0" cellspacing="0">
<tr class="top">
<td colspan="8">
<table>
<tr class="invoice">
<td class="title">
<img
src="https://drive.google.com/file/d/1_CtTMhZo5TNFI6CbLjLaLuOJPOcUIrhJ/view?usp=sharing"
style="width: 100%;"
/>
</td>
<td>
Invoice #:<<[ID_Payment]>><br />
Created:<<[Date]>><br />
</td>
</tr>
</table>
</td>
</tr>
<tr class="information">
<td colspan="8">
<table>
<tr class="invoice">
<td>
BILL TO:<br/>
<<[Name_Guest]>>.<br />
<<[Phone]>><br />
<<[Address]>>.<br />
<<[City]>><br />
</td>
<td>
Payment Info<br/>
Payment ID: <<[ID_Payment]>>.<br />
Status Payment: <<[Status Payment]>><br />
Shift: <<[Shift]>>
</td>
</tr>
</table>
</td>
</tr>
<tr class="heading">
<td>Room No.</td>
<td>Room Type</td>
<td>ARR. D</td>
<td>DEP. D</td>
<td>EXT. Bed</td>
<td>Add Breakfast</td>
<td>Room Rate</td>
</tr>
<tr class="item">
<td><<Start:[Room Occupied]>><<[Room No]>></td>
<td><<[Room Type]>></td>
<td><<[Arrival Date]>></td>
<td><<[Departure Date]>></td>
<td><<[Extra-bed]>> : <<[Amount Ext Bed]>></td>
<td><<[Add Breakfast]>></td>
<td><<[Room Rate]>> <<End>></td>
</tr>
<tr class="total">
<td></td>
<td></td>
<td></td>
<td></td>
<td class="Amount" colspan="3">Total: <<[Total Amount]>></td>
</tr>
</table>
<tr class="payinfo">
<td colspan="8">
<table>
<tr class="payinfo">
<td>
</td>
<td>
Price Including Tax and Service<br/>
Total Amount: <<[ID_Payment]>><br />
Amount paid: <<[Amount paid]>><br />
Pay By: <<[Payment By]>><br />
Change: <<[Change]>><br />
Remarks: <<[Remarks]>>
</td>
</tr>
</table>
</td>
</tr>
</div>
</body>
</html>
Dear @codename-12 ,
I checked your html code and I found some issue that I mentioned in the below picture:
