Announcement
Collapse
No announcement yet.
PDF template-issue (Duration display in seconds instead of hours
Collapse
X
-
Sure, thanks for asking. (Some lines deleted as not able to post full code please check once)
Code Start
<table align="center" style="border-spacing:0; Margin:0; width:100%; max-width:600px;" border="0" cellpadding="4px" cellspacing="0.1px" width="100%">
<tbody>
<tr>
<td align="Right" valign="middle" style="width: 20%; background-color:#41aea9; color:#FFFFFF; border-bottom: 0.1px solid white; border-top: 0.1px solid #41aea9;font-size: 18px; font-weight:bold;line-height: 24px;padding-top: 30px;padding-bottom: 30px; text-align:Right;text-shadow: 0px 0px #0d0000;">
Project:
</td>
<td align="left" valign="middle" style="width: 35%; color:#41aea9; border-top: 0.1px solid #41aea9; border-right: 0.1px solid #41aea9; font-size:18px; font-weight: normal; line-height:24px; padding-top:30px; padding-bottom:30px; text-align:left; text-shadow: 0px 0px #0d0000;">
{{parentName}}
</td>
<td align="left" valign="top" style="color:#41aea9; width: 5%; font-size:10px; font-weight:bold; padding-top:10px; padding-bottom:10px; text-align:left; text-shadow: 0px 0px #160101;">
</td>
<td align="Right" valign="middle" style="border-left: 0.1px solid #41aea9; border-right: 0.1px solid #41aea9; width: 40%; background-color:#41aea9; color:#FFFFFF; font-size:14px; font-weight:bold;line-height: 20px; padding-top:20px; padding-bottom:20px; vertical-align: middle;text-align:Right; /* text-shadow: 0px 0px #160101; */">
Meeting Stakeholders</td>
</tr>
<tr>
<td align="Right" valign="middle" style="border-bottom: 0.1px solid white; width: 20%; background-color:#41aea9; color:#FFFFFF; font-size:12px; font-weight:bold; line-height:15px; padding-top:15px; padding-bottom:15px; text-align:Right; text-shadow: 0px 0px #0d0000;">
Title:
</td>
<td align="left" valign="middle" style="border-bottom: 0.1px solid #41aea9; border-right: 0.1px solid #41aea9; width: 35%; color:#41aea9; font-size:10px; font-weight: normal; line-height:15px; padding-top:15px; padding-bottom:15px; text-align:justify; text-shadow: 0px 0px #0d0000;">{{{name}}}
</td>
<td align="Right" valign="top" style="width: 5%; color:#41aea9; font-size:10px; font-weight:bold; line-height:100%; padding-top:15px; padding-bottom:15px; text-align:Right; text-shadow: 0px 0px #0d0000;">
</td>
<td align="Right" valign="bottom"style="border-left: 0.1px solid #41aea9; border-right: 0.1px solid #41aea9;border-bottom: 0.1px solid #41aea9; width: 40%; line-height: 15px; padding-top: 10px; padding-bottom: 10px; text-align: right; text-shadow: rgb(13, 0, 0) 0px 0px;">
<p>
<font color="#41aea9"><span style="font-size: 10px;"><b>Host</b><br>{{#each users}}
{{#ifMultipleOf @key 3}}{{/ifMultipleOf}} {{usersNames}} {{name}}
[{{title}}]{{/each}}</span></font>
</p>
</td>
</tr>
<tr text-align="justify;">
<td align="Right" valign="middle" style="border-bottom: 0.1px solid white; width: 20%; background-color:#41aea9; color:#FFFFFF; font-size:10px; font-weight:bold; line-height:normal; padding-top:15px; padding-bottom:15px; text-align:Right; text-shadow: 0px 0px #0d0000;">
Agenda
</td>
<td align="left" valign="middle" style="border-bottom: 0.1px solid #41aea9; border-right: 0.1px solid #41aea9; width: 35%; color:#41aea9; font-size:10px; font-weight: normal; line-height:15px; padding-top:15px; padding-bottom:15px; text-align:justify; text-shadow: 0px 0px #0d0000;"><p style="text-align:justify;">{{description}}</p>
</td>
<td align="Right" valign="top" rowspan="5" style="width: 5%; color:#41aea9; font-size:10px; font-weight:bold; line-height:100%; padding-top:15px; padding-bottom:15px; text-align:Right; text-shadow: 0px 0px #0d0000;">
</td>
<td align="Right" valign="bottom" rowspan="5" style="border-left: 0.1px solid #41aea9; border-right: 0.1px solid #41aea9;border-bottom: 0.1px solid #41aea9; width: 40%; line-height: 15px; padding-top: 10px; padding-bottom: 10px; text-align: right; text-shadow: rgb(13, 0, 0) 0px 0px;">
<p>
<font color="#41aea9"><span style="font-size: 10px;"><b>Attendees</b><br> {{#each contacts}}
{{#ifMultipleOf @key 3}}{{/ifMultipleOf}} {{contactsNames}} {{name}},[{{role}}]<br>
{{/each}}</span></font>
</p>
</td>
</tr>
<tr>
<td align="Right" valign="middle" style="border-bottom: 0.1px solid white; width: 20%; background-color:#41aea9; color:#FFFFFF; font-size:10px; font-weight:bold; line-height:100%; padding-top:15px; padding-bottom:15px; text-align:Right; text-shadow: 0px 0px #0d0000;">
Location
</td>
<td align="left" valign="middle" style="border-bottom: 0.1px solid #41aea9; border-right: 0.1px solid #41aea9; width: 35%; color:#41aea9; font-size:10px; font-weight: normal; line-height:100%; padding-top:15px; padding-bottom:15px; text-align:left; text-shadow: 0px 0px #0d0000;">
Online web/Location
</td>
</tr>
<tr>
<td align="Right" valign="top" style="border-bottom: 0.1px solid white; width: 20%; background-color:#41aea9; color:#FFFFFF; font-size:10px; font-weight:bold; line-height:100%; padding-top:15px; padding-bottom:15px; text-align:Right; text-shadow: 0px 0px #0d0000;">
Start Date/Time:
</td>
<td align="left" valign="top" style="border-bottom: 0.1px solid #41aea9; border-right: 0.1px solid #41aea9; width: 35%; color:#41aea9; font-size:10px; font-weight: normal; line-height:100%; padding-top:15px; padding-bottom:15px; text-align:left; text-shadow: 0px 0px #0d0000;">
{{dateFormat dateStart_RAW format='DD MMMM YYYY HH:mm'}}
</td>
</tr>
<tr>
<td align="Right" valign="top" style="border-bottom: 0.1px solid #41aea9; width: 20%; background-color:#41aea9; color:#FFFFFF; font-size:10px; font-weight:bold; line-height:100%; padding-top:15px; padding-bottom:15px; text-align:Right; text-shadow: 0px 0px #0d0000;">
End Date/Time:
</td>
<td align="left" valign="top" style="border-bottom: 0.1px solid #41aea9; border-right: 0.1px solid #41aea9; width: 35%; color:#41aea9; font-size:10px; font-weight: normal; line-height:100%; padding-top:15px; padding-bottom:15px; text-align:left; text-shadow: 0px 0px #0d0000;">
{{dateFormat dateEnd_RAW format='DD MMMM YYYY HH:mm'}}
</td>
</tr>
<tr>
<td align="Right" valign="top" style="border-bottom: 0.1px solid #41aea9; width: 20%; background-color:#41aea9; color:#FFFFFF; font-size:10px; font-weight:bold; line-height:100%; padding-top:15px; padding-bottom:15px; text-align:Right; text-shadow: 0px 0px #0d0000;">
Duration:
</td>
<td align="left" valign="top" style="border-bottom: 0.1px solid #41aea9; border-right: 0.1px solid #41aea9; width: 35%; color:#41aea9; font-size:10px; font-weight: normal; line-height:100%; padding-top:15px; padding-bottom:15px; text-align:left; text-shadow: 0px 0px #0d0000;">
{{durationc}} (Minutes)
</td>
</tr>
</tbody>
</table>
<span style="letter-spacing: 1.2px;">
<br>
</span>
<hr style="line-height: 0.4; border-color: #176259;">
<hr style="line-height: 0.4; border-color: #176259;">
<table align="center" style="border-spacing:0; Margin:0; width:100%; max-width:600px;" border="0" cellpadding="4px" cellspacing="0.1px" width="100%">
<tbody>
<tr>
<td align="left" valign="top" style="border-color: #176259; border-bottom: 0.1px solid white; border-right: 0.1px solid #176259; border-left: 0.1px solid #176259; width: 100%; background-color:#41aea9; color:#FFFFFF; font-size:10px; font-weight: normal; padding-top:10px; padding-bottom:10px; text-align:Left; text-shadow: 0px 0px #160101;" colspan="4" rowspan="1">
Revision History:
</td>
</tr>
<tr>
<td align="Right" valign="top" style="border-color: #176259; border-bottom: 0.1px solid white; border-right: 0.1px solid #176259; border-left: 0.1px solid #176259; width: 15%; background-color:#41aea9; color:#FFFFFF; font-size:8px; font-weight: normal; padding-top:10px; padding-bottom:10px; text-align:Right; text-shadow: 0px 0px #160101;">
Created By:
</td>
<td align="left" valign="top" style="border-color: #176259; border-right: 0.1px solid #176259; border-left: 0.1px solid #176259; color:#41aea9; width: 35%; font-size:8px; font-weight: bold; padding-top:10px; padding-bottom:10px; text-align:left; text-shadow: 0px 0px #160101;">
{{createdByName}}
</td>
<td align="Right" valign="top" style="border-color: #176259; border-bottom: 0.1px solid white; border-right: 0.1px solid #176259; border-left: 0.1px solid #176259; width: 15%; background-color:#41aea9; color:#FFFFFF; font-size:8px; font-weight:normal; padding-top:10px; padding-bottom:10px; text-align:Right; /* text-shadow: 0px 0px #160101; */">
Updated By</td>
<td align="left" valign="top" style="border-color: #176259; border-right: 0.1px solid #176259; border-left: 0.1px solid #176259; color:#41aea9; width: 35%; font-size:8px; font-weight: bold; padding-top:10px; padding-bottom:10px; text-align:left; text-shadow: 0px 0px #160101;">
{{modifiedByName}}
</td>
</tr>
<tr>
<td align="Right" valign="top" style="border-color: #176259; border-bottom: 0.1px solid white; border-right: 0.1px solid #176259; border-left: 0.1px solid #176259; width: 15%; background-color:#41aea9; color:#FFFFFF; font-size:8px; font-weight: normal; padding-top:10px; padding-bottom:10px; text-align:Right; text-shadow: 0px 0px #160101;">
Created on:
</td>
<td align="left" valign="top" style="border-color: #176259; border-right: 0.1px solid #176259; border-left: 0.1px solid #176259; color:#41aea9; width: 35%; font-size:8px; font-weight:bold; padding-top:10px; padding-bottom:12px; text-align:left; text-shadow: 0px 0px #160101;">
{{dateFormat createdAt_RAW format='MMMM DD, YYYY HH:mm'}}
</td>
</tr>
<tr>
<td style="width: 100%; border-color: #176259;" colspan="4" rowspan="1">
<span style="letter-spacing: 1.2px;"></span>
</td>
</tr>
</tbody>
</table>
<span style="letter-spacing: 1.2px;">
<br>
</span>
<hr style="line-height: 0.4; border-color: #176259;">
<span style="letter-spacing: 1.2px;"><br></span><span style="letter-spacing: 1.2px;"><br></span>
Code End
- Likes 2
-
Sorry off-topic but your PDF look beautiful. Can you share the code/template?
Leave a comment:
-
Hi @victor,
I could resolve this time conversion issue without creating a new variable, below the screenshot,
I changed the "TIMESTAMPDIFF_SECOND" to "TIMESTAMPDIFF_HOUR" now the difference itself is displayed in Hours.
Just thought to share, this may not be a good practice to do, and can lead to other related functions being affected.
- Likes 1
Leave a comment:
-
Hi cdmindya,- Go to Administration > Entity Manager > Meeting > Fields and create a field with the Varchar type (screenshot 1);
- Go to Administration > Entity Manager > Meeting > Formula and create a formula (screenshot 2);
Code:
myDuration = duration/3600;
- Go to Administration > PDF Templates and insert a new placeholder {{myDuration}} into your template screenshot 3);
- Go to Administration > Layout Manager > Meetings > Detail (screenshot 4)
Last edited by victor; 09-20-2022, 03:29 PM.
- Likes 2
Leave a comment:
-
PDF template-issue (Duration display in seconds instead of hours
The meetings entity has meeting 'startdate' and 'enddate' fields, and the duration of meeting is calculated and stored in the 'duration' field.
I created a PDF template to export the meeting details into a pdf file, and everything worked perfectly except the duration.
Duration is displayed in hours gets exported to seconds in the PDF file, I have attached the screenshot.
{{duration}} is fetching 3,600
{{duration_RAW}} is fetching 3600
How is possible to display the duration in hours instead of seconds?
Thanks in Advance1 PhotoTags: None
Leave a comment: