Perhaps this popst can help. Since you are on FM7 and dont have script variables, you will have to use a global field instead. Everywhere I refer to $k should refer to the global number field.
I confirm this bug.
Repeating fields which are empty cannot be searched.
None of the following terms works to LIMIT results to the repeating field into which it is entered:
How was this overlooked? :smileysad:
There's no bug here: a repeating field is ONE field - at least for the purpose of finding.
Well, this is not a perfect solution by any means, but it will get you what you need. It works as long as you don't mind building in some otherwise unnecessary overhead fields into your solution...
But, I get ahead of myself!
You will need to create 10 new calculation fields in your solution: cRepeat_field_value1 through cRepeat_field_value10. The first iteration should be the following calc:
GetRepetition ( Repeat_field ; 1 )
Iterate the number at the end of the calc from 1 to 10 for the above cRepeat fields to catch the unique value in each respective repeat of your Repeat_field. Thereafter you can search on any of the ten individual calc fields and you will get the records you are looking for.
Try it out.
Of course, the field I call "Repeat_field" above should be the name of whatever your repeating field is!
Many thanks, Michael. I finally got around to trying your solution and god love you it worked a treat! It may not be an elegantly scripted solution, but for a pedestrian like me it was understandable and feasible. I generally never have more than about 12 iterations in a repeating field so the overheads don't really count. I can now easily locate all those students who have not submitted assignments. Thanks again.
Hey! It only took three months to get back to it, but in the end you did get back to it, and I'm glad it was worth it. Glad to help out.