topic Can you have a repeat inside a repeat? in ArcGIS Survey123 Questions

Can you have a repeat inside a repeat?

Casey_Ragain — Thu, 23 May 2024 20:29:25 GMT

Hello,

I've run out of ideas and I'm hoping someone might help me understand if what I am trying to do is feasible.

1. I have authored and published an on-premise feature service with existing data and a relate table attached through a relationship class to the feature service.

2. I have taken the on-premise feature service and created a new URL in my agency's ArcGIS Online subscription and shared the new item with the appropriate ArcGIS Online group.

3. In Survey123 Connect, I created a form based solely on the attribute fields in the relate table. I wanted all the edits and its submission to go straight into the relate table and not the parent layer.

To create survey123 data in the relate table without creating a new record in the parent layer, I changed the form ID reference from the parent layer to the relate table:

Casey_Ragain_0-1716494506065.png

and removed any reference to the relate table, at the beginning and end, in the survey123 XLS survey tab:

Casey_Ragain_1-1716494729837.png

This setup seems to work great for creating relate records to an existing record in the parent layer without creating a new record in the parent when submitting the form in survey123.

Here's my question...

Can I add, or how do I add, a repeat to this survey123 form?

Since I created this form from an existing feature service and a relate table on my agency's GIS server and database infrastructure...do I have to create a new table and make another relationship class to the parent layer?

If so, how do I nest a relate table (a repeat) within a relate table (a repeat) in the survey123 xls and address the form settings form id? Can a form id reference two relate tables.

Thank you in advance!

-Casey

Re: Can you have a repeat inside a repeat?

jcarlson — Thu, 23 May 2024 20:48:08 GMT

You guessed it:

do I have to create a new table and make another relationship class to the parent layer?

So your layers would look like Parent → Related 1 → Related 2.

In the XLSX file, it's as simple as literally putting the one repeat inside the other.

begin repeat	Related 1
begin repeat	Related 2
questions for nested repeat go here
end repeat
end repeat

Re: Can you have a repeat inside a repeat?

Casey_Ragain — Thu, 23 May 2024 22:24:16 GMT

Hi Josh,

Thank you! That makes sense.

What about the form ID name in the Settings tab when you have two relate tables in one form? Can you put down both table names?

Thanks,

Casey

Re: Can you have a repeat inside a repeat?

jcarlson — Fri, 24 May 2024 00:56:50 GMT

I think it would just be the name of the parent table, you don't have to list the related tables.