Samples

Tip

You can copy and paste these snippets directly into your template to get some starter content.

Signee Templates

Queries

Primary

<fetch>
    <entity name='crmd_dms_proposal'>
        <filter type='and'>
            <condition attribute='activityid' operator='eq' value='%{rowId}' />
        </filter>
    </entity>
</fetch>

Query1

<!-- v0.8.8+ -->
<fetch>
    <entity name="crmd_dms_signee">
        <attribute name="crmd_firstname" />
        <attribute name="crmd_lastname" />
        <attribute name="crmd_signatureimage" />
        <filter type="and">
            <condition attribute="crmd_proposalid" operator="eq" value="%{rowId}" />
        </filter>
    </entity>
</fetch>

Signee table

<table data-dms-source="query1">
  <tbody>
    <tr>
      <td>
        <p>
          <span>First Name: ${[crmd_firstname]}</span>
          <br />
          <span>Last Name: ${[crmd_lastname]}</span>
          <br />
          <span>Job Title: ${[crmd_jobtitle]}</span>
          <br />
          <span>Signature:</span>
        </p>
        <p>
          <img src='${[Convert.ToBase64SrcString(File("crmd_signatureimage"))]}' />
        </p>
        <p>
          <span>Signed On: ${[crmd_signedon]}</span>
        </p>
        <p>
          <span>IP Address: ${[crmd_ipaddress]}</span>
        </p>
      </td>
    </tr>
  </tbody>
</table>