Script to filter unnecessary records

Discussion created by kwrigh on May 29, 2012
Latest reply on May 29, 2012 by Stephen Huston

I have a group of people that submit information in excel format. I am creating a common report from these files.


The fields are all common however, the record fields vary quite a bit. The first field has 6 valid IDs that I need for a final report. I want to write a script to eliminate all the unnecessary records, but there is no common theme (blank cells etc.) Everyone does theirs different. The only commonality is the valid fields. I assume that I need to create a variable for those valid entries and then eliminate everything that is not valid. I have been attempting to do that, but have not had a lot of luck. I realize this is Filemaker 101, but does someone have a sample script they could share with me to show me how to do this?


Thanks in advance!