topic Re: Display repeats together as a table in ArcGIS Survey123 Questions

Display repeats together as a table

GarethBaker1 — Thu, 13 Jan 2022 12:08:29 GMT

I'm just trying to work out if it is possible in Survey123 Connect 3.13 to set the appearance for a repeat so that all the records are shown on the survey form at one time. Intended use is the field client on an iPad.

I've set up a repeat with a fixed grid appearance for manhole inspections which looks as I want it to. However the default behaviour when entering multiple records is for each one to be accessed via the arrows underneath the questions.

Is there are way to make each record appear below each other i.e. like a spreadsheet/paper form/database table, so that the user has a better visual indication of their progress and can easily jump back to a previous record if it needs adjusting?

In our case they could be inspecting up to 300 manholes as part of the overall survey so I think it would quite fiddly to have to use the arrow buttons to scroll through records to find and check a particular record.

Re: Display repeats together as a table

DougBrowning — Thu, 13 Jan 2022 14:21:59 GMT

No not yet please upvote these ideas.

https://community.esri.com/t5/arcgis-survey123-ideas/table-view-for-repeats/idi-p/938544

https://community.esri.com/t5/arcgis-survey123-ideas/tally-sheet-format-for-repeats/idi-p/938975

https://community.esri.com/t5/arcgis-survey123-questions/a-datasheet-format-for-survey-with-repeat-entries/m-p/810778

https://community.esri.com/t5/arcgis-survey123-ideas/appearance-option-to-view-repeats-stacked-in/idi-p/947271

https://community.esri.com/t5/arcgis-survey123-ideas/fix-painful-repeat-navigation-issues-have/idi-p/941445

I use a summary page for the crew which helps.

thanks

Re: Display repeats together as a table

GarethBaker1 — Thu, 13 Jan 2022 14:26:48 GMT

Thanks Doug, have voted for all five ideas now. I did do quite a bit of searching before posting but my attention was clearly not drawn to any other those!

Re: Display repeats together as a table

Kanin — Thu, 13 Jan 2022 14:28:07 GMT

Hello,

I would suggest posting this into ArcGIS Ideas for Survey123 so that the community can "kudo" the idea as popular ideas tend to be considered by the development team.

ArcGIS Survey123 Ideas - Esri Community

Best regards,
Kanin

If this answer solved your question, please mark it as "Accept as Solution" to help others who have the same question.

Re: Display repeats together as a table

DougBrowning — Thu, 13 Jan 2022 14:37:38 GMT

Most of the links I posted are ArcGIS Ideas already. Some going back to 2017. thanks

Re: Display repeats together as a table

DougBrowning — Thu, 13 Jan 2022 14:41:34 GMT

I know the posts well as I have needed it for a long time. \

Also consider upvote of

https://community.esri.com/t5/arcgis-survey123-ideas/ui-to-move-to-any-repeat-for-survey123/idi-p/930713

thanks

Re: Display repeats together as a table

Katie_Clark — Thu, 13 Jan 2022 15:13:21 GMT

Thanks for all these links, @DougBrowning ! I also need this functionality for many of my surveys. Colleagues keep requesting it and I just have to keep saying... "It's in Esri's hands. People have been requesting it for years."

I made sure to follow all your links and upvote.

Re: Display repeats together as a table

DataOfficer — Thu, 13 Jan 2022 15:21:28 GMT

I echo that sentiment. Many of our users would love this sort of functionality and it is certainly something we are asked for regularly given users are used to a table/row approach based on previous use of spreadsheets or paper forms.

Re: Display repeats together as a table

MohammadTawbi — Tue, 25 Oct 2022 05:53:47 GMT

can I have an XLS file showing the calculation of this function?

Re: Display repeats together as a table

SuddhaGraves1 — Mon, 16 Jan 2023 15:39:31 GMT

Hi Doug,

How do you create the summary page displaying all the related records?

Re: Display repeats together as a table

DougBrowning — Tue, 17 Jan 2023 15:19:55 GMT

I use Grid theme then summary fields using Join, Max, Sum, Count etc.

Re: Display repeats together as a table

Bgiordano — Tue, 23 Jan 2024 18:01:28 GMT

Could you please share the excel file?

Re: Display repeats together as a table

DougBrowning — Tue, 23 Jan 2024 19:05:13 GMT

I can't but here are some shots

Calcs

Basically have a if(some condition, 1, 0) inside the repeat to get a number for a condition you are looking for.

Summary page outside the repeat use sum() for a total or, sum() div count() for an avg. Or a join() just for display.

If you have nested repeats then do the sum twice. Once in the grandchild, then again in the child and finally in the parent. This will roll up the values.

Then you can use grid to make a nice display. Plus add red warnings if anything is off.

Expanded

Hope that makes sense

Re: Display repeats together as a table

Bgiordano — Tue, 23 Jan 2024 20:53:11 GMT

Epic! Thanks Doug!

Re: Display repeats together as a table

GaryBowles1 — Wed, 21 Jan 2026 18:17:20 GMT

Doug,

I am trying to display each record in a repeat table in a summary group like you have above. Is this possible? I see you mentions join() just to display, can you expand that a bit?

Thanks,

--gary