SControl: AttendeeCount Desc: Attendee count for hidden field on a custom object (Conference) that is related to Contacts
This one is a bit tricky but useful if you do not have a master child relationship between your two objects. The trick is to add a hidden SControl on the parent object that is going to execute each time the page is viewed. It should query the related child data and if your query data does not match update your summary field and refresh the page. Warning: Don't get caught in a loop.
Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<script src="/soap/ajax/10.0/connection.js"></script>
<script src="/js/dojo/0.4.1/dojo.js"></script>
<script>
dojo.addOnLoad(init);
function init() {
countResult = sforce.connection.query("SELECT id FROM Contact WHERE Conference__c = '{!Conference__c.Id}'");
//alert(countResult.size);
//alert({!Conference__c.AttendeeCountHidden__c});
if (countResult.size != {!Conference__c.AttendeeCountHidden__c}) {
conf = sforce.connection.retrieve("AttendeeCountHidden__c", "Conference__c", ["{!Conference__c.Id}"]);
conf[0].AttendeeCountHidden__c = countResult.size;
conf = sforce.connection.update(conf);
if (conf[0].getBoolean("success")) {
window.top.location.href = "/{!Conference__c.Id}"
}
}
}
</script>
SControl: AttendeeCount Desc: Attendee count for hidden field on a custom object (Conference) that is related to Contacts
This one is a bit tricky but useful if you do not have a master child relationship between your two objects. The trick is to add a hidden SControl on the parent object that is going to execute each time the page is viewed. It should query the related child data and if your query data does not match update your summary field and refresh the page. Warning: Don't get caught in a loop.
Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<script src="/soap/ajax/10.0/connection.js"></script>
<script src="/js/dojo/0.4.1/dojo.js"></script>
<script>
dojo.addOnLoad(init);
function init() {
countResult = sforce.connection.query("SELECT id FROM Contact WHERE Conference__c = '{!Conference__c.Id}'");
//alert(countResult.size);
//alert({!Conference__c.AttendeeCountHidden__c});
if (countResult.size != {!Conference__c.AttendeeCountHidden__c}) {
conf = sforce.connection.retrieve("AttendeeCountHidden__c", "Conference__c", ["{!Conference__c.Id}"]);
conf[0].AttendeeCountHidden__c = countResult.size;
conf = sforce.connection.update(conf);
if (conf[0].getBoolean("success")) {
window.top.location.href = "/{!Conference__c.Id}"
}
}
}
</script>
