You need to sign in to do that
Don't have an account?
Laura StanleyHubbard
Trigger that looks up values on previously written record to see if new record created is a new value
2 week deadline!
We have a custom object on the Account called Pricing. This object has a field called Workers Compensation Code and Last 2 Digits WC Code
The 'Workers Compensation Code' field is a 6 digit text string, and the 'Last 2 Digits' field is a formula field that pulls the far right two digits of the other field. These two digits translate to one of 50 states.
Here's the goal:
1. Search other records already created for a specific Account I'm working on within the Pricing Object to see if that 2 digit code (state) already exists
2. If the state 2 digits code is already present in any previously saved records, do nothing.
3. if the 2 digit code means a new state is being added for this account, then fire a case and a task.
Does this need to be a trigger? Can we use basic configuration to accomplish this?
Thank you!
We have a custom object on the Account called Pricing. This object has a field called Workers Compensation Code and Last 2 Digits WC Code
The 'Workers Compensation Code' field is a 6 digit text string, and the 'Last 2 Digits' field is a formula field that pulls the far right two digits of the other field. These two digits translate to one of 50 states.
Here's the goal:
1. Search other records already created for a specific Account I'm working on within the Pricing Object to see if that 2 digit code (state) already exists
2. If the state 2 digits code is already present in any previously saved records, do nothing.
3. if the 2 digit code means a new state is being added for this account, then fire a case and a task.
Does this need to be a trigger? Can we use basic configuration to accomplish this?
Thank you!
Trigger:
Class (trigger hanlder):
Mark this as Best Answer, if this helps solve your problem.