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?