Solved: [Thisrow].[before] for a column in app - Page 2

gaixixon · 05-07-2020 07:36 PM

Hello. I have a ‘CUSTOMER’ table with a column named ‘CUSTOMER ID’ , ‘CUSTOMER NAME’.
I understand that I can get current row’s customer’s name by using [CUSTOMER NAME] expression.
My question is: When I edit a certain row, if I want to refer to initial value of ‘CUSTOMER NAME’ (the valued being stored in database, not currently editing value), what should I do?
p/s: I can get it by
SELECT(CUSTOMER[CUSTOMER NAME] , [CUSTOMER ID] = [_THIS].[CUSTOMER ID])
Is there any shorter, more elegant way to do? I tried [_THISROW].[CUSTOMER NAME] but it does not return the text from that column.

Steve

Not really. The most succinct way is like this:

LOOKUP(
  [_THISROW].[CUSTOMER ID],
  "CUSTOMER",
  "CUSTOMER ID",
  "CUSTOMER NAME"
)

View solution in original post