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.
Juggernaut

Featured Replies

I have a calculation that tracks changes made to certain fields. I want to have a delay built into the calc that allows the person creating the record 5 minutes to complete the first version of the record. The calc see's any edit to these fields as changes, even the very first entry. So I would like to have an If statement that says:

If ("Time In" + 5 minutes > Current Time; execute calc; otherwise leave the revision list blank).

Any ideas?

Let's assume your Revision History field is called RevHistory. You also need a field CreationTimeStamp that autoenters the creation timestamp, and ModificationTimestamp that autoenters the modification timestamp.

Then you can set up the RevHistory field as an autoenter -always evaluate- using a case function like so:

Case(ModificationTimestamp - CreationTimestamp > 300;

<>;

RevHistory)

Whenever a change is made to the record, it will execute, but if the modification timestamp is less than 300 seconds (5 minutes) after the record was created, then the result is just the current value of the RevHistory field, which is what you want.

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.