Skip to main content
Lauren Andel (RDC) a posé une question dans #Collaboration
I would like to create a formula that ranks our account by asset size.  The asset size field is loaded from Datafox and updated frequently.  I have a number field that contains the asset rank, but right now it is just uploaded on a monthly basis.  Can someone please point me in the right direction of how to automate that rank?
1 réponse
  1. 9 oct. 2019, 20:58
    Hi Lauren,

     

    Are you familiar with lightning flow?  Flow would be able to do this pretty easily.  

     

    A Get element to get all accounts sorted by asset size.

     

    A loop that loops through the collection variable from the previous step

     

    A assignment that takes a number variable and adds 1 to it for every record in the loop

     

    A assignment that loads those changes into a new collection variable

     

    An update that updates the new collection variable.

     

    If you haven't check used flows before check out these trailheads and give it a try, if you run into issues feel free to ask.