-
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
Defining Salesforce Marketing Cloud Engagement and Why It's Crucial For Businesses
Salesforce Marketing Cloud Engagement previously known as Marketing Cloud Email Studio can play a critical part in a company's marketing strategy, helping develop client connections…
How To Raise Your Profile Within The Salesforce Ecosystem
Raising your profile is not about showing off. It’s more about building your confidence, and letting people know that you are the GoTo perosn so…
What is a Queue in Salesforce? | All You Need to Know
Salesforce queues facilitate the prioritization, dissemination, and assignment of data to teams that collaborate within an organization. Because of queues, employee tasks are more effectively…
Popular Salesforce Videos
How to Log an Admin Assist Support Case in Help and Training in Salesforce Help
Do you need to log a case with Admin Assist Salesforce Support but aren't sure how to go about it? Do you need help filling…
Salesforce Apex Tutorial for beginners | Apex Salesforce Tutorial
Apex is a proprietary language developed by Salesforce.com. It is a strongly typed, object-oriented programming language that allows developers to execute flow and transaction control statements on the…
Security in Salesforce | Security Levels in Salesforce
This 'Security in Salesforce' video by Edureka will help you understand the different levels of security in Salesforce. It will also talk about some of…
Popular Salesforce Infographics
Salesforce Developer Career Path
Embarking along your journey of becoming a Salesforce Technical Extraordinaire is a wise move, as programming in Apex and Visualforce is one of the hottest,…
7 Must Know Features on the New Salesforce AppExchange
Personalized recommendations, intelligent search, and new solutions are just a few of the exciting new features on the brand new AppExchange. Check it out at…
Overview of Salesforce AppExchange Apps Market: Key Insights and Trends for 2024
The Salesforce AppExchange marketplace continues to expand, offering a diverse array of applications designed to enhance various business operations. Our 2024 analysis delves into the…