perform sort on field change

[cricket]

hi,

i have a drop-down value list set with 5 values. i'd like to perform a sort automatically when someone chooses a different value from the drop-down list. is a script needed to do this or is there another method and how should it be applied?

my knowledge is basic for filemaker.

thanks!

[Fitch]

You will need both a script and a FileMaker plugin to do that. Have a look at zippScript.

[cricket]

well, i got it to work, however, by placing the zippScript code in the Validation calculation section for the drop-down list field, whenever i change the drop-down in browse mode it always brings up a dialog box that says

""fieldA" is defined to contain only specific values. Allow this value?"

How can I disable that? Shouldn't FileMaker know that I'm selecting the values from a drop-down list?

Or is there another area where I should be entering the zippScript code?

Thanks.

[Fitch]

You'd generally want to trigger zippScript using Auto-enter rather than Validation.

[cricket]

placing that code in the auto-enter calculation doesn't do anything.

maybe because there is nothing auto-entered since it's a drop-down list?

any ideas?

[Fitch]

Auto-entry does not only apply to new records. It can also happen when a field is modified, even the same field! The key is to auto-enter a calculated value, and then UNcheck the "do not replace" checkbox.

Look at the "trigger a script when exiting field" example in the zippScript example file. Look at the auto-entry options for FieldA.

[cricket]

that worked. thank you very much for your help!!

i don't use fm very often.

[Mark Reed]

Is there any way to do this without a plugin in version 10 or 11?

[Raybaudi]

Yes, use your triggers !

( OnObjectModify )