I’ve got a table: SCOPE and a table: NOTE (These are not reference together, and I do not want a helper virtual column. My data sets are very large.)
I have an action on the SCOPE table to LINKTOFORM to create a note. On Save I am attempting to pass that note to a column on the SCOPE table “scope_current_mgt_note” I am using an action to “Execute an action on a set of rows” And then I have my data change action, When I simply put in the MAXROW expression, it injects the correct row ref number. However, when I wrap it in a LOOKUP() it pushes a null value.
ANY(SELECT(
NOTE[note_text], MAXROW(“NOTE”, “note_datetime”, [note_REF_table]=[_THISROW])=[note_key]
))
Solved! Go to Solution.
Could you try this:
INDEX(
ORDERBY(
FILTER(
“NOTE”,
([note_REF_table] = [_THISROW])
),
[note_datetime],
TRUE
),
1
)
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |