Trigger scripts when scrolling through the database

[Koen]

Hello all,

It has been a long time since I have been programming on FileMaker.

At the moment I have a project to create a database for some financing.

The scroll function with the mouse wheel is great to check on my entered data, but I would like to trigger a script when FileMaker switches between the records during this scrolling option. (FileMaker has tot calculate some stuff before it shows the next record)

Is this possible?

And how?

Or is it possible to deactivate the mouse wheel scroll option.

Cheers

[bcooney]

"FileMaker has tot calculate some stuff before it shows the next record)"

Huh? Perhaps you could expand on this requirement, because typically, this would be satisfied with an unstored calc field.

[Vaughan]

I agree with bcooney: running a script each time a record is scrolled through is going to be hugely cpu and network intensive. There had better be a really compelling reason for it.

There are triggers to run scripts when they are loaded (i.e., become active) but not when simply scrolled through in a list view. Conditional formatting is updated when a record becomes visible in a list view and that has caused serious performance issues with FM 12.

[Koen]

Hmm, ok,

Well its a payment system build up in terms.

When all the bills have been made for a term, I want to block the entries of the fields of that term, but you can see them in an overview.

So lets say that term 1 through 3 has been billed.

So I made a layout that term 1 through 3 is blocked and the 4th to 9th are open to edit.

It sometimes happens when a term is created that I have to add one bill to the last term that is made. in this case term 3.

(this happens just by overlooking a person)

So I create a new person to fill out the data, but when the database looks if term 3 is already been billed, and I can not edit this term anymore.

So I let FM look if the billing number for that person is created in that term (in this case 3), if not, the person in the term is editable.

And when scrolling through the data, I would like to make FM have a quick look if the billing number is created for a term and switches to the layout of the right term. (each layout blocks a term, in total 9 layouts)

Or can I block entry in fields with conditional formatting?

And i'm not concerned about the band with in a network. Not using this in a network, only on a local computer.

Cheers

Koen

[Echo33029]

I am not sure that Koen is saying that he/she is scrolling through a list view, just that he is using the scroll wheel to switch from record to record. In that case the OnRecordLoad script trigger should be the feature that he needs to use.

[Fitch]

To prevent record navigation via scrollwheel, use the script step Show/Hide Status Area, and specify Hide and Lock.

[Koen]

I am not sure that Koen is saying that he/she is scrolling through a list view, just that he is using the scroll wheel to switch from record to record. In that case the OnRecordLoad script trigger should be the feature that he needs to use.

Indeed the user is using the scroller wheel to switch from record to record.

I have tried the OnRecordLoad script trigger, and minimized my script and it runs smoothly.

And indeed FM12 is much slower in this case, but I have created and it is used in FM11

Anyone know why?

To prevent record navigation via scrollwheel, use the script step Show/Hide Status Area, and specify Hide and Lock.

Should I run this command as startup script if I want to use it?

Cheers

Koen

[Lee Smith]

And indeed FM12 is much slower in this case, but I have created and it is used in FM11

Anyone know why?

A recent update to Version 12 has supposedly fixed this?

Should I run this command as startup script if I want to use it?

That would be one way to handle it. You could also use a OnLayoutEnter script trigger, if it is only one view or layout you are concerned with. That is assuming you are using a version that has script triggers,

Please update your profile to reflect your FileMaker and OS information. Use this Quick Link and it should only take you a minute.

Lee