Thanks for sharing the xlsform. The root cause of this issue seems to be the webform and your schema. The webform appears to only be able to pass relevant and bind::esri:visible formulas from a question in a repeat table to a different repeat table, not the questions within a different repeat table. If you take the ${number_of_locations}='less_than_ten_locations' out of your “locations” repeat visible column, but leave it on the questions in the “locations” repeat you get the same behavior as you are getting in the attachments repeat.
You also get the same behavior with the relevant column trying to make questions from one repeat show/hide questions in a different one. HOWEVER, if you change your studyinfo repeat to a group, the relevant column will pass conditions to questions in the repeat tables using the webform interface.
It looks like where the Survey123 App can handle passing the visibility/relevance between questions in different tables, the webform cannot do this.
There’s a couple of ways to solve the problem and this is where you need to think about your schema. You can split out the questions required by one response into their own repeat and put a formula in the visible or relevant column for the repeat and get it to work. However, that is going to create more tables. Each repeat creates a related table in the feature service, and you have 4 already. The only data from the form going to the parent table is the additional_comments field. Managing related tables is a chore because as soon as your global and rel_global IDs don’t match your stuff won’t work.
I think you need to look at using some groups instead of repeats where possible. Repeats create related tables where groups serve to divide up questions in the form to manageable blocks. If your question only needs to be answered once on a form it shouldn’t be in a repeat. An example would be the name or email of the person filling out the form. Looking at you form, my interpretation is the data in the “studyinfo” repeat is only answered once for an instance of the form and should be a group. Then if there are less then 10 locations, the “locations” repeat would be filled out up to 10 times, so that should remain as a repeat (you should also put a limit on the number of repeats allowed so it will stop them at 10). And finally on to the “attachments” repeat. You’re using the multiline appearance for photos and files, which allow multiple pictures/files to be attached to one question without using a repeat table and the only other question is the link to the Google sheet, which seems to be a one time per form response as well. If that is true, then you should look at making it a group instead to simplify your life later on.
