what is the value list used to format the field as checkboxes? (the one you set in Inspector)
Set Field ( myField ; ValueListItems(Get(FileName) ; myValueListName )
that pushes all values in the list as return delimited and the result will be all checkboxes checked
Set Field ( myField ; "" ) // clear all
p.s once all is set you can go back and uncheck just some of them and all is ok!!
Thanks for the information Beverly. The list is just that a value list with check boxes. I had to create 4 columns of check boxes and just hide the text on all but one of them to create the form I needed. I have several forms like this in our data base that we use on a daily basis. The "Select all" feature will be a great time saver. (I couldn't paste the whole form here because it said the pic was too big. Hope you can see it!
Once your value lists get long, it often works better to use other methods than a single field formatted to use check boxes.
Selection boxes that create/delete related records, for example can often record your data in a much more flexible format--especially if you need to develop reports that, for example count the number of records that selected each individual value.
Thanks for the reply, philmodjunk. The list I'm working with is just a check list of mechanical functions that our mechanics are required to complete when doing an inspection/repair on our rental equipment. They complete the form by hand and then someone in our office does the data entry on the computer so that the information is trackable for any given machine. The individual items on the lists have no other function other than being part of these list of duties but we have 4 lists that are over 50 entries each and have 4 parts (Passed, failed, repair, N/A). Normally most of the items pass and I was asked to make it so that they could click one button and have the whole column populate and then have it so that certain items could be unchecked if they did not pass. It would save the data entry person a lot of time.
I did noticed this was shared to Discussions, but I am going to go ahead and move this thread from the FileMaker Community Feedback Space, which is specifically for input on the Community itself, to the Discussions Space.
Can’t you just offer me a solution? I really don’t have time to waste “chatting” in discussion groups. This has become the most challenging part of using this program is getting good customer support.
beverly gave an explanation that seems to do exactly what you want. Attached is a sample file I made with her instruction.
philmodjunk seems to suggest you may want to tackle this feature from a different angle, rather than using a single-field checkbox.
I hope this information helps!
CheckBoxSelectAll.fmp12.zip 67.1 K
You were offered a solution in the very first response. Then I suggested a second possibility which you indicated did not appear needed for your particular setup.
Not much chatting there.
And posting in the correct location is key to getting maximum timely responses.
I really dislike check boxes for recording that sort of information for the following reasons:
(a) in a compact layout like the one you've displayed, finding the one you need to click is not always obvious, and
(b) the data is too easily altered by an accidental mouse click.
It's a situation where the pencil and paper paradigm is not so readily converted into a robust FileMaker layout.
I therefore believe that the reliability of your information will be improved if you can develop a chart of values with drop down lists which require more deliberative mouse actions. If you can include the workflow into the progressive reporting of each inspection, then I believe you could have a better system. I'll concede that's not easily achieved without a lot of redesign, but I HTH.
An approach which will let you tweak it for certain common configurations is to create a script that will enter each possible value in the designated field. Or perhaps each common value. Or perhaps different sets of values, depending on a parameter you can attach to a button. But here's an example of how it might work, based on a little tweak I just applied to my "Quotations" file. This is the result of running the script on the "Source" field:
And this is the script itself:
Scripting gives you finer-grained control over which boxes do or do not get checked, under circumstances that you can specify.
Hi to all who have replied
Thank you all for your suggestions to everyone else who has responded to my request, to which I still don't have an answer. I have four very simple forms that we print as blanks for the mechanics to fill out by hand. One alternative for us was to simply scan them as PDF files and save them in a folder away from the data base but that became very time consuming not to mention that after the mechanics were through with them they were wrinkled and covered with grease from working on the machines. I created this data base so that we could track movements of the equipment, track services that were performed on the machines and these inspection reports (which is the form I'm trying to figure out how to create the "select all" button for). The form itself and the information it contains is only used for this form. The list itself does not have any components that need to be searchable. It's simply a list of actions that were inspected on a given machine by the mechanic. Because of the length of the list, it would make it easier for me when I'm entering the data in the computer so that we can send copies that are nice & clean, unwrinkled, non greasy copies to customers who request them to be able to hit one button and have it populate all the check boxes in that one column.
Step by Step instructions would be awesome.
Can you refer me to a filemaker developer that can help me?
are you needing to just print out that which has been checked? if so, the underlying field is just a return delimited list of items that have been checked. it would be easy to change this to comma-separated or other formatting for print out.
p.s. you can search for developers: