I have a bot set up that is supposed to record in a 'Remarks' column when an item is reassigned from one person to another. The bot triggers on an data change event and the associated action is as below:
First off I receive an error in the expression when trying to set the value in the column under the action itself, however when I check the action settings in the bot, I do not get the expression error.
Secondly, this just records in the Remarks column the [Tech] info after it was saved.
Does an action flow not have the availability to access [_THISROW_BEFORE] and [_THISROW_AFTER]? Can this only be accomplished through reports and templates? Does anyone have a workaround for this?
Thank you.
I have to rely on experts on the question of the availability of before&after field values outside templates.
I can propose a not so pretty workaround if you would be interested based on bunch of actions.
You need a bunch of house cleaning to hide unnecessary action buttons (and some Form fields) but only show 3) to initiate a new assignment.
๐ Hope this will be useful..
Hi @Markus_Malessa , You seem to be concatenating the previous contents of the [Remarks] column. This means previous assigned to is available in the concatenated column. In such a case, may we know any specific reason that you cannot simply use "CONCATENATE([Remarks], "Reassigned to " , [Tech], " on ",TODAY())
You gave me another idea. Perhaps the Remarks col can be parsed to retrieve the previously assigned tech to construct a new string. It maybe tough/clumsy without Regex though.
Yes , correct @TeeSee1 , that is also worth trying. But I believe it does not serve much purpose of parsing again just for immediate next statement because the earlier value is anyway available close by, unless I am missing some point.
A similar requirement post thread below
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/User-Change-Audit-Trail/td-p/226324
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |