Filling multiple copies of checkbox based on field value
I have a mostly Y/N test that will fill in an answer sheet for scanning using checkboxes formatted as circles on the answer sheet.
There a couple of questions that require Y/N answers, then a value input into a text box. I use same form field names with diferent export values to auto fill the answer sheet.
Need a way to auto fill based on value of the text box:
Question 36 Y/N then QI36 text box enter value (0-9)
on answer sheet I have SFA36#0-SFA36#9 for the circled checkboxes export values of these are 0-9, respectively; to allow only one check box to be checked.
I would like the value entered in QI36 to auto fill the correct checkbox (fill the circle)
tried a couple data validations that i found in this forum, but none are cheching any boxes.
Please help.
