-
How to display picklist values based on Lookup value on VF page in Salesforce?
I created a custom VF page to create custom object record. I have a Account lookup on page.
So whenever a user selects value from the lookup I would like to show dynamic picklist options on VF page by querying with LookupID for example I want to show names on dropdown, queried from selected lookup Id before saving the record.
Class:
public class createPriceRecord
{
public Price__c price{get; set;}
public Price__c priValue;
public Id lookupId{get;set;}
public Price__c ReqOpp;public createPriceRecord (ApexPages.StandardController controller) {
price= (Price__c)controller.getRecord();
stdCtrl=controller;
}
private ApexPages.StandardController stdCtrl;public void AccPopulated()
{
priValue= (Price__c)stdCtrl.getRecord();
}public List<selectOption> getselectValues()
{
List<Prod__c> relatedprod = new List<Prod__c>();relatedprod = [Select Id,name from Prod__c where AccLookup__c.id =: priValue.Account__r.ID ]; // trying to get Account id from VF page
List<SelectOption> Options = new List<SelectOption>();
Options.add(new SelectOption('','-None-'));
for(Prod__c prod:relatedprod)
{
Options.add(new SelectOption(prod.Id,prod.Name));
}
return Options;
}public PageReference SaveRec(){
price.Look_Up__c = lookupId;
insert price;PageReference p=new PageReference('my.salesforce.com/'+price.Id);
return p;}
}
Page:
<apex:page standardController="Price__c" extensions="createPriceRecord" tabStyle="Price__c">
<apex:form >
<apex:pageBlock title="Price Edit" mode="edit">
<apex:pageBlockButtons>
<apex:commandButton value="Save" action="{!SaveRec}"/>
</apex:pageBlockButtons><apex:pageBlockSection columns="2" title="Price Information">
<apex:inputField value="{!price.AccountId}">
<apex:actionSupport event="onchange" action="{!AccPopulated}" immediate="true" />
</apex:inputfield><apex:selectList value="{!lookupId}" title="Select" multiselect="false" size="1" >
<apex:selectOptions value="{!selectValues}"/>
</apex:selectList><apex:inputField value="{!price.name}"/>
</apex:PageBlockSection>
</apex:pageBlock>
</apex:form >
</apex:page>
Log In to reply.
Popular Salesforce Blogs
Salesforce Public Cloud for Education
Digitalization has transformed the way we live and has made data effortlessly accessible in a world that is always on the go, and it has…
The significance of Salesforce and Facebook Integration
Facebook is a leading social networking app in today’s market scenario for doing tasks like share updates, photos or videos with friends and community. Salesforce…
10 best Reports in a Salesforce Marketing Dashboard
Salesforce.com provides a variety of CRM dashboards for businesses to grow. From Sales & marketing dashboards to customer service dashboards, these platforms mainly help in…
Popular Salesforce Videos
Introduction to Salesforce Apex for Developers
Have you ever wanted to write a Trigger in Salesforce? This workshop is designed for people who would like to begin learning the basics of…
Marketing Cloud Connect: View Full Resolution Emails in Sales or Service Cloud
Thumbnails don't always cut it. Sometimes you need the full resolution Marketing Cloud email in Sales or Service Cloud to see what was sent to…
Custom Portfolio in Salesforce | Mini Project | Salesforce Tutorials
In this video, we will create a custom portfolio in Salesforce. We will create a custom community in Salesforce and customize it to create the…
Popular Salesforce Infographics
Explore The Salesforce Support Services Process Chart
This infographic helps you to explore the Salesforce Services process chart. Go through it and let me know in the comments in case of any…
Enhance Productivity with Salesforce Lightning
As a business professional, you are always looking for ways to increase productivity while keeping your team motivated and moving forward. Salesforce Lightning platform is…
What is CRM Process?
CRM denotes Customer Relationship Management (CRM). The name itself says that it is a system for managing the relationship with customers. It includes effective software…