Check box set to Select All

[Achineche]

I'm trying to accomplish a script to select/unselect all my check boxes at once.

I have all months, sometimes I need to ckech just a few but some others I'll need to check the whole year and I'd preffer to check only one box than twelve, lol.

Any advice of how to do it?

Thank you.

[doughemi]

Remember a checkbox field is just text field with a return-separated list of the checked boxes. So to check all boxes, all you need to do is

Set Field[YourCheckboxField; "January¶February¶March¶April¶May¶June¶July¶August¶September¶October¶November¶December"]

To unselect all,

SetField[YourCheckboxField; ""]

[Achineche]

Thank you doughemi,

I'm working on that.

Set Field [ValueListItems ( Get ( FileName ) ; "Months" )]

But doesn't work, and I don't know what I'm doing wrong.

[mr_vodka]

Did you set your target field?

[Achineche]

Done it!!!!!!!

First didn't work well because my file name had an "unusual name?" (i.e. filename v.10.fp7). Curious, get (filename) worked well but valuelistitem didn't.

Set Field [ If ( IsEmpty ( TABLE::Field ) ; ValueListItems ( Get ( FileName ) ; "ValueListName" ) ; "" ).

Thanks for your help.

[Vaughan]

Actually, it's the Get( filename ) function that broke. It stops at the first period in the name.

[LaRetta]

And your last calc STILL doesn't show a field being set ...

There are two parts to a set field ... The field to set and then the calculation. :^)

[Achineche]

Sorry laretta, just simplyfied

Set Field [ table::field ; If ( IsEmpty ( TABLE::Field ) ; ValueListItems ( Get ( FileName ) ; "ValueListName" ) ; "" ).