To display field values in a table column on a custom Visualforce depending on another object’s record type and to have the field name as the column header.
Position Object:
We have two objects, Positions and Job applications. A position can have many job applications. There are two record types in Position object, Part-time and Full-time. Each position corresponds to one of these two record types.
Job Application Object:
In the Job application object there are two fields called Part-time and Full-time. The Part-time field appears only for the part-time job applications and the full-time field appears only for the full-time job applications.
Requirement:
Our requirement is to show a custom visual force page which takes the input as the Position Id in its URL and it should display the job applications for the particular position along with the part-time or full-time field values. The main part here is to show the part-time or full-time fields on the column with their respective field label on the column header. The decision to show these fields depends upon the record type of the position.
Solution:
To show column values:
We can achieve this using ‘rendered’ keyword which enables us to conditionally render fields on Visualforce page based on some conditions. The code is as follows.
Code:
<apex:column>
<apex:outputText value=”{!app.FullTime__c}” rendered=”{!IF(app.Position__r.RecordType.Name =’FullTime’,true,false)}”/>
apex:outputText value=”{!app.PartTime__c}” rendered=”{!IF(app.Position__r.RecordType.Name =’Part Time’,true,false)}”/>
</apex:column>
Code Explanation:
If record type name is full time then Fulltime fields appear on the column and if it is Part-time then the part-time fields appear.
To show column header:
To show the column header, normally we use ‘headervalue’ and assign a string to it. But in this case,we need to use ‘If’ condition to check the record type value using ‘CONTAINS’ as shown below –
Code:
<apex:column headervalue=”{!IF(CONTAINS(recordType,’art’),”Part Time”,”Full Time”)}”>
Code Explanation:
The recordType holds the value of the Position object’s record type. If the recordType contains ‘art’ as a sub string on it, then it will return ‘Part Time’ which gets assign as the column header or it will return ‘Full Time’ which gets assign as the column header.
The complete code for column header and column values:
<apex:column headervalue=”{!IF(CONTAINS(recordType,’art’),”Part Time”,”Full Time”)}”>
<apex:outputTextvalue=”{!app.FullTime__c}”rendered=”{!IF(app.Position__r.RecordType.Name =’FullTime’,true,false)}”/>
<apex:outputTextvalue=”{!app.PartTime__c}”rendered=”{!IF(app.Position__r.RecordType.Name =’Part Time’,true,false)}”/>
</apex:column>
DisplayJobApplns.vfp
<apex:page controller=”RetjobAppRecordsController”>
<apex:form >
<apex:pageBlock >
<apex:pageBlockTable value=”{!applns}” var=”app”>
<apex:column value=”{!app.Name}”/>
<apex:column value=”{!app.Id}”/>
<apex:column value=”{!app.Position__r.Name}”/>
<apex:column value=”{!app.Status__c}”/>
<apex:column headervalue=”{!IF(CONTAINS(recordType,’art’),”Part Time”,”Full Time”)}”>
<apex:outputText value=”{!app.FullTime__c}” rendered=”{!IF(app.Position__r.RecordType.Name =’FullTime’,true,false)}”/>
<apex:outputText value=”{!app.PartTime__c}” rendered=”{!IF(app.Position__r.RecordType.Name =’Part Time’,true,false)}”/>
</apex:column>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:form>
</apex:page>
RetjobAppRecordsController.apxc
public class RetjobAppRecordsController {
//To hold all SOQL record
public List<Job_Application__c> applns {
get;
set;
}
//To hold all recordType
public String recordType {
get;
set;
}
//To get the URL Id
public String currentRecordId {get;set;}
public RetjobAppRecordsController (){
currentRecordId = ApexPages.CurrentPage().getparameters().get(‘id’);
applns=[select id, Name, Position__r.Name, Status__c, Position__r.RecordType.Name,Position__r.RecordTypeValue__c, FullTime__c, PartTime__c from Job_Application__c where Position__c =: currentRecordId ];
for (Job_Application__c app:applns){
recordType = (app.Position__r.RecordType.Name);
}
}
}
Full-time Positions
Part-time Positions
Source: visualforce page
There was a problem that is faced here that the markup of VF was not matching that of the design, so SLDS came into picture but this was still a persistent problem.
We have the Visualforce Usage API and the Analyzer to help us in this type of issue.
All these were well documented in the trailhead modules but for people who did not have sufficient time to read, the Visualforce Analyzer would be an useful tool.
When we click, this runs a report by the running the metadata against the org.
However, as per the same origin policy of the browser, any code or content from a page cannot be accessed from another page that has a different origin(protocol+host+port).
The Visualforce page is loaded with its own iframe.
If your answer to these questions are yes, then you should definitely consider becoming a Salesforce developer.In my previous blogs, I have discussed Salesforce, Salesforce certifications and also shown you to build a custom application using the declarative options available in Salesforce.
Below is a diagram that outlines the Salesforce Model-View-Controller architecture along with the different Salesforce components.Model: The model is your Salesforce training data objects, fields, and relationships.
Few examples of situations where you can use Visualforce are:To build email templatesTo develop mobile user-interfaceTo generate PDF’s of data stored in SalesforceTo embed them into your standard page layoutsTo override a standard Salesforce pageTo develop custom tabs for your applicationA visualforce page consists of two primary elements:Visualforce Markup – The visualforce markup includes the visualforce tags, HTML, JavaScript or any other web-enabled code.A Visualforce Controller – The visualforce controller contains the instructions that specify what happens when a user interacts with a component.
The visualforce controller is written using Apex programming language.You can take a look at a simple Visualforce page code along with the different components below:Below I have shown you the steps to write a simple visualforce page for displaying countries and their currency values:Step 1: From Setup, enter Visualforce Pages in Quick Find box, then select Visualforce Pages and click New.Step 2: In the editor add the following code to display country and its currency value: ApexOnce you are done developing the user-interface, as a Salesforce developer you need to know how to add custom logic to your application.
Few examples of situations where you can use Apex are:When you want to add web and email services to your applicationWhen you want to perform complex business processesWhen you want to add complex validation rules to your applicationWhen you want to add a custom logic on operations like saving a recordBelow is a screenshot of Apex code along with its different components like looping statement, control-flow statement and SOQL query:iculumNow that we have understood what Apex is and when to use it, let me dive deep into Apex programming.Programming In ApexIf you have understood the concepts described above, then you are halfway through your journey in becoming a Salesforce developer.
If you want to be a Salesforce developer, then you must know both of these query languages.
