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일 오후 5: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