I would like to put a kind of option like " mark all the options" and all checkbox are marked. How can I do it?
If all your check boxes represent a single field with a value list, a button can perform this script step:
Set Field [YourTable::YourCheckBoxField ; ValueListItems ( "" ; "ValueLIstNameGoesHereInQuotes" ) ]
Set Field [ YourTable::YourField ; List ( "Value1" ; "Value2" ; "etc.." ) ]
Or more dynamically:
Set Field [ YourTable::YourField ; ValueListItems( Get(FileName) ; "YourValueListName" ) ]
The "ValueListItems" function is amazing. It is these little-known functions that are so powerful and used in great ways. That should be a devCon session: The Little-known functions that pack a big punch!"
I only started using this function a year or so ago. Seems to be hidden in there.
Tim Neudecker (kyologic) ran a panel for (last two years?) devcon in the past that was exactly this, a roundup of filemaker functions and how to use them. I still use his demo file for our usergroup whenever I give a “function of the day” presentation.
After reading the replies I was inspired to consider using their ideas in the initial calculation when creating a new record. Then all checkboxes start as checked with the user able to uncheck them.
Like most software defaults:
X Copy all your address book
X Send you advertising
X Charge your credit card each month
X Share your personal information with my clients
X Read all your files
Your suggestion worked very well!
I verified the others ideas, but it didn't work with me.
Thank you all for the help!
The others are variations of the same basic approach and should also have worked.
I used to use ValueListItems ( get ( FileName ) ....
All the time until someone here suggested using: ValueListItems ( "" ; which is even simpler and avoided an issue that occurs when there's an extra "." in the file name (might not be an issue in the latest version(s).)
Mike's other suggestion using the list function also works, but doesn't update automatically if someone changes what values are in the value list.
Retrieving data ...