Skip to main content
Michael Dely が「#Collaboration」で質問

I have a custom object that will be submitted by iternal User/Employee.  I would like to be able to have a custom field whether it be a formula or built via Process Builder that will pull in the running total that is available for that user.  Case in point would be the following: 

  • We have a $5,000 limit

    • First time the submit a record for $1000
    • Second time the amount is $1250

Following this logic when the employee goes to put in a third entry, they would see

$2750 still available.  This would deduct the limit from what they have entered thus far.  Can someone please help me out with this?  Appreciate it!

 

Thanks, 

 

Mike 
6 件の回答
  1. 2019年9月24日 17:47
    Hi David, 

     

    I believe I am following you, but still having an issue in getting the running total.  Here is what I have thus far. 

    • Custom Object Field titled, "Remaining Benefit Amount."  This field is set as a formula field with the formula below.    

      $User.Remaining_Conference_Amount__c - Conference_Cost__c
    • Custom User Field titled, "Remaining Conference Amount," which is a currency field

    Then I have a Process Builder workflow where I have the custom object with start process of "only when a record is created. Criteria is "Formula evaluates to true" and used the formula of ISNEW().  Immediate action is update records, but I am having a hard time figuring out what my formula should be.  Can someone please assist?  

     

    Thanks, 

     

    Mike