_THISROW needed when passing arguments

Erik_Ferm
Participant IV

This is not a big problem but I thought I wold mention it in case it saves someone else a few minutes:

In a process assigned to a table, if you call another process and want to select or populate a row, the LOOKUP() function requires you to specify [_THISROW] to refer to records in the table the calling process is assigned to.

So if a process is assigned to the table orders and I want to call a process and specify a row in the tables customers, the formula to find the record id would need to be something like

id = LOOKUP( [_THISROW].[email], โ€œcustomersโ€, โ€œemailโ€, โ€œidโ€)

This is different from a virtual column in the table orders where the formula would find the customer record without [_THISROW]

Not a big deal if you are aware of it.

0 1 120
1 REPLY 1

Steve
Participant V

Top Labels in this Space