Changing Data of multiple Rows

Jonathan_S · 01-25-2020 09:14 AM

Good Day everyone,

Im wondering how i would change multiple rows in my table based on an edit of a row.

lets say my Table has 5 columns.

If the user edits the 4th of 5th column in any row, I want to update all corresponding row Columns 4 & or 5 based on a conditional check on column 1, 2 & 3.

Steve

You’d want to use actions. You could attach the actions to the form to be performed when the form is saved, or you could create a workflow that triggers on the row update.

Jonathan_S

Im getting the following errors, So i want to update the following columns of said rows as in my behaviour formula from the values of the said row that was updated.

Steve

Refer to the column you want instead. For instance, [Waffle Weight].

Jonathan_S

This is what I have and everything Is triggering but if does not seem to be working.

!

Am I missing something?

Thanks,

LeventK

@Jonathan_S
Firstly, in your SELECT(…) expression,provided [Id] is the key column for your Types table (which I assume it should be), there is no need to use the FALSE statement at the end because key is by-nature unique and it can’t contain recurring/duplicate key information.

Jonathan_S

Right of course, anything regarding a better way than Marc is suggesting though??

Jonathan_S

Do you know of a better solution? Rather not have a column in my table just for flagging.

Steve

Unfortunately, actions have no inherent way to discover from where or why they were invoked, so a work-around like the one @Marc_Dillon suggests is among your few alternatives. If you don’t want to or cannot augment your existing tables to accomplish the goal, you can instead use a separate table created exclusively for this. It’s a little more complex, but cleaner and is more broadly usable.

Marc_Dillon

I’m betting that you lost the context of which row the system was “in” to begin with, going from workflow to action. So, by setting the “Oven Temp” to [Oven Temp], you are literally assigning it to itself, and it is blank.

If I may suggest. Add a “flag” column to the table (hidden). When this whole action-set starts, set some value to that column. Then in your “Update Rows” action, you’ll assign each column with:

LOOKUP(“flag value” , “Types” , “flag” , “column to return (oven temp, line temp, etc)”)

And make sure to add another action at the end to clear away that flag value.

There may also be a better and more efficient way to do all this…

Sum_Quod_Sum

Hi, I am thinking around and didnt find another solution than yours. But can you stell me how to set a hidden column value just after the change happenned?

Thanks

Marc_Dillon

I cannot, because I have no idea what you just asked for.