I have 3 validation rules that looks a qty of a field and the available qty on the account record and it restricts creation if the login in qty is > than the available qty.
The issue is that I have 3 separate validation rules that looks at the same Login Qty field is the and when they are all activated that conflict with each other. Can you assist in creating a single formula that acts for the 3?
I have a validation rule that I need to pretend a record from being save on creation on the Training Object if the record will exceed the number of Hours Purchased (Formula Field on a related Account Object).
My current formula looks like this but it is only working when I edit the record.
I'm totally new to triggers and have been trying to figure out how to create a Apex Trigger on the Opportunity object that looks at Product object that would return data based on custom number field.
For example:
1. If an Opportunity contains a product line that has a default value such as Standard Training Hours (Custom number field on Pricebook entry) all the opportunity product line items that matches will popluate that field on the opportunity record. The custom field name to populate on the Opportunity record would be Total Training Hours.
2. Then I need to create another trigger on the Account object that if the opportunity has an "Active" Contract associated Opportunity to rollup sum the opportunity of all the Standard training hours from all opportunities that have a value in the Total # of Trainings Purchased.
I'm trying to calculate a field based on a specific picklist value. Not sure if I need a Apex trigger or a formula.
If a picklist value is changed to a specfic value and then count all the related list records custom hours field from that point.
Example: Pick Name: Type of Training, Value = Online At this one whenever a record meets this criteria. All training hours created should be counted. But should only be counted when the above value is true.
I have 3 validation rules that looks a qty of a field and the available qty on the account record and it restricts creation if the login in qty is > than the available qty.
The issue is that I have 3 separate validation rules that looks at the same Login Qty field is the and when they are all activated that conflict with each other. Can you assist in creating a single formula that acts for the 3?
I have a validation rule that I need to pretend a record from being save on creation on the Training Object if the record will exceed the number of Hours Purchased (Formula Field on a related Account Object).
My current formula looks like this but it is only working when I edit the record.
I'm trying to calculate a field based on a specific picklist value. Not sure if I need a Apex trigger or a formula.
If a picklist value is changed to a specfic value and then count all the related list records custom hours field from that point.
Example: Pick Name: Type of Training, Value = Online At this one whenever a record meets this criteria. All training hours created should be counted. But should only be counted when the above value is true.
