This is the activity junction for the Zoho Creator Community. The below list has important information that will be helpful for the Zoho Creator Community.
Hi. I'm customizing an invoice template and so far all is going well except that i cannot get the date/time fields from the contacts details to show in the invoice. I want these to be included as our invoices include an area of service details so its all in one document. These details include the start time for the booking. Can you see what is wrong please? Here is what i've done so far: I've marked the particular rags with **** so these are the only ones that are not showing the information. I'm wondering if something else in the document isn't preventing it from working properly.
There are tables in the code too but they won't translate here. For that reason i have included the html further below.
Booking Details: Event name: ${Contacts.Event Name} Type of event: ${Contacts.Type of Event (e.g. Birthday party/Festival etc.)} Number of faces to be painted: ${Contacts.Approximate number of faces} Age group: ${Contacts.Age (From)} - ${Contacts.Age (up to)}
****Starting time: ${Contacts.Start Date & time} ****Finishing time: ${Contacts.End Date & time} Contact for the day is ${Contacts.Event Contact Name} Mobile number to call if we need to: ${Contacts.Event Contact Mobile/Phone}
Account Name: ${Invoices.Account Name} Status ${Invoices.Status} Due Date: ${Invoices.Due Date} Sales Order: ${Invoices.Sales Order}
Product Name Product Code Qty List Price Total ${Products.Product Name} ${Products.Product Code} ${Invoices.Qty} ${Invoices.List Price} ${Invoices.Total} Sub Total ${Invoices.Sub Total} Tax ${Invoices.Tax} Adjustment ${Invoices.Adjustment} Grand Total ${Invoices.Grand Total}
Terms and Conditions
${Invoices.Terms and Conditions}
***********the html code for the above ******************
Community
Uploading ....
I'm customizing an invoice template and so far all is going well except that i cannot get the date/time fields from the contacts details to show in the invoice.
I want these to be included as our invoices include an area of service details so its all in one document. These details include the start time for the booking. Can you see what is wrong please? Here is what i've done so far: I've marked the particular rags with **** so these are the only ones that are not showing the information. I'm wondering if something else in the document isn't preventing it from working properly.
There are tables in the code too but they won't translate here.
For that reason i have included the html further below.
Hope you can help.
${companyLogo}
Invoice
Invoice Date: ${Invoices.Invoice Date}
Invoice Number : ${Invoices.Invoice No.} ${Organization.Organization Name}
${Organization.Street}
${Organization.City}, ${Organization.State}${Organization.Zip Code}
${Organization.Country}
${Organization.Website}
BILL TO: EVENT ADDRESS:
${Contacts.Billing Name}
${Contacts.Billing street}
${Contacts.Billing City}, ${Contacts.Billing State} ${Contacts.Billing postcode}
${Contacts.Billing country}
${Contacts.Event Location Name}
${Contacts.Event Street}
${Contacts.Event City/Town}, ${Contacts.Event State} ${Contacts.Event Post code}
${Contacts.Event Country}
Booking Details:
Event name: ${Contacts.Event Name}
Type of event: ${Contacts.Type of Event (e.g. Birthday party/Festival etc.)}
Number of faces to be painted:
${Contacts.Approximate number of faces}
Age group: ${Contacts.Age (From)} - ${Contacts.Age (up to)}
****Starting time: ${Contacts.Start Date & time}
****Finishing time: ${Contacts.End Date & time}
Contact for the day is ${Contacts.Event Contact Name}
Mobile number to call if we need to: ${Contacts.Event Contact Mobile/Phone}
Account Name: ${Invoices.Account Name} Status ${Invoices.Status}
Due Date: ${Invoices.Due Date} Sales Order: ${Invoices.Sales Order}
Product Name Product Code Qty List Price Total
${Products.Product Name} ${Products.Product Code} ${Invoices.Qty} ${Invoices.List Price} ${Invoices.Total}
Sub Total ${Invoices.Sub Total}
Tax ${Invoices.Tax}
Adjustment ${Invoices.Adjustment}
Grand Total ${Invoices.Grand Total}
Terms and Conditions
${Invoices.Terms and Conditions}
***********the html code for the above ******************
<table style="background: none repeat scroll 0% 0% rgb(255, 255, 255); padding: 2px;" width="100%" border="0" cellpadding="0" cellspacing="0"><tbody><tr><td><table style="border-width: 1px 4px 4px 1px; border-style: solid; border-color: rgb(218, 218, 218); padding: 10px; background-color: white;" width="100%" border="0" cellpadding="0" cellspacing="0"><tbody><tr><td valign="top"><table style="font-size: 18px;" width="100%" border="0" cellpadding="0" cellspacing="0"><tbody><tr> <td valign="top" width="376" align="left"> ${companyLogo}<br> <b>Invoice</b><br> <font size="2">Invoice Date: ${Invoices.Invoice Date}<br> Invoice Number : </font><font color="#800000" size="4"><b>${Invoices.Invoice No.}</b></font></td><td style="font-size: 12px; color: black;" valign="Bottom" align="left"><span style="font-size: 16px; color: black; font-weight: bold;">${Organization.Organization Name}</span><br> ${Organization.Street}<br> ${Organization.City}, ${Organization.State}${Organization.Zip Code}<br> ${Organization.Country} <p> <b><font size="3">${Organization.Website}</font></b></p></td><td style="font-size: 12px; color: black;" valign="Bottom" align="right"><br></td></tr></tbody></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tbody><tr> <td style="border: 2px solid rgb(232, 232, 232); color: rgb(0, 0, 0);" valign="top" width="50%" bgcolor="#c0c0c0"><b>BILL TO:</b></td> <td style="border: 2px solid rgb(232, 232, 232); color: rgb(0, 0, 0);" valign="top" width="50%" bgcolor="#c0c0c0"> <b>EVENT ADDRESS:</b></td></tr><tr><td style="border: 2px solid rgb(232, 232, 232); color: rgb(0, 0, 0);" valign="top" width="50%"><br> <b>${Contacts.Billing Name}</b><br>${Contacts.Billing street}<br> ${Contacts.Billing City}, ${Contacts.Billing State} ${Contacts.Billing postcode}<br> ${Contacts.Billing country}</td><td style="border: 2px solid rgb(232, 232, 232); color: rgb(0, 0, 0);" valign="top" width="50%"> <br><span style="font-weight: bold;">${Contacts.Event Location Name}</span><b></b><br> ${Contacts.Event Street}<br> ${Contacts.Event City/Town}, ${Contacts.Event State} ${Contacts.Event Post code}<br> ${Contacts.Event Country}<span style="font-weight: bold; color: rgb(102, 51, 0);"></span><br><p> </p></td></tr><tr> <td style="border: 2px solid rgb(232, 232, 232); color: rgb(0, 0, 0);" valign="top" width="50%" bgcolor="#c0c0c0"><b>Booking Details:</b></td><td style="border: 2px solid rgb(232, 232, 232); color: rgb(0, 0, 0);" valign="top" width="50%" bgcolor="#c0c0c0"> </td></tr><tr><td style="border: 2px solid rgb(232, 232, 232); color: rgb(0, 0, 0);" valign="top" width="50%"> <div align="left"> <table width="95%" border="0" cellpadding="0" cellspacing="0"> <tbody><tr> <td> <font face="Arial" size="1">Event name: </font> </td> <td> <font color="#800000" face="Arial" size="2"> <b>${Contacts.Event Name}</b></font></td> </tr> <tr> <td> <font face="Arial" size="1">Type of event: </font> </td> <td> <font color="#800000" face="Arial" size="2"> <b>${Contacts.Type of Event (e.g. Birthday party/Festival etc.)}</b></font></td> </tr> <tr> <td> <font face="Arial" size="1">Number of faces to be painted:</font><font face="Arial" size="2"><b> <br></b></font></td> <td> <font color="#800000" face="Arial" size="2"> <b>${Contacts.Approximate number of faces}</b></font></td> </tr> <tr> <td> <font face="Arial" size="1">Age group: </font> </td> <td> <font color="#800000" face="Arial" size="2"> <b>${Contacts.Age (From)} - ${Contacts.Age (up to)}<br></b></font></td> </tr> </tbody></table> </div> <br></td><td style="border: 2px solid rgb(232, 232, 232); color: rgb(0, 0, 0);" valign="top" width="50%"> <table width="95%" border="0" cellspacing="0"> <tbody><tr> <td> <font face="Arial" size="1"> Starting time: </font></td> <td><b> <font color="#800000" face="Arial" size="2"> </font></b><font color="#800000" face="Arial" size="2"><b>${Contacts.Start Date & time}</b></font></td> </tr> <tr> <td> <font face="Arial" size="1">Finishing time: </font> </td> <td><b> <font color="#800000" face="Arial" size="2"> </font></b><font color="#800000" face="Arial" size="2"><b>${Contacts.End Date & time}</b></font></td> </tr> <tr> <td><font face="Arial" size="1">Contact for the day is </font> </td> <td><b> <font color="#800000" face="Arial" size="2"> ${Contacts.Event Contact Name}</font></b></td> </tr> <tr> <td><font face="Arial" size="1">Mobile number to call if we need to: </font> </td> <td><b> <font color="#800000" face="Arial" size="2"> ${Contacts.Event Contact Mobile/Phone}</font></b></td> </tr> </tbody></table> <br></td></tr></tbody></table><br><br><table style="font-family: Arial,Helvetica,sans-serif; font-size: 11px; color: rgb(0, 0, 0);" width="100%" border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="border-top: 2px solid gray; text-align: right; width: 20%; background-color: rgb(242, 242, 242);">Account Name:</td><td style="border-top: 2px solid gray; width: 30%; font-weight: bold; border-bottom: 1px solid rgb(234, 234, 234);"> ${Invoices.Account Name}</td><td style="border-top: 2px solid gray; text-align: right; width: 20%; background-color: rgb(242, 242, 242);">Status</td><td style="border-top: 2px solid gray; width: 30%; font-weight: bold; border-bottom: 1px solid rgb(234, 234, 234);">${Invoices.Status} </td></tr><tr><td style="text-align: right; width: 20%; background-color: rgb(242, 242, 242);">Due Date:</td><td style="width: 30%; font-weight: bold; border-bottom: 1px solid rgb(234, 234, 234);">${Invoices.Due Date} </td><td style="text-align: right; width: 20%; background-color: rgb(242, 242, 242);">Sales Order:</td><td style="width: 30%; font-weight: bold; border-bottom: 1px solid rgb(234, 234, 234);">${Invoices.Sales Order} </td></tr></tbody></table><br><br><table style="font-family: Arial,Helvetica,sans-serif; font-size: 11px; color: rgb(0, 0, 0);" width="100%" border="0" cellpadding="0" cellspacing="0"><thead><tr><td style="font-weight: bold; background-color: rgb(234, 234, 234); border-top: 2px solid gray;">Product Name</td><td style="font-weight: bold; background-color: rgb(234, 234, 234); border-top: 2px solid gray;">Product Code</td><td style="font-weight: bold; background-color: rgb(234, 234, 234); border-top: 2px solid gray;">Qty</td><td style="font-weight: bold; background-color: rgb(234, 234, 234); border-top: 2px solid gray;" align="right">List Price</td><td style="font-weight: bold; background-color: rgb(234, 234, 234); border-top: 2px solid gray;" align="right">Total</td></tr></thead><tbody id="lineItem"><tr><td style="border-bottom: 2px dotted rgb(218, 218, 218);"><b>${Products.Product Name}</b></td><td style="border-bottom: 2px dotted rgb(218, 218, 218);" valign="top"> ${Products.Product Code}</td><td style="border-bottom: 2px dotted rgb(218, 218, 218);" valign="top">${Invoices.Qty}</td><td style="border-bottom: 2px dotted rgb(218, 218, 218);" valign="top" align="right">${Invoices.List Price}</td><td style="border-bottom: 2px dotted rgb(218, 218, 218);" valign="top" align="right">${Invoices.Total}</td></tr></tbody><tbody><tr><td colspan="4" align="right">Sub Total</td><td align="right"><b>${Invoices.Sub Total}</b></td></tr><tr><td colspan="4" align="right">Tax</td><td align="right">${Invoices.Tax}</td></tr><tr><td colspan="4" align="right">Adjustment</td><td align="right">${Invoices.Adjustment}</td></tr><tr><td colspan="4" style="border-bottom: 2px solid rgb(204, 204, 204);" align="right"><b>Grand Total</b></td><td style="border-bottom: 2px solid rgb(204, 204, 204); border-top: 2px solid rgb(218, 218, 218);" align="right"><b>${Invoices.Grand Total}</b></td></tr></tbody></table><br><br><table width="100%" border="0" cellpadding="5" cellspacing="0"><tbody><tr><td style="color: gray; border-top: 2px solid gray;"><b>Terms and Conditions </b></td></tr><tr><td><pre style="color: gray;" wrap="soft">${Invoices.Terms and Conditions}</pre></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>