Jump to content

Auto-enter calculation in IWP

This topic is 4333 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm using an auto-enter calculation (replaces existing value) to create an audit trail of particular fields. It's a fairly common script I believe (originally by a company called Database Pros). My version looks like this:


PatternCount("Request Approval Status"; Get(ActiveFieldName)); //Enter the fields you want to track

GetAsText(Get(CurrentDate)) & " | " & 

GetAsText(Get(CurrentTime)) & " | " & 

If ( Commissioning Party::_gAccount = "" ; Get(AccountName) ; Accounts::_gAccount ) & " | " & 

Get(ActiveFieldName) & " = " &

Case(Get(ActiveFieldName) = "Request Approval Status"; Request Approval Status; )  & 

Case(not IsEmpty(Audit Request Approval Status); "¶") & Audit Request Approval Status;

Audit Request Approval Status //In case you modify the Log field, the default prevents the contents from being removed


Works fine in FM client. But it does not seem to update in IWP after the record is committed.

I have more complex versions of this which tracks more than one field within the same audit field, and when a field has a value entered into it for the very first time it will store the value in the audit log from IWP, but only for the first field out of the fields tracked. In other words, if the auto-enter calculation audit field is tracking 5 fields, and I put a different value into each of the 5 fields from IWP and commit the record, only the first field gets an audit log.

Does anyone know why this might be happening, or if it is possible to manually fire of the auto-enter calculation from IWP?


Link to comment
Share on other sites

This topic is 4333 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.