I have an action set to “Data: execute an action on a set of rows”. I can reference the row I want to edit, that’s fine and working. I have then made another action that is called by this one in the “referenced Action” drop down.
In this action I would like to use a value in the form that was just submitted (so the last row in the table) and replace a value in the row that was referenced in the initial action. They are in 2 different columns but I don’t think that makes a difference. This is all on the same table.
I can easily set the value in the column (in the row to be edited) to be changed to just a random number so I know its all working fine upto that point.
The problem comes when I try to get the value from the last row and use that. If I use [_THISROW].[Column_To_Get_Value_From] or just [Column_To_Get_Value_From], it will use the value from the row that I want to edit, not the last row (the one that trigged the action).
I have used various attempts as MAXROW(), LOOKUP(), SELECT() but can’t get anything to work. I’m sure this should be easy, I just need to to get the value from the last (bottom) row and use that. The closest I got was to make it find the MAX value from the [Column_To_Get_Value_From] and insert that, but as the values wont be in any sort of order, it needs to be the very last row, simple as that!
I’m sure this isn’t as hard as I’m finding it, spent 6 hours trying to get it to work!
Any help would be great.