?
Solved

Need Filtered Lookup

Posted on 2010-08-26
6
Medium Priority
?
884 Views
Last Modified: 2013-11-24
I need to lock down the pop up box that appears when I click Customers on the Order form.  A pop up box appears with a drop down box for Accounts or Contacts.  The default is Accounts (which is what I want).  I want to lock down the drop down list on the popup box so that only Accounts appear (no option for Contacts)

The url that appears is for the pop up box is:
https://apollo7.space.net//_controls/lookup/lookupsingle.aspx?class=BasicCustomer&objecttypes=1,2&browse=0&ShowNewButton=1&ShowPropButton=1&DefaultType=0

I copied this url into a new browser window and discovered that if I change 'BasicCustomer&objecttypes=1,2' to BasicCustomer&objecttypes=1, then I only show Accounts.  

(Note: If I change it to BasicCustomer&objecttypes=2, then I only see Contacts)

Is there a way to modify/filter lookupsingle.aspx (just for Orders) so that it will only show Accounts in the drop down list?

Thanks
0
Comment
Question by:apollo7
  • 3
  • 3
6 Comments
 
LVL 27

Expert Comment

by:Chinmay Patel
ID: 33535308
Hi apollo7,
I would not suggest to modify the .aspx file. Rather than that onLoad event of case you can change the filtered lookup.
What I suggest is to write a JavaScript that will change the URL as per your requirements i.e. a script that can set objecttypes=1
Regards,
Chinmay

0
 
LVL 1

Author Comment

by:apollo7
ID: 33536669
Chinmay - I think I have some examples of this / I will try one and post any questions and errors.
0
 
LVL 1

Author Comment

by:apollo7
ID: 33653467
Chinmay - thought I had some examples of this but cannot find them. Can you provide a link or example of  how to restrict the Customers lookup on the Order form.  The lookup shows both Accounts and Contacts..I want to show only Accounts as a lookup option.

Thanks
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 27

Accepted Solution

by:
Chinmay Patel earned 2000 total points
ID: 33655843
Hi apollo7,
On form load event, write this statement : 
crmForm.customerid.lookuptypes = 1;
Regards,
Chinmay

0
 
LVL 1

Author Closing Comment

by:apollo7
ID: 33665503
Thanks Chinmay, works great and I can see other places I can use this method
0
 
LVL 27

Expert Comment

by:Chinmay Patel
ID: 33667641
You are welcome. :) 
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: You must have administrative privileges in order to configure lead or case queues. Salesforce.com (http://www.Salesforce.com) is a cloud-based customer relationship management (CRM) system. It is widely used around the world by sales and ma…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question