Select all in current view in Filemaker Pro 12

Question

I have a Filemaker Pro 12 database that I can sort and export selections using check boxes, I have a script to "Select none" and remove all the ticked items, but I would like to be able to search and then check all the results.

I have a button on the checkbox image that performs a Set field and the following:

Case (
 ValueCount ( FilterValues ( Table::Checkbox ; Table::ID ) ) > 0;
 Substitute ( Table::Checkbox ; Table::ID & ¶ ; "" ) ;
 Table::Checkbox & Table::ID & ¶

)

Conditional formatting of the checkbox is:

not ValueCount ( FilterValues ( Table::Checkbox ; Table::ID ) ) > 0

The script for "Select none" is:

Set Field [Table::Checkbox; ""]

So what would the "Select all" script need to be?

Answer 1

There are quite a few methods to collect values across a found set into a return-delimited list. Looping is fine if your found set is fairly small; otherwise it may prove too slow.

Since your target is a global field anyway, you could use a simple:

Replace Field Contents [ No dialog; Table::gCheckbox; List ( Table::gCheckbox ; Table::ID ) ]

This will append the current found-set's values to the existing list. To start anew, begin your script by:

Set Field [ Table::gCheckbox; "" ]

Note:
In version 13, you can use the new summary field option of "List".

Caveat:
Make sure you have a backup while you experiment with Replace Field Contents[]; there is no undo.