The Check Box "FoundSet"

[Agnès]

Hello,

I never paid attention to this CheckBox. ( script action : Send Mail )

Now that I discovered and tested, I do not understand why FileMaker does not give us this option natively in ValuesLists ?

Natively, when you check this box, you get the list of email address (or ... other !) in the mail software...

I added a calculation to show.

This file "FoundSet_test.fp7.zip" is just to demonstrate that the CheckBox "collect foundSet" is in FileMaker

Technically, I do not understand why FileMaker does not offer this feature, Function or CheckBox from the moment that has long existed. (this option is ok in FM6....)

It would be sufficient to move the CheckBox .... and we would finally be able to list a found set without using "tricks"

I would question it can make things happen ... ?

Agnès

[comment]

Hi, Agnès

Interesting observation. I have often wondered why List() is the only agreggate function that does not have a corresponding option when defining a summary field.

Could you please explain what is the advantage in doing:

Set Error Capture [ On ] 

Set Variable [ $ite; Value:1 ] 

Send Mail [ Send via SMTP Server; To: Let ([ 

$n = $n + 1 ; 

$ite = $ite + ( Mod ( $n ; 750 ) = 0 ) ; 

$Collect[$ite] = Case ( $n <> 1 ; $Collect[$ite] & ¶ ) & FoundSet::ID 

]; "" ) 

(collect addresses); Port: 25; Authentication Type: None ] [ No dialog ] 

# 

Loop 

Set Variable [ $loop; Value:$loop + 1 ] 

Set Variable [ $FoundSet; Value:$FoundSet  & $Collect[$loop] ] 

Exit Loop If [ $loop ≥ $ite ] 

End Loop 

Set Field [ FoundSet::gResult; $FoundSet ]

 



instead of just:

Set Error Capture [ On ] 

Send Mail [ Send via SMTP Server; To: Let ( $v = List ( $v ; FoundSet::ID ) ; "" ) 

(collect addresses); Port: 25; Authentication Type: None ] [ No dialog ] 

Set Field [ FoundSet::gResult; $v ] 

---

BTW, since this runs within a script, it is not possible to conclude with certainty that it uses a calculation - it could be simply looping through the found set.

[Agnès]

Thank you for your interest,

Difference is timing. Filemaker is very very slow if there are a global or a $ $$variable with lots of line.

with a large file, comparing the method 1 (explosion into smaller lots, method given a demonstration by Bruce Robertson))

10000 records = list obtained in 1 second

20000 records = list obtained in 2 seconds

but with List ( $v ; FoundSet::ID )

10000 records = list obtained in 9 second

20000 records = list obtained in 54 seconds

the performance difference is very large

case : 27 ExtendVariable[n] with 750 lines vs 20000 lines in one variable

BTW, since this runs within a script, it is not possible to conclude with certainty that it uses a calculation - it could be simply looping through the found set.

But looping take time. I have just conclude is easier for FileMaker to give us a simple solution for collect FoundSet'ID's.... (?)

Agnès