Latest Contributions by JayH

Hello all,  This may be a silly question - Should I uninstall the existing Survey123 Connect before installing the new version? I kind of expected something similar to Pro - updating will be done while preserving all exciting data and folder structures, but I got an error while trying to overwrite the existing Survey123 folder. Cheers,  ... View more

Hello all,  One of my survey seems showing unexpected behavior.  In the survey, users will choose project type and then relevant questions will be shown and saved under a related table. So if I choose Project B in my first survey and work on some questions, I expect to see  '(0)' other than Project B column as no related tables are created for Project A, C, D and E. However, as shown the image below, all of them are filled with (1). If I click (1) show under ProjectB, there are questions and answers I typed in. But if I open the rest, they are all empty record. I tried multiple entries, and no matter I choose, there are empty row created in every related table.  This is schema preview. User will choose only 1 project in each survey. Project (select project) ----ProjectA ----ProjectB ----ProjectC ----ProjectD ----ProjectE ... View more

Hello all,  I am working on field sampling survey on species, and it looks like there will be a few hundreds choice options for some select_one questions. I expect the lengthy choice lists may slowdown the loading speed of the survey, but not sure if there is actually any limit on the number of choices.  Also is there any way to connect database table to pull out the possible choice list rather than add each item on choices sheet? Cheers,  ... View more

Hello all,  I have some issues with getting URL of the attachment from my survey. I assume that I should grab URL item under attachmentInfo > Name for my attachment, but it shows attachmentInfo as collection, and cannot expand any further. I think this is because that my image/file items are under 'repeat'. In reality, this repeat is allowed only one time (I set '1' for repeat_count attribute). I used repeat just to create a separated related table, not actual repeating. Are there any methods that I can still get url for the attached file/images? Cheers, ... View more

Hello all,  Is there any ways that I can label my repeat-bars (not sure how to call them)?  I have nested repeats, and not having label may make users confused or make some errors accidentally. It would be great if I can label them based on 'repeat name', or at lease make different colors for each repeat?? ... View more