How to make action on last row in table

[Luke_Vancleave]

I’m using the type “Data: execute an action on a set of rows” to use my delete action on the last entered row in the table . what syntax do I need to use in the ‘Referenced Rows’ bar to have it execute on the last entered row or bottom row?

[Steve]

Try:

LIST(MAXROW("MyTable", "_ROWNUMBER"))

Replacing MyTable with the name of the table from which you want to delete the row.

[Luke_Vancleave]

Maybe you can assist me with this too. Now that I have this action to complete with this workflow, I’m trying to have the “If condition” reference the values of several columns in the other table I’m using. I’m just having a had time finding the right syntax to use to make the condition say, if these columns in this other table are < 0 then do this action?
Thanks

[Steve]

What expression do you have now?

[Luke_Vancleave]

So I have two tables, Movement Record and Tool List. The workflow triggers whenever I add or update to Movement Record. Then I want it to check the condition if that new row I added in Movement Record made any of the Columns in Tool List negative. I thought the expression to put into the condition was something like “Tool list” [Quantity At Storage 1] < 0 . Just something where it check that the values in these columns on this other table are or are not negative. Then it triggers the action. Here’s where I’m at in pictures

[Steve]

Luke_Vancleave:

Just something where it check that the values in these columns on this other table are or are not negative. Then it triggers the action.

Try:

ISNOTBLANK(
  FILTER(
    "Tool List",
    ([Quantity At Storage) < 0)
  )
)

[Luke_Vancleave]

Steve:

LIST(MAXROW(“MyTable”, “_ROWNUMBER”))

Outstanding, thank you!

[LeventK]

@Luke_Vancleave
Is there a reason that you create multiple posts with exactly the same issue?

How to use workflow to verify data Questions

@Luke_Vancleave [A] Email Workflow WHEN THIS HAPPENS… Target data > Movement Record Update event > ADDS_ONLY IF THIS IS TRUE… Condition > LOOKUP([_THISROW].[Item],"Item List","Tool ID","Quantity at Storage 1") < 0 Set the the rest of the Email workflow as required… [image] [B] Datachange Workflow Step 1: Create a Behaviour Action Create a Behavior Action for your Movement Record table and give a name as you like i.e. Delete Movement Record [image] Step 2: Create the Datacha…

https://community.appsheet.com/t/workflow-condition-help/16608

[Luke_Vancleave]

Hey, I thought it might be more clear if I phrased it more specifically. Your answer helped with my question so I’ve deleted the other one. Many thanks!

[LeventK]

@Luke_Vancleave
I do understand but rather than creating redundant posts with the same content, you can simply choose to edit your original post to re-phrase it. Just a reminder. Thnx.

[Luke_Vancleave]

Gotcha. Thank you again, your community provides excellent support!

[LeventK]

You’re very welcome