wenzelj Posted April 23, 2004 Share Posted April 23, 2004 I have a db that has names, comments and a status for each. Looking to run a script that will ommit the records that do not have any info in the comments or status fields. help would be great FileMaker Version: 5 Platform: Windows 95/98 Link to comment Share on other sites More sharing options...
Damocles Posted April 23, 2004 Share Posted April 23, 2004 Good morning, This was made using FM6, but it should work fine for you. Here are two methods.... One loops through all your records and omits any that have a blank in either field. The other finds all records with either field blank, then shows the ommitted records. I'm not sure which is faster, since I only created 6 records, but I suspect that the "find and omit" will be faster for large numbers of records. Let me now if this is not the solution you need, or if I misunderstood the question. Paul FileMaker Version: 6 Platform: Windows XP Omit Records with blanks.zip Link to comment Share on other sites More sharing options...
wenzelj Posted April 23, 2004 Author Share Posted April 23, 2004 is there anyway that you can allow me access to see the script steps or how to put it in my db. the script seems to do what I need it for but there is no way to get access to it. thanks. Link to comment Share on other sites More sharing options...
Damocles Posted April 23, 2004 Share Posted April 23, 2004 This should do it. Here are pictures of the scripts, and I re-inserted the FM file. Check again to see if you have access to the scripts. (Ignore Layout #3 and any reference to "Serial". I'm playing with this file.) Paul Omit Records with blanks.zip Link to comment Share on other sites More sharing options...
wenzelj Posted April 23, 2004 Author Share Posted April 23, 2004 I cant seem to find the [exit after last,next] part for the end of the loop. Right now the script continues to run until I esc. I'm using fm pro 5.5 v1 so i dont know if it isnt present in the version or what? any suggestions? FileMaker Version: 5 Link to comment Share on other sites More sharing options...
wenzelj Posted April 23, 2004 Author Share Posted April 23, 2004 sorry about the last post. Missed the check box. thanks for everything Link to comment Share on other sites More sharing options...
Damocles Posted April 23, 2004 Share Posted April 23, 2004 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7307 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