My company has an inventory database (Archtics). This database is where our sales reps must pull products to build their orders. Then, they need to go to Salesforce and pull the same products so we can track the sales. This is double work for them. What I want to do is build a button on the Salesforce Opportunity that pulls the products reserved to the related Archtics Account and automatically populates them in corresponding Opportunity Product fields. 

Does anyone know how to do this, or something like it? Any integration softwares or Apex Triggers that you could steer me towards? 

This is urgent, and I'm under a ton of heat.

Thanks for your help.

We are an organization that sells products for multiple properties. Each property uses the same Accounts. However, each property has its own sales reps who can all "own" a single Account. The solution, in my mind, involves custom Account fields, which I've created. They are "Property 1 Account Owner," "Property 2 Account Owner," "Property 3 Account Owner," and "Property 4 Account Owner".

The population of the four custom Account Owner fields will need to depend upon an Activity field AND (the date of the previous Activity OR the date of the last sale).  Please note that the last sale date fields are Account fields. There are four of them, one for each poperty.

Firstly, we have a picklist field called "Team" which lives on the Activity object. The picklist options are each of the properties individually, or any combination of the properties. So, there are 15 picklist options in total. The first step of this trigger will need to determine which custom Account Owner field(s) will be populated based on which picklist option is selected. Choosing "Property 1" in the "Team" field will indicated that "Property 1 Account Owner" is the field to be maniuplated. Choosing "Property 1 and Property 4" in the "Team" field will indicate that "Property 1 Account Owner" and "Property 4 Account Owner" will need to be manipulated.

Secondly, after the User selects a picklist option in the "Team" field on the Activity and hits save, the trigger needs to check if the last sale date field for the corresponding property(s) is within a custom date range. If so, no action should be taken. If not, then the trigger can move to the next step.

Finally, assuming the last sale date field(s) are not within the custom date range, this trigger will need to check the date of the previous Activity. If the previous Activity date is more than 30 days old, then the User's First Name and Last Name can be populated into the corresponding custom Account Owner field. However, if the previous Activity is within the last 30 days, then no action should be taken.

So there is the whole complicated mess. I have no friggin' clue how to write this trigger. But, it would make my company run SO much more smoothly. Does anyone have any ideas? Thanks for your help!

We are an organization that sells products for multiple properties. Each property uses the same Accounts. However, each property has its own sales reps who can all "own" a single Account. The solution, in my mind, involves custom Account fields, which I've created. They are "Property 1 Account Owner," "Property 2 Account Owner," "Property 3 Account Owner," and "Property 4 Account Owner".

The population of the four custom Account Owner fields will need to depend upon an Activity field AND (the date of the previous Activity OR the date of the last sale).  Please note that the last sale date fields are Account fields. There are four of them, one for each poperty.

Firstly, we have a picklist field called "Team" which lives on the Activity object. The picklist options are each of the properties individually, or any combination of the properties. So, there are 15 picklist options in total. The first step of this trigger will need to determine which custom Account Owner field(s) will be populated based on which picklist option is selected. Choosing "Property 1" in the "Team" field will indicated that "Property 1 Account Owner" is the field to be maniuplated. Choosing "Property 1 and Property 4" in the "Team" field will indicate that "Property 1 Account Owner" and "Property 4 Account Owner" will need to be manipulated.

Secondly, after the User selects a picklist option in the "Team" field on the Activity and hits save, the trigger needs to check if the last sale date field for the corresponding property(s) is within a custom date range. If so, no action should be taken. If not, then the trigger can move to the next step.

Finally, assuming the last sale date field(s) are not within the custom date range, this trigger will need to check the date of the previous Activity. If the previous Activity date is more than 30 days old, then the User's First Name and Last Name can be populated into the corresponding custom Account Owner field. However, if the previous Activity is within the last 30 days, then no action should be taken.

So there is the whole complicated mess. I have no friggin' clue how to write this trigger. But, it would make my company run SO much more smoothly. Does anyone have any ideas? Thanks for your help!

Hello,

I am sending alerts to users when a record has been modified. I want an email to contain previous values of the changed fields so I am using the PRIORVALUE to update the fields. PRIORVALUE is working for normal fields but for lookup and picklist it seems like it is giving the values number and displays them as numbers instead of the value itself. Does anyone know how to show previous values of a lookup or picklist in an email/alert?

Appreciate any help.