Adding summary field as footer of pageblock table in vf page.

Hi All,

This post is simply showing how can we add the summary field or total amount or other information in footer of PageBlockTable or DataTable in vf page.

Here, in the following example I am showing sum of all the opportunity line items in footer of PageBlockTable,

i am using the <apex:facet name="footer"> tag to show the value in the footer.

Here the code:

	<apex:page standardController="Opportunity">
	<apex:pageBlock title="{!Opportunity.Name}">
	<apex:pageblocktable value="{!Opportunity.OpportunityLineItems}" var="oli">
	<apex:column value="{!oli.PricebookEntry.Name}"/>
	<apex:column value="{!oli.Quantity}"/>
	<apex:column value="{!oli.UnitPrice}">
	<apex:facet name="footer">
	<apex:outputText value="Total:" style="float: right;"/>
	</apex:facet>
	</apex:column>
	<apex:column value="{!oli.TotalPrice}">
	<apex:facet name="footer">
	${!Opportunity.Amount}
	</apex:facet>
	</apex:column>
	</apex:pageblocktable>
	</apex:pageBlock>
	</apex:page>

view raw FooterExample hosted with ❤ by GitHub

Screen shot:

Thanks
Anurag Jain

Insert Records in SF by using JavaScript without Apex classes or controller.

Hi guys,

In this post i am showing how can we use the power of javascript in VF page and inserting record in salesforce without any standard/custom controller or Apex.

By using AJAX Toolkit we can do this task easily.

AJAX Toolkit divides in two type synchronous and asynchronous call.

It works in three simple steps:

1. Connecting to the AJAX Toolkit(By using login methods or getting Session_ID)
2. Embedding the API methods in JavaScript.
3. Processing the results.

in following example i am using synchronous call :-

	<apex:page id="Page" sidebar="false">
	<script src="/soap/ajax/20.0/connection.js" type="text/javascript"></script>
	<script>
	function insertAccount(){
	// Getting Session ID.
	sforce.connection.sessionId = "{!$Api.Session_ID}";
	//Creating New Account Record.
	var account = new sforce.SObject("Account");
	//Getting Account Name from inputText.
	account.Name = document.getElementById("Page:Form:PB:PBS:PBSI:Name").value;
	// This is the line where magic happens, calling Create() method.
	var result = sforce.connection.create([account]);
	if (result[0].getBoolean("success")) {
	alert("New Account is created with id " + result[0].id);
	} else {
	alert("failed to create new Account " + result[0]);
	}
	}
	</script>
	<apex:form id="Form">
	<apex:pageBlock title="Insert Account" tabStyle="Account" id="PB">
	<apex:pageBlockSection title="Account Name" columns="1" id="PBS">
	<apex:pageBlockSectionItem id="PBSI">
	<apex:outputLabel value="Name" />
	<apex:inputText title="Name" id="Name" />
	</apex:pageBlockSectionItem>
	</apex:pageBlockSection>
	<apex:pageBlockButtons>
	<apex:commandButton onclick="return insertAccount();" value="Save"/>
	</apex:pageBlockButtons>
	</apex:pageBlock>
	</apex:form>
	</apex:page>

view raw InsertRecordByJSwithoutController hosted with ❤ by GitHub

Screen Shoots:-

 After inserting of record you are having ID of record :-

Happy Coding...:)

Thanks
Anurag Jain