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

Calculation Command to Run on Field Text Chance

Featured Replies

Good Morning,

Is there a function or command within a Calculation dialog box to check if text has been changed in a specific field? If so, what is the command?

Thanks,

Zach

You need an extra field which is a autoenter calc, with the update function turned on!

Something like:

Let([tt=Get ( CurrentTimeStamp );ts=fieldToMonitor];tt)

--sd

  • Author

Hello SD,

I'm not sure if you're familiar with zippScript or not, but what I'm trying to is have a script run every time the text is changed in a specific field.

I know how to use zippScript, but I'm still struggling with finding out whether text has been changed in a specific field or not.

Is there a method of doing it this way?

I'd normally just use a plain calculation for this, but it's a fairly complex script that a Calculation doesn't have the capacity to perform.

Sorry for not giving out all of this information at the start.

Edit: I was hoping to be able to figure it out for myself with my original question, but I guess I can't :P

Thanks,

Zach

Edited by Guest

I have used it once and awhile, but your question isn't clear enough to me at least!

However does it seem to be somewhat in the audit trail mysteries you're in, are you creating records for each change of a field or such.

Here is one of Ray Cologons:

http://www.nightwing.com.au/FileMaker/demos8/demo809.html

What it does is putting all tracking into a field, where you probably are putting this into records?

--sd

  • Author

Got it working!

Took me a couple minutes but once I tore up Ray's example I was able to adapt it into exactly what I was trying to do.

A big thanks to you SD and Ray for getting me through this!

Thanks!

Zach

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.