I would like to display a message to the user when the sum of 4 custom fields is greater than another custom field.
so in this example if the sum of the 4 spend amounts are greater than the requested amount, then i would like to display a message to the user
Referring to SuiteAnswer Id: 89103 I have a workflow set up with a show message action.
First I tried this:
Workflow Initiation: Event Based
On Create: Is checked
On View or Update: Is checked
State 1
Add a Show Message Action
Trigger On: After Field Edit
Context:User Interface
5 Triggering Client Fields:
Q1 Spend
Q2 Spend
Q3 Spend
Q4 Spend
Requested Amount
Condition:
Using the 'after field edit' trigger with these 4 spend amounts as the triggering fields just starts an infinite loop.Because the user does not get a chance to finish populating all the 4 fields before the warning message gets displayed.
I'm not sure that i have the condition correct either.
I also tried to instead set the workflow to trigger 'before submit record' but I can't seem to get the correct combination of triggers or condition.
Any advice would be appreciated.