Hello, I am currently working on generating a custom answer sheet using the CustomAnswerSheet with JSON Markup element in your system, and I’ve encountered an issue with assigning unique identifiers to rows across multiple columns.
Context:
I need to create an answer sheet with 5 columns, each referring to a different group of questions (A, B, C, D, and E). Each group contains 12 questions, such as A1, A2, …, A12 for group A, and similarly for the other groups.
The Problem:
The issue arises with the uniqueness of the row IDs. I am using the %index%
variable to assign IDs to each row. While the index resets correctly within each column, it is not providing unique values across all columns. For example:
- In column A, I have rows labeled as A1, A2, …, A12.
- In column B, I have rows labeled as B1, B2, …, B12.
However, since %index%
resets in each column, the values are not unique across the whole answer sheet. For example, I end up with multiple rows labeled “1” (e.g., A1, B1, C1, etc.), which causes issues with uniqueness and data processing.
Desired Behavior:
I would like the system to allow for the following behavior:
- The ability to reset the index within each group (A, B, C, D, E) while ensuring that the IDs remain unique across all columns.
- Ideally, each row could have a distinct identifier such as A1, B1, C1, etc., while still maintaining internal uniqueness for each group (in the OMR pattern we only see the %index% value and not “Row %index%”.
I’ve tried several configurations but haven’t been able to achieve the desired result. Could you kindly advise on how I can ensure unique row IDs across all columns, or whether there is a workaround available to achieve this?
I appreciate your time and assistance with this matter and look forward to your guidance