Please let me know if this is possible, and how to best do it (or research it).
Assume I am entering a new opportunity for a lead/client. As a part of creating this opportunity, I am entering a part number (from a drop down menu). Is there a way to have a blank field that will populate with a past opportunity for that contact or account that used the same part?
*This post is locked for comments
Thank you
I assume you want to populate this past opportunity lookup on the new opportunity record? If so do you want that to be populated as soon as you selected the part number from Drop Down or is it ok if it populates when you save the record?
01. If you want it to be populated as soon as you select the value from Drop Down, you have to write javascript to query and get the old opportunity with the same part number - Will there be more than one past opportunity with the same part number? if so you have to consider how you are going to deal with that
02. If you are happy with it being populated when you save the record, you can create a plugin or Workflow with a custom Workflow Activity to query and populate the old opportunity lookup if there is any with the same part number.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (