Ah, ok, I tend to structure my forms in a small number of field-list groups so didn't think about a >500 'page' form.
Options that I can think of in increasing order of effort/pain
- Do you currently use images for any of your questions - if not you could put the
image(mock trigger button) &big-image(mock PNG) filenames against every question (copy/paste down the columns? Ref - Do your enumerators have data connectivity - could you use markdown at the end of every question label (or in the hint) to link to a mock PDF/image? (build the strings as excel formula.) Ref
- If having >500 groups doesn't cause issues processing your data, could you generate a form with a group for every question? Either by scripting or by some excel row counting and lookups?
This is a quick example of using sheet row number to identify the required type or survey question, assumes one question per screen. Could be done more nicely outside of excel.
ODK_Group-generator.xlsx (15.2 KB)