Select to view content in your preferred language

Can you have a repeat inside a repeat?

207
3
a month ago
Casey_Ragain
New Contributor

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

Tags (1)
0 Kudos
3 Replies
jcarlson
MVP Esteemed Contributor

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 repeatRelated 1
begin repeatRelated 2
questions for nested repeat go here 
end repeat 
end repeat 
- Josh Carlson
Kendall County GIS
0 Kudos
Casey_Ragain
New Contributor

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

 

0 Kudos
jcarlson
MVP Esteemed Contributor

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

- Josh Carlson
Kendall County GIS
0 Kudos