Solved

How to update several list items from a smartform rule on a single item?

  • 11 December 2019
  • 1 reply
  • 0 views

Hi,

 

In the list below, I am trying to update the % Complete column on the 'top item' to say 100% (which works fine) but I would like it to then go through all the list items with the same 'Master Process ID" and update the % Complete field on all of them at the same time.

 

I've been playing around with the 'SO method of updating unchanged items, but think I am barking up the wrong tree as it is asking for a single ID?

 

Any suggestions for the best way to achieve this?  Thanks :-)

 

14221iB0BA1689526C045D.jpg

icon

Best answer by Mike_K2 11 December 2019, 20:22

View original

1 reply

Badge +10

You're correct in that you will need to use the update method, however, you'll also need to look through each item in the list and determine if it's Master Process ID is a match, then take the update action accordingly.  The resulting rule will look like:

For each item in a list view/control

      If an advanced condition is true (Current Item MasterProcessID = MasterProcessID in Question)
            Execute the Update method...

 

You can find the for each rules under the "Conditions" tab in the rule designer.

Reply