-
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
Learn Salesforce Einstein – Chapter 2 (AI Buddy Installation)
AI Buddy Installation 1. Login in the org, where you want to install the App. 2. Go to Download Page and click on the latest…
How to Reach Better User Experience of a Salesforce App with a Webix-based Data Grid
Each growing business should continuously evolve since customers are becoming more demanding every day. As a result, software solutions are becoming obsolete very fast. The…
Salesforce Summer ’18 Release - Key Points
Three times per year, Salesforce release a new version of their products, full of new and exciting features. The first and second weekend of June…
Popular Salesforce Videos
The Only Salesforce Developer Video Tutorial Course You Will Ever Need!
A Salesforce developer is a programmer who builds Salesforce applications across various PaaS (Platform as a Service) platforms. A Salesforce developer has an understanding of…
Handle Events in Lightning Web Components | Salesforce Tutorial
Watch this video and learn about the following: Create an app that includes multiple components. Describe the file structure of a complex component. Handle events.
Popular Salesforce Infographics
7 Must Know Features on the New Salesforce AppExchange
The AppExchange is an online marketplace for Salesforce apps, components, and consulting services. If you're a Lightning Platform developer or consultant, the AppExchange is the…
Management: Salesforce – 27 Incredible Sales Tips
Get a complete view of your customers, including activity history, key contacts, customer communications, and internal account discussions.. With sales software from Salesforce (Salesforce Sales…
Salesforce Buzz | An Infographic
While Salesforce has been coined as the World's #1 CRM, there has been a constant buzz around the stats and facts of it. Almost 58%…