Sign in to follow this  
Followers 0
Agnès

The Check Box "FoundSet"

3 posts in this topic

Hello,

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

Image 7.png

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0