pixi Posted September 9, 2014 Share Posted September 9, 2014 hi all, lately i was wondering what's the best way to determine records which are completely empty!? a customers data has to be verified prior to import and, amongst others, the empty records have to be removed upfront. i can't add a calc field so the finding has to be done via script. or…? enclosed my attempt. anyone with a better idea? thanks in advance egbert p.s. YES, i know that an id should be mandatory but i have to work on the data as is… p.p.s some of you aren't in the FDC so i thought i post the question here too… Empty_Records.fmp12.zip Link to comment Share on other sites More sharing options...
Wim Decorte Posted September 9, 2014 Share Posted September 9, 2014 The idea is solid. I would test a scripted loop through the fields vs the recursive function call, just to see what the speed difference is. You don't have to keep repeating the call the FileMaker_Fields table, do it once upfront. The fields don't change for each iteration. Breaking down the calculation into its functional elements is also a lot easier to troubleshoot and maintain. Link to comment Share on other sites More sharing options...
pixi Posted September 9, 2014 Author Share Posted September 9, 2014 changed the first script and added a "Find"-way to compare. the latter is WAY faster… Empty_Records_v2.fmp12.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3533 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