Solved: Add a new row to another table with BEFORE & AFTER... - Page 2

Atlas · 09-02-2020 05:42 AM

Hi,
I am trying to make a simple changelog using and conditional action.
[_THISROW_BEFORE].[LOCATION] <> [_THISROW_AFTER].[LOCATION].

How can I achieve to add new and old locations to a changelog table?

Koichi_Tsuji

The data saved into column from the form is always “after” value.

I would suggest you will add new physical column to your table, calling “Previous value” and push expression of [_THISROW_AFTER].[LOCATION] as Appformula.

By doint so, whenever the row is edited, it will automatically capture the previous value as well as curernt (after) value in the LOCATION field.

Then pass values for those two column to add new rows to change log table.

View solution in original post

Add a new row to another table with BEFORE & AFTER values