AnsweredAssumed Answered

Transferring Data into a Checkbox Set

Question asked by northshots on Apr 14, 2009
Latest reply on Apr 15, 2009 by northshots


Transferring Data into a Checkbox Set


Hello, I'm new to FileMaker and I'm just trying to get my head around one or two things whilst importing data from an Excel spreadsheet.


On the spreadsheet were four columns specifying which mailing list a contact was subscribed to.  A "1" was entered into the appropriate field to indicate that a contact was subscribed to a particular mailing list.  In my new FileMaker database a Checkbox Set seems to be a much better way of holding this data, however I currently have the imported data in separate fields which I somehow need to transfer into my new Checkbox Set which has the option of the four mailing lists.


The problem is I have over 3000 subscribers and don't really relish the thought of having to click a checkbox for each one.  Is there some way (perhaps a script?) that I specify that if a field has a "1" in it then a checkbox should be checked? 


Sorry if I haven't made myself clear, please just ask!