Update multiple rows in grid

[dcamlin (David Camlin)]

You’ll need a couple events to do it…

@Ty_Shylanski

When the button is clicked, it does a GetByID of the JobPart BO to pull in the dataview data. After that, I have a row-update set to update the qtys.

You’ll need to move your row update to its own event because you’re going to iterate through this event multiple times.

In your main event, instead of the Row Update, you want to use a DataView-Condition.

For the parameters of that dataview-condition:
DataView: The name of the dataview you want to evaluate
Results: matches
Expression: You can just leave this blank, because you want all rows to go through the iterative event.
Iterative Event: The name of the event that does your row update.

Here’s an example post… and you can find more posts if you search for “dataview condition” in the forum:

Set Value for Every Row in Dataview

What I ended up doing was creating 2 events. 1 had a dataview-condition that checks if the PassedText is ‘P’ and then iterates through the second event that does a row-update for the dataview. Here are screenshots. For reference, there is a good zendesk article, from the UI Help, search “Frequently Used Event Actions and Triggers”. I put the screenshots below: dataview-condition [image] Iterating event [image] Frequently Used Event Actions and Triggers [image]