Post

2 followers Follow
0
Avatar

looking to create a flow that triggers when a job will make a loss Upto 5,000 and another flow when a job will make a loss that is greater than 5,000

Hi All,

I'm looking to create a flow that triggers when a job will make a loss Upto 5,000 and another flow when a job will make a loss that is greater than 5,000, so say a job has a supplier quote 10,000 but there's issues and so the job will be sold for 7,500 i need a trigger to create a flow that will make an authorisation for someone to approve the 2,500 loss and  only when that is approved the job can carry on.

also am looking to do another flow that has the same scenario but the loss is greater than 5,000.

any help is much appreciated.

thanks,

Shah

 

Shah Mumin

Please sign in to leave a comment.

1 comment

0
Avatar

Hi Shah,

I assume that the field where the price (7,500 in your example) is entered is a number or money field. So the flow would be: 

When an item is update
Action 1: Create a custom variable, name it "result"
loss = [Supplier Quote] - [Price] 
Action 2: IF (Sanity Check) = [(Variable) loss] > 0
Action 3: IF (Sanity Check) = [(Variable) loss] <= 5000
Action 4: Send msg/email or assign task to the person who should approve for loss <= 5,000
Action 5: End IF
Action 6: IF (Sanity Check) = [(Variable) loss] > 5000 
Action 7: Send msg/email or assign task to the person who should approave for loss > 5000
Action 8: End IF
Action 9: End IF

Rainer

Rainer Grabowski 0 votes
Comment actions Permalink