Overwrite action

hi everyone~

I'd like to change the "상태" column of the row that I ran on the detail screen.
As it stands, only the first row is being entered.
Please help me.

Hi @sangmin, welcome to the community and thanks for posting! :smiley:

Looking at your screenshots, the formula in your "write to" field points to the first row of the Inbound table, so only that row is being overwritten. To specify the row you'd like to write to, you can use FINDROW().

The structure of your formula would look like:
=FINDROW(Inbound, "Inbound[ColumnToMatch]=$[InputRow][ColumnToMatch]")[ColumnToWriteTo]

You can also use AND to add more criteria to specify the row:
=FINDROW(Inbound, "Inbound[ColumnToMatch1]=$[InputRow][ColumnToMatch1] AND Inbound[ColumnToMatch2]=$[InputRow][ColumnToMatch2]")[ColumnToWriteTo]

Hope this helps, and let us know if you have any other questions. :honey_pot: :honeybee:

1 Like

Thank you so much Alyssa.
I'll ask you more questions in the future. :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.