Jump to content

New to Filemaker Pro

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

Recommended Posts

  • Newbies

I have just started using FMP 7.0. The closet I have worked in is Access. Is there a way to mimic events in FMP 7.0? I was wanting to do an "Onchange" event. When a value changes in a field I want to recalculate the value in another field. Are the "Get" Functions the close as I can get?

Thanks for any help.

Bob Smyth

Link to comment
Share on other sites

There are no "events" at all.

An "on change" event can be simulated by a calculation field and a plugin, see details databasepros.com

type "Hidden Plug-ins" to see the page relating to this technique. I'm not sure if I can give you a direct link here

Also have a good look at this http://filemaker.advisor.com/doc/14267 which is an excelent article on the subject of migration from Access to FMP7.

There are also a few threads on this forum which address your problem directly

Link to comment
Share on other sites

Hi Bob,

As kraftyman pointed out, FM does not support events as part of it's programming model. It's a feature request that has been a hotly debated topic on these forums in the past. But I wonder if your desired goal of having changes to the value in one field force recalculation of the value in another isn't most easily addressed by just using a calculation field type for the latter, or (new to version 7) using an auto-enter calculation for the latter with the option "Do not replace existing value of field (if any)" unchecked. This forces the latter field to re-evaluate when any referenced field changes, but has some advantages (possibly not germane to your problem) over traditional calculation fields, such as the ability for the auto-enter calculation to reference the very field that is being "auto-entered," as well as the ability to validate the field using FM's standard validation options. Apologies if you were looking for something that goes beyond what calculation fields can accomplish; in that case I may have to leave it to other gurus on the forum to help.


Link to comment
Share on other sites

This topic is 7100 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.