-
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
A Case Study of Salesforce Health Cloud and Salesforce Service Cloud Implementation
In the rapidly evolving healthcare landscape, technology plays a pivotal role in enhancing patient care and operational efficiency. This case study explores how a physician-run…
Hire Salesforce Sales Cloud Developer
Sales teams don’t fail because they lack effort. They fail because their tools don’t support the way they actually sell. Spreadsheets get messy, leads slip…
Salesforce Stripe Payment Processing
In today’s fast-paced digital world, businesses of all sizes constantly seek ways to provide a seamless customer experience. One crucial aspect of this experience is…
Popular Salesforce Videos
How to install Salesforce for Outlook in 2019
Watch this video to learn how to install Salesforce for Outlook. ? Also, we cover all the details in our blog post at https://ascendix.com/blog/integrating-salesforce-outlook/
Maximizing Salesforce Lightning Experience and Lightning Component Performance
00:04:57 - Agenda 00:06:08 - Difference between Salesforce Classic and Salesforce Lightning 00:17:45 - Demo: Load time comparison between Salesforce Classic and Salesforce Lightning when…
Smart Merchandising with Salesforce Einstein AI
Smart Merchandising is a holistic tool that magically combines rich insights from site-wide search, navigation, purchases, and the customer’s current session with strategic business goals.…
Popular Salesforce Infographics
Boost Sales and Marketing with Salesforce Einstein 1
Salesforce Einstein 1 is a suite of artificial intelligence (AI) tools designed to enhance business efficiency and decision-making. Around 80% of customers expect companies to…
Why Integrate Your Pardot Account with Salesforce?
Salesforce Sales Cloud is primarily a sales tool while Pardot is a marketing automation platform. Both are designed to increase sales and maximize efficiency for…
6 Signs Your Business Needs a Salesforce CRM
When people talk about Customer Relationship Management (CRM), they are usually referring to a system that helps with contact management, sales management, productivity, and more.…