I have created an HTML form (not a Google Form) that populates a Google Sheet. The form has both text inpt and checkboxes (multiples of each.) On the Google Sheet, if a checkbox is checked on the form, it populates the cell in the Sheet as "On".
I am looking to create a Doc using markers to pull the data from the sheet to a printable form, but I need to have a checkmark present instead of the cell data. I suppose I could create additional columns and use an IF array for each instance of the "On" to create a checkmark in the adjacent column to display a checkmark, but I'm sure there's an easier way to do it with a script in the Doc but I have no idea where to start.
All help is greatly appreciated.