[_THISROW_BEFORE] & [_THISROW_AFTER] in Action Condition

[Fabian_Weller]

In a Form I have a Form Saved Event Action "App: go to anotherview within this app" with LINKTOFORM().
This Action should only fire, when [Column1] changes.

So I thought, in the Action condition I could use:
[_THISROW_BEFORE].[Column1]<>[_THISROW_AFTER].[Column1]

But then the Action would not fire at all.
I suspect that it would not work because: When change [Column1] and save the form, the LINKTOFORM() Action can not understand what the [_THISROW_BEFORE].[Column1] was.

Am I right? Is there any other solution?

[Steve]

As I understand it, the Form Saved action is performed immediately after the save happens. By then, the original column value is already gone. You’ll have to trigger the navigation some other way.

[Fabian_Weller]

Thank you @Steve.

I tried also the solution from @Heru using a VC, but this seems to be the same behavior.

Release notes: 7/14/20 Feature Release Notes

Based on my testing, to make it work for action condition,I need to have a VC with expression something like: [_THISROW_BEFORE].[Products]=[_THISROW].[Products] and make the action condition if the [VC]=TRUE It seems working since the action can only be called after background sync is completed.

So I think I would have to use a ChangeCounter, that will Reset on edit.

[Koichi_Tsuji]

Try to store before value in physical column like what I mentioned in other post.

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

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.

[Fabian_Weller]

Thank you @tsuji_koichi. I see that I have to add an extra column. I was hoping to avoid this

[Koichi_Tsuji]

Should not be a big deal !!

[Fabian_Weller]

I have a daily limit of 10 columns