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 |
---|---|
42 | |
25 | |
25 | |
17 | |
12 |