Newbies dandesanto Posted November 13, 2007 Newbies Share Posted November 13, 2007 Hello, I'm a beginner with FileMaker and I have been trying to figure out how to write a particular Script for almost 3 days now. I need the Script to search a column of my records, count all the instances of the number 1, and insert the result into a layout (with summary fields), THEN search the same column for instances of the number 2, insert that result into the next summary field, etc. etc for the numbers 3 and 4. "Perform Find" and "Insert calculated result" work when I only tell it to look for look for #1s, but as soon as I tell it go back and look for the #2s, #3s, and #4s, it seems to erase the results of the previous find and I end up with the result of the final find (#4s) in all four summary fields. How do I tell FileMaker to RETAIN the calculated result in the appropriate summary field when I have it do multiple finds? I've tried "Go To Next Field," "Go to Field," as breaks...I've even tried setting up each find as a separate script and then having one "Master Script" run the smaller scripts. Nothing has worked. Any help would be GREATLY appreciated!!! Link to comment Share on other sites More sharing options...
sbg2 Posted November 13, 2007 Share Posted November 13, 2007 You want a report to show these values. See http://fmforums.com/forum/showpost.php?post/259708/ for an example. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6136 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 accountSign in
Already have an account? Sign in here.
Sign In Now