Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
<p>Total % <span id="confiReport"></span></p>

<script type="application/javascript">
  function totalPercent(ta, td) {
   return Math.round((td / ta) * 100);
  }

  AJS.toInit(function() {
	var isPageEdit = AJS.$('#content').hasClass('page edit');	

    if (!isPageEdit) {
      var url = 'https://wiki.vertuna.com/ajax/confiforms/rest/filter.action?pageId=52626406&f=AmountTrackingAmountTracking1&q=';
	  var xhr = AJS.$.ajax({
  		url: url,
  		timeout: 10000, // 10 sec
  		success: function (data) {
            var ta = 0;
            var td = 0;
            var rows = data.list.entry;
			for (i=0;i<rows.length;i++) {
				ta = ta + rows[i].fields.TotalAmount;
                td = td + rows[i].fields.Deductible;
            }
            AJS.$('#confiReport').append(totalPercent(ta, td));
    		
  		},
  		error: function (jqXHR, textStatus, errorThrown) {
    		console.log('request to get data from ConfiForms has failed... ' + textStatus);
  		}
	});
   }

  });
</script>

...

Code Block
<ac:structured-macro ac:macro-id="660462e3-4177-454c-beef-6d0ae17c187e" ac:name="confiform" ac:schema-version="1">
  <ac:parameter ac:name="formName">AmountTracking<>AmountTracking1</ac:parameter>
  <ac:parameter ac:name="allowReads">true</ac:parameter>
  <ac:parameter ac:name="export">true</ac:parameter>
  <ac:parameter ac:name="registrationFormTitle">Amount Tracking</ac:parameter>
  <ac:rich-text-body>
    <p>
      <br/>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="2ec1405c-016e-48c3-bb51-3eed86c8e968" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">Team</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Team</ac:parameter>
        <ac:parameter ac:name="values">false[1=Team 1|2=Team 2|]</ac:parameter>
        <ac:parameter ac:name="extras">label;false</ac:parameter>
        <ac:parameter ac:name="type">select</ac:parameter>
        <ac:parameter ac:name="required">true</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="03d391c2-ebc5-43ea-89ca-130c156e8b22" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">Year</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Year</ac:parameter>
        <ac:parameter ac:name="values">false[1=2021|2=2022|]</ac:parameter>
        <ac:parameter ac:name="type">select</ac:parameter>
        <ac:parameter ac:name="required">true</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="21a2a149-332d-4598-82e2-b382bdd80f17" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">Month</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Month</ac:parameter>
        <ac:parameter ac:name="values">false[1=January|2=February|]</ac:parameter>
        <ac:parameter ac:name="extras">label;true</ac:parameter>
        <ac:parameter ac:name="type">select</ac:parameter>
        <ac:parameter ac:name="required">true</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="741e5ede-7e42-4ae6-b10b-0b7e0771ee8a" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">TotalAmount</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Total Amount</ac:parameter>
        <ac:parameter ac:name="values">false[1=Payments Insider|2=Elavon Connect|3=ServiceCloud - Salesforce|]</ac:parameter>
        <ac:parameter ac:name="extras">label;true</ac:parameter>
        <ac:parameter ac:name="type">number</ac:parameter>
        <ac:parameter ac:name="required">true</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="f58f31ec-e9bb-4cd6-aa84-6ad67f22419d" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">Deductible</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Deductible</ac:parameter>
        <ac:parameter ac:name="values">false[1=Payments Insider|2=Elavon Connect|3=ServiceCloud - Salesforce|]</ac:parameter>
        <ac:parameter ac:name="extras">label;true</ac:parameter>
        <ac:parameter ac:name="type">number</ac:parameter>
        <ac:parameter ac:name="required">true</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="ea4c385f-3e50-45cd-9469-818a2fc2b878" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">PercentDeductible</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Percent Deductible</ac:parameter>
        <ac:parameter ac:name="extras">CONCAT(ROUND((([entry.Deductible] / [entry.TotalAmount]) * 100),0),"%")</ac:parameter>
        <ac:parameter ac:name="fieldDescription">Dividing # Automated TC by Total # of TCs</ac:parameter>
        <ac:parameter ac:name="type">formula</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <br/>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>