Calculation Command to Run on Field Text Chance

[zach20]

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

[Søren Dyhr]

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

[zach20]

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

Thanks,

Zach

Edited July 17, 2008 by Guest

[Søren Dyhr]

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

[zach20]

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