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
Could you attach some screenshots? Will be easier for all of us.
Typically, you’ll want to use FILTER() expression in “referenced rows”
FILTER("Ticksheet", ([JobID] = [_THISROW].[JobID]))
This does the trick, thanks guys.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
18 |