elk-gh/visualforce-custom-lookup

Dynamic visualforce lookup

Custom Lookup for Visualforce

This visualforce component allows you to add lookup field whithout a sobject field reference

Demo

https://dieffrei-com-developer-edition.na35.force.com

Main features

1. Define on-the-fly what fields you want by lookup
2. Users can create new record by lookup popup
3. Event handler
4. It's open source, change and contribute as you want

Create lookup widget without a record reference

New button feature for any SObject (custom or standart)

Options (Advanced Lookup)

sObjectName

Type: String Required: no

The SObject api name for related custom object.

value

Type: LookupValue Required: true

The field value holder.

searchFields

Type: String Required: true

Grid fields.

formFields

Type: String Required: true

Form fields.

canCreate

Type: Boolean Required: true

Define with user can create records from lookup popup.

fieldLabel

Type: String Required: true Defaults: Name

Define with field will be used as a input label. Ps. Some standard objects doesnt support Name field.

onchange

Type: String Required: true

Define callback to onchange event. It is a javascript function name.

Usage

Dynamic visualforce lookup without field

<c:AdvancedLookup 
	sObjectName="Order"
	value="{!orderValue}" 
	searchFields="OrderNumber, ContractId, Status, AccountId, EffectiveDate" 
	formFields="OrderNumber, ContractId, Status, AccountId, EffectiveDate"
	canCreate="true"
	fieldLabel="OrderNumber"
	onchange="onChangeOrdertHandler"/>

Visualforce example

<apex:page showHeader="true" sidebar="false" standardController="Contact" extensions="ContactCtrl">
	<apex:form>
		<apex:sectionHeader title="Contact Edit" subtitle="New Contact" />

		<apex:actionFunction name="refresh" action="{!refresh}" reRender="valueSection" />

		<script>

			function onChangeCarHandler(name, id) {
				console.debug(name, id);
				refresh();
			}

			function onChangeOrdertHandler(name, id) {
				console.debug(name, id);
				refresh();
			}

			function onChangeContractHandler(name, id) {
				console.debug(name, id);
				refresh();
			}

		</script>

		<apex:pageBlock title="Contact Edit" mode="edit">
			<apex:pageBlockButtons location="top">
				<apex:commandButton value="Save" action="{!save}" />
				<apex:commandButton value="Cancel" action="{!cancel}" />
			</apex:pageBlockButtons>
			<apex:pageBlockSection title="Contact Information" columns="2">
				
				<apex:inputField value="{!Contact.FirstName}"/>
				<apex:inputField value="{!Contact.LastName}"/>

				<apex:pageBlockSectionItem>
					<apex:outputLabel>{!$ObjectType.Contact.fields.AccountId.Label}</apex:outputLabel>
					<c:Lookup record="{!record}" 
						field="AccountId" 
						searchFields="Name, Rating, BillingCity" 
						formFields="Name, Rating, BillingStreet, BillingState, BillingPostalCode, BillingCountry"
						canCreate="true"
						onchange="refresh"/>
				</apex:pageBlockSectionItem>

				<apex:pageBlockSectionItem>
					<apex:outputLabel>Order</apex:outputLabel>
					<c:AdvancedLookup 
						sObjectName="Order"
						value="{!orderValue}" 
						searchFields="OrderNumber, ContractId, Status, AccountId, EffectiveDate" 
						formFields="OrderNumber, ContractId, Status, AccountId, EffectiveDate"
						canCreate="true"
						fieldLabel="OrderNumber"
						onchange="onChangeOrdertHandler"/>
				</apex:pageBlockSectionItem>

				<apex:pageBlockSectionItem>
					<apex:outputLabel>Contract</apex:outputLabel>
					<c:AdvancedLookup 
						sObjectName="Contract"
						value="{!contractValue}" 
						searchFields="ContractNumber, AccountId, Status, StartDate, EndDate, ContractTerm" 
						formFields="AccountId, Status, StartDate, EndDate, ContractTerm"
						canCreate="true"
						fieldLabel="ContractNumber"
						onchange="onChangeContractHandler"/>
				</apex:pageBlockSectionItem>

				<apex:pageBlockSectionItem>
					<apex:outputLabel>Car</apex:outputLabel>
					<c:AdvancedLookup 
						sObjectName="Car__c"
						value="{!carValue}" 
						searchFields="Name, PlateTxt__c" 
						formFields="Name, PlateTxt__c"
						canCreate="true"
						onchange="onChangeCarHandler"/>
				</apex:pageBlockSectionItem>

			</apex:pageBlockSection>

			<apex:pageBlockSection id="valueSection" title="Bind values" columns="2">
				<apex:pageBlockSectionItem>
					<apex:outputLabel>Order field:</apex:outputLabel>
					<apex:outputText value="{!orderValue}" />
				</apex:pageBlockSectionItem>
				<apex:pageBlockSectionItem>
					<apex:outputLabel>Contract field:</apex:outputLabel>
					<apex:outputText value="{!contractValue}" />
				</apex:pageBlockSectionItem>
				<apex:pageBlockSectionItem>
					<apex:outputLabel>Car field:</apex:outputLabel>
					<apex:outputText value="{!carValue}" />
				</apex:pageBlockSectionItem>
				<apex:pageBlockSectionItem>
					<apex:outputLabel>Contact.AccountId field:</apex:outputLabel>
					<apex:outputText value="{!record.AccountId}" />
				</apex:pageBlockSectionItem>
			</apex:pageBlockSection>

		</apex:pageBlock>
	</apex:form>
</apex:page>

Visualforce controller example

public with sharing class ContactCtrl 
{

    public LookupValue orderValue {get;set;}
    public LookupValue contractValue {get;set;}
	public LookupValue carValue {get;set;}

	public Contact record;

    public ContactCtrl(ApexPages.StandardController stdController) 
    {
    	stdController.addFields(new List<String>{'AccountId', 'Name'});
        this.record = (Contact)stdController.getRecord();

        //initialize advanced lookup's value
        this.orderValue = new LookupValue();
        this.carValue = new LookupValue();
        this.contractValue = new LookupValue();
    }

    public void refresh()
    {

    }

}

Limitations

• Can't select records by typing on input field, autocomplete feature is not released yeat.

Knowed issues

No such column 'LastViewedDate' on entity

According to salesforce support, LastViewedDate is only available for those Custom Objects has custom tab, So to enable recent viewed record, you need to do this workaround https://help.salesforce.com/apex/HTViewSolution?id=000230533&language=en_US