Revert Record if field in portal equals a certain value

[Steve Martino]

Hello forum. 

What I am (hopefully) trying to accomplish is the following:

A user goes into a portal (Sessions) to enter (create) a new related record.  On the portal row is a field called 'Exercise' tied to a value list of available exercises.  The first line in the value list is "-Add New-".  If the user selects this, they are able to create a new exercise (via magic key).  All of this works fine.

However, if the user selects 'Cancel' in any of the script steps, they are able to later, commit the record with "-Add New-" as an entry in the Exercise field (on the portal). 

I would like to revert the record.

So I tried this script, which doesn't revert the record.  In the Data Viewer Watch tab I see the result "-Add New-", but in the script, it just skips over this step and commits the record.  I noticed the Data Viewer Current Tab shows the first portal record, which means even with the proper portal row field in focus, anything that could cause a commit is losing focus on the field.

The simple script:
 

If [FilterValues (List (SESSIONS::Exercise) ; "-Add New-" )]      
    Revert Record/Request [No dialog]
End If

Any thoughts or help are always appreciated

Thanks

Steve

FM Pro Adv 12

[comment]

13 minutes ago, Steve Martino said:

If [FilterValues (List (SESSIONS::Exercise) ; "-Add New-" )]

I believe that needs to be:

If [not IsEmpty ( FilterValues ( List ( SESSIONS::Exercise ) ; "-Add New-" ) )] 

if it's ever to return true. What you have returns either "-Add New-" or an empty string - and none of these will return true when converted to a Boolean.

--
P.S. I haven't followed your process that well - note that Revert Record will revert all uncommitted records.

 

 

 

[Steve Martino]

Thanks Comment (again, and again).  Yeah that worked!

In this instance, it's ok that all uncommitted records revert.

Thanks again

Steve