I’m not sure if this should be a Question or a Feature Request. I’ll start as a question, feel free to move as needed.
I was working on some expressions that validate aggregated amounts using pre-calculated values from another table. I was struggling with changes to these Amounts when Editing the row. But then I remembered some Community announcement about enhanced capabilities for the [_THISROW_BEFORE] and [_THISROW_AFTER] variables.
Unfortuantely, I couldn’t quickly find much in details about the enhancements and there wasn’t any support article that I could see.
I would like to request that a support article be created that describes the [_THISROW_BEFORE] and [_THISROW_AFTER] variables, where and how they can be used. It might as well also include comparisons with [_THISROW].
Is this a new row?/Does this row already exist? Is this a new row? NOT(IN([_ROWNUMBER], My Table[_ROWNUMBER])) or: ISBLANK( FILTER( “My Table”, ([_ROWNUMBER] = [_THISROW].[_ROWNUMBER]) ) ) Does this row already exist? IN([_ROWNUMBER], My Table[_ROWNUMBER]) or: ISNOTBLANK( FILTER( “My Table”, ([_ROWNUMBER] = [_THISROW].[_ROWNUMBER]) ) ) In the above, replace My Table with the name of the table about which you’re inquiring. When modifying rows, such as in forms or wi…
Recent releases and updates: Detail view with customizable header The header of the detail view can now be treated like a card view. _THISROW_BEFORE enabled in Action conditions This update expands to action condition. It was already available in previous expressions. Bug fix for notifications in white label apps
[Release notes: March 1, 2021](https://community.appsheet.com/t/release-notes-march-1-2021/41223) Feature Release Notes
Deployment Time: 1:05 PM PST Features and Enhancements Item Description Feature Errors and warnings for automation process steps are now highlighted in the process graph. Feature You are now able to use _THISROW_BEFORE and _THISROW_AFTER expressions in Automation Tasks if the event is generated within the Application. Deployed to all. Bug Fixes Item Description Bug Only Replace Carriag…
Thanks! This was what I was looking for. However a search from the main support screen of _THISROW_BEFORE or _THISROW_AFTER does not turn up any pages with those included. I guess they have not been indexed? Is that something someone can do to get them added to support Searching?
I would have never thought to look by “Before and After Values”.
Also, I don’t seen any references to capabilities if using these variables within column expressions such as Valid_If. But it seems they are recognized in that context as well. Maybe I just missed the mention about it? Maybe it’s been available all this time and I just didn’t know? (Though I am fairly certain I did try using them in the past and would get errors. I built a whole mechanism to “remember” and apply edited differences)
If not, this needs to be included. It is a major breakthrough in dealing with editing of columns for adjustments of the difference or validation against limits.
Ahhh, I see. If I click on one of those pages from my screenshot above and use the search bar at the top, then I get the results like you did. I think it even more odd that searching from the “main” screen doesn’t give at least similar results as from one of the pages.
