AnsweredAssumed Answered

Splitting Check Box field into multiple sub-records

Question asked by BrianKeller on Dec 22, 2015
Latest reply on Dec 22, 2015 by BowdenData

I am working on a project and need to be able to take the text within a checkbox field and create multiple records in a sub-table.  For example, when we have an issue it gets logged in Filemaker and the impacted departments are marked via checkboxes.  Sometimes issues impact 3 departments and sometimes they can impact all of our departments at the University (over 25). 


We know the checkboxes are just attached to a text field which is populated with the department name as they are checked.  We would like to read that field and populate a sub-table with one record for each department showing the outage day and time.  This data then is uploaded into a reporting tool which creates the charts and graphs we need that is reported to our Executives. 


Is there a way to read the checkbox field and create one record for each entry in it?


Thank you,


Brian Keller