_THISROW_BEFORE turnaround in an action

AppSheet AppSheet Q&A
1

Dear all,

I have a table with 2 columns [FIRST NAME] and [FAMILY NAME]

The users of my app often fill in the FIRST NAME in the FAMILY name column and vice versa.

I am looking for a way to switch the values of the two columns for some rows using an action however i understood from other community topics that _THISROW_BEFORE is not available inside actions. Indeed, I receive the error message: Unable to find column ‘_THISROW_BEFORE’

Do you have any turnaround idea of how I could achieve what I am looking for ?

Thank you

2

You don’t need to use it. You can just read the value from the “Family name” value to “First Name” column and the opposite with the “Set the values of some column in this row” action.