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

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.

changed the first script and added a "Find"-way to compare.

the latter is WAY faster…

 

Empty_Records_v2.fmp12.zip