14 Replies Latest reply on Sep 23, 2020 3:41 AM by Laurent Matheo

    Innovation Suite- Records A:B has 1:n Association - How to check the status of all B record, that associated to A record?

    Zi Sang
      Share This:

      Hi,

       

      i have 2 Records, "Request" and "Rule". And there is an association that 1 "Request" has many "Rules".

      Both "Request" and "Rule" have a field called "Status"

       

      What we want to do is that, if all of the "Rules" of a certain "Request" is "Completed", then set the status of "Request" also as "Completed".

       

      Maybe we should use process and the trigger should be After Update of "Rule".

      But, how can i go through all the Rules of one Request?

       

      Does anyone has an idea?

       

      Thank you very much!

       

      Regards,

      Zi