I have a custom module that stores ‘site addresses’.
When creating an opportunity, the user inputs an address that may already be recorded in the custom site address module.
If it does exist, i want to relate it to the opportunity, if not it should create a new site address record and relate to that.
What is the best way to go about this? It doesn’t seem possible in a workflow? If creating a logic hook, can i create a popup to let the user know what has happened, or select possible matches?