Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Auto-enter calculation in IWP

Featured Replies

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:


Case(



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?

Thanks

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.