Hi! I need help, namely in my table each item has an assigned location. However, the location of this item can be changed by the application user.
I would like to save the history of changing this location, so I created two more columns “old location” and “older location”.
At the beginning, I tried the solution that I found here on the appsheet community, ie using an appformula for a column, eg “old location” [_THISROW_AFTER]. [location]. Unfortunately, this solution does not help me, because I have a workflow, now the bot (great solution), which after changing the location starts and changes the value of one more column in the same row, thus calls the appformula again and the value in location and old location becomes same
Is there any other way to solve this problem?
Thanks in advance for your help and your time!