Hi there,
Please see the attached file which has the exact requirements. In order to explain my problem it is important to see the attached file, which has screen shots and the images?
Thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
woww! Seems like lot of work than I possibly thought.
My javascript coding skills are beginner level - but I am able to put 2 and 2 together and get things working. :-) Maybe not be smart but it works, and at the side I keep working to improve on those.
To answer your first question - The MAKE object is the custom object that I created with a new record type and the page layouts.
Hmm..You really got me thinking there, Exacytly where should start this from?
First, you need to design a form that uses the Salesforce API to provide the lookup. You'll need a text field for entering the query, a button for submitting the query, and a <div> that will hold the search results.
In your query button, you will use the api's "query" method to get a list of matching records. Then, you will use these records to write the HTML that will be pushed into the <div>'s innerHTML property. The html should include links that will close the pop-up and set the hidden fields in the main form.
Thanks Bill. This sounds like a big project - and it is, my question is - if I start on this..would you be able to guide me through until I finish this. I understand EE does not allow to take this offline, so I post my queries here would you able to check in regurarly.
1.> To design a Form using the Salesforce API.
I am assuming this can be done using any HTML editor and then how will I determine which Salesforce API Name to be used.
I think I will stick to the first step for now and then move forward from here.
Thanks again
Sure, I've never built a custom picker for SFDC, but it's just a matter of time before I need one. We can just keep adding to this question as we work on the solution. I develop software full-time, so I won't always be able to answer immediately, but I won't leave you hanging around forever. If I can't respond right away, I'll let you know.
I think that getting the popup to read records and return values to the proper hidden fields will be the easy part. Our first challenge is to get the button on the form to show our popup instead of the SFDC one.
One way we can do that is to remove the account reference field and add our own field along with a custom button. I'm not crazy about this solution because it may affect reporting.
Another way is to include some script that will force the existing button to call our code. I will start looking for the best way to do this in my spare time. Do you have a deadline?
Hey thanks for replying again.
No I do not have a deadline for this issue yet, they have thrown this on me to see how far can I get with this issue. Pretty much testing my abilities !
I will start on this project starting next week. Is it anyway I can contact you outside EE like I can be reached on suma_anand04 on t messenger...Not sure if the EE community will allow to do that...
Also - I have another Salesforce related question related to Validation rules. Here is the link - can you help me with this:-
http://www.experts-exchang
This is another SF questions have not got a reply to it yet.
Excellent!
I just posted the question under Salesforce zone.
http://www.experts-exchang
Let me what you think , looking forward to hear from you.
Thanks
Hey,
I was just staring to work on this when I realized that you can't run custom JavaScript when a page is in edit mode except via a custom button or link.
sControls don't even load in edit mode, so we can't use them.
The only option left is to add a custom button or link that would use our custom lookup rather than the default one. The problem with this is that the users will have two buttons -- one right by the field (the standard one) and ours (probably at the top of the form). How do we get the users to click the right button? There's no way to enforce use of our control over the built-in one.
Salesforce has hinted for years that they will have form events that we can code like formPostOpen, formQuerySave, etc. If they ever do implement these events, overriding the button should be easy.
I haven't completely given up yet, but I wanted to give you a heads up.
Business Accounts
Answer for Membership
by: Bill-HansonPosted on 2008-02-26 at 06:32:04ID: 20984557
As far as I know, you can't filter the built-in lookup window, but there's nothing stopping you from designing your own lookup window component.
You should start by taking a look at the source code for your Make object to see how Salesforce does it, then use that as a model for designing your own pop-up. You will probably want to use a tool like Firebug for Firefox for inspecting the form's elements.
You can design the pop-up window any way you like, but it will need to target the following fields on the Make form so that Salesforce can update its database properly when the Make record is saved:
Where XXX is the name of the Account field:
XXX - Editable text field that holds the current name of the Account.
XXX_lkid - Hidden field that holds the id of the record selected in the pop-up (default = "000000000000000").
XXX_lkold - Hidden field that holds the name of the record selected in the pop-up (default = [Same as XXX]).
XXX_mod - Indicates whether the field has been modified (values = "0" or "1", default = "0").
XXX_lktp - Hidden field used by the pop-up to indicate which type of record to display in the pop-up. This is not required unless you want to make your control more compatible with the built in control. For example, for Account, this would be set to "001".
XXX_lspf - Hidden field. I'm not sure what the purpose of this one is. The default value is "0" and it never seems to change.
For example, on the Opportunity page, the Account back-end fields might look like this when the form is placed in edit mode. There is an existing account selected with id of "0013000000C1jFt" and a name of "ACME Testing". The lookup window will display account records ("001"), and the field has not been modified (opp4_mod = "0").
<input id="opp4_lkid" type="hidden" value="0013000000C1jFt" name="opp4_lkid"/>
<input id="opp4_lkold" type="hidden" value="ACME Testing" name="opp4_lkold"/>
<input id="opp4_lktp" type="hidden" value="001" name="opp4_lktp"/>
<input id="opp4_lspf" type="hidden" value="0" name="opp4_lspf"/>
<input id="opp4_mod" type="hidden" value="0" name="opp4_mod"/>
After selecting a new account, the fields look like this:
<input id="opp4_lkid" type="hidden" value="0013000000FVDoQ" name="opp4_lkid"/>
<input id="opp4_lkold" type="hidden" value="TEST - Company A" name="opp4_lkold"/>
<input id="opp4_lktp" type="hidden" value="001" name="opp4_lktp"/>
<input id="opp4_lspf" type="hidden" value="0" name="opp4_lspf"/>
<input id="opp4_mod" type="hidden" value="1" name="opp4_mod"/>
When the user saves the record, Salesforce knows what to do based on the contents of these fields.
So, at a minimum, any custom lookup control should set these fields when a record is selected in the pop-up: XXX_lkid, XXX_lkold, and XXX_mod.
I realize that this is probably not exactly what you are looking for. How are your JavaScript coding skills?