Checkbox selections: how to separate 'checked' values on to individual value records
I have a form which collects location information using the iPad FMG app: 1) Site Location 2) Site Characteristics
Site characteristics are presented as a checkbox selection as values across the page - values are from another table - a user can select multiple values.
FMP saves the checked values as a list; is there any way I can create individual records from every checked value? Is this a FMP calculation after the data is imported from the FMG app or is it a FMG calculation?