Custom Workbook Scripts

This is a real life example of a template used by a Foreign-Language Group. It is a modified S-140 template.

Please read this help topic to learn more about this actual script and the changes that were made. You may download and use it if it fits the needs of your congregation.

You can read more about the Foreign-Language Group mode that was introduced in Meeting Schedule Assistant v19.0.8 here.

Customised scripts can be easily imported into the Midweek Editor. Just remember to unzip the download first.

– With Weekend Meeting and Duty Assignments (in English)

Here is an example of what to expect:

This custom worksheet script is designed to display one week per page. It includes the following information:

• Midweek Meeting
• Weekend Meeting
• Duty Assignments

Updating Translations

The only translation that will be required is for the heading:

<xsl:template name="DutyAssignHEADING">
  <tr>
    <td class ="cellDUTYASSIGN" colspan="4">
      <div class="textDUTYASSIGN" style="float:left">
        <xsl:text>Assignments for the week</xsl:text>
      </div>
    </td>
  </tr>
</xsl:template>

Other Required Changes

You will need to confirm that the Report Mode is correct (it is using Midweek at the moment):

<!--Duty Assignments-->
<xsl:if test="@SpecialEvent=0">
  <xsl:variable name="Week" select="Date/@ThisWeek"/>
  <xsl:variable name="Weekend-Assignments"
                     select="$DutyHistory/msa:DutyAssignmentHistory/msa:DutyAssignments
            /msa:DutyAssignmentEntry[@Week=$Week and @Mode='Midweek']/msa:Assignment"/>

You will also need to confirm the labels / assignments:

<!--Duty Assignments-->
<xsl:if test="@SpecialEvent=0">
  <xsl:variable name="Week" select="Date/@ThisWeek"/>
  <xsl:variable name="Weekend-Assignments"
                     select="$DutyHistory/msa:DutyAssignmentHistory/msa:DutyAssignments
            /msa:DutyAssignmentEntry[@Week=$Week and @Mode='Midweek']/msa:Assignment"/>

  <table class="DutyAssignTable" cellspacing="0" cellpadding="0">
    <xsl:call-template name="DutyAssignHEADING"/>
    <tr class="DutyAssignRow">
      <xsl:apply-templates select="$Weekend-Assignments[@Index='1' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Sound[@Index='1']"/>
      </xsl:apply-templates>
      <xsl:apply-templates select="$Weekend-Assignments[@Index='5' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Platform"/>
      </xsl:apply-templates>
      <xsl:apply-templates select="$Weekend-Assignments[@Index='7' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Mike[@Index='1']"/>
      </xsl:apply-templates>
      <xsl:apply-templates select="$Weekend-Assignments[@Index='8' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Mike[@Index='2']"/>
      </xsl:apply-templates>
    </tr>
    <tr class="DutyAssignRow">
      <xsl:apply-templates select="$Weekend-Assignments[@Index='13' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Attendant[@Index='1']"/>
      </xsl:apply-templates>
      <xsl:apply-templates select="$Weekend-Assignments[@Index='14' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Attendant[@Index='2']"/>
      </xsl:apply-templates>
      <xsl:apply-templates select="$Weekend-Assignments[@Index='15' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Attendant[@Index='3']"/>
      </xsl:apply-templates>
      <xsl:call-template name="cellEMPTY"/>
    </tr>
  </table>
</xsl:if>

Please read this help topic to familiarise yourself with the Duty Assignment History syntax.

Customising the Look and Feel

A set of classes have been added to the CSS file for styling:

• cellDUTYASSIGN
• textDUTYASSIGN
• textDutyAssignTable
• textDutyAssignRow
• textDutyAssignLabel
• textDutyAssignName