Building Related Table/Field & Terminology

251
1
Jump to solution
02-14-2023 12:12 PM
RichardPasquale
New Contributor III

Trying to setup an xls form. I've been told I'm trying to build a "Related Table" yet, when I research related table or field in the community I'm not seeing anything helpful.

We would like the user to respond to a survey question with a numerical value 0-99 of how many (things) are present.
Then Based on the above response value, the form will then ask a set group of question X (0-99) number of time.
I'm familiar with and ability to have the user complete a group of responses and "choose" to add additional group responses "REPEAT". The idea here is to get the user to acknowledge total number first and then have the survey insure they collect the data for each.

 

Is this a related table.? Can the xls work this? 

0 Kudos
1 Solution

Accepted Solutions
ZacharySutherby
Esri Regular Contributor

Hello @RichardPasquale

Survey123 repeats are modeled in ArcGIS as related tables (or related layers if your repeat includes a geopointgeoshape or geotrace question). You can use the numerical value entered as the repeat count and that will constrain the user to only add X number of repeats (or related records) 

Please see this blog for more information: https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-repeats/ba-p/89804...

Thank you,
Zach

View solution in original post

1 Reply
ZacharySutherby
Esri Regular Contributor

Hello @RichardPasquale

Survey123 repeats are modeled in ArcGIS as related tables (or related layers if your repeat includes a geopointgeoshape or geotrace question). You can use the numerical value entered as the repeat count and that will constrain the user to only add X number of repeats (or related records) 

Please see this blog for more information: https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-repeats/ba-p/89804...

Thank you,
Zach