Execute an action of a set of rows

[Dave_Willett]

I need to set a column [Archive] on a number of rows. Here’s where I’ve got so far.

Create Action 1: ArchiveToYes
For a record of this table:“Ticksheet”
Do This: Data: set the values of some columns in this row
Set the columns: Archive = “Yes”

Create Action 2: Archive
For a record of this table:“Ticksheet”
Do This: Data: execute an action on a set of rows
Referenced Table: Ticksheet
Referenced Rows: ???
Referenced Action: ArchiveToYes

So I don’t know what to put in Referenced Rows. The Action needs to set the column [Archive] to “Yes” where the [JobID] is equal to This Row throughout the same table.

Any help guys?
(I know I’ve been busy on here for help today - sorry for that).
Cheers

[mateo]

Could you attach some screenshots? Will be easier for all of us.

[Marc_Dillon]

Typically, you’ll want to use FILTER() expression in “referenced rows”

help.appsheet.com

FILTER()

Select rows of table or slice

[Dave_Willett]

FILTER("Ticksheet", ([JobID] = [_THISROW].[JobID]))

This does the trick, thanks guys.