April 14, 200817 yr 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!
April 14, 200817 yr You will need both a script and a FileMaker plugin to do that. Have a look at zippScript.
April 14, 200817 yr Author 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.
April 14, 200817 yr You'd generally want to trigger zippScript using Auto-enter rather than Validation.
April 14, 200817 yr Author 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?
April 14, 200817 yr 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.
April 14, 200817 yr Author that worked. thank you very much for your help!! i don't use fm very often.
Create an account or sign in to comment