Is there a way to select just the new row added?

AppSheet AppSheet Q&A
,
1

Hi there,
I’m trying to build a workflow (now bot) that triggers if a row is added to a certain table and than executes an action that will modify a field of another table’s row referenced by the added row, so my thought was to use a data action to some referenced rows, but i can’t find a way to identify directly the ID of the last added row. I thought to use some function that retrives me the number of rows, but if another row is added while my workflow is running there should happen some mistake.

I wonder if already exists any special attribute like [_ADDED_ROW] or [_NEW_ROW] that could work like [_THISROW] but providing me the ID of the last added row.

Thanks

2

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks ?

How do I get the last row of this thing only? MAXROW( “My Table”, “_ROWNUMBER”, ([_THISROW].[Thing] = [Thing]) ) Replace My Table with the name of the table whose row you want; and Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID).

2 Likes
3

But what if another row is added between the workflow trig and the excution of the action? I’ll make chenges to the wrong row, am I right?

4

Correct.

5

Is there the possibility to get a dedicated attribute/method to get the ID of the latest added row in the future?