topic Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)? in ArcGIS Survey123 Questions

Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

HassanBasagic1 — Wed, 11 Mar 2020 21:13:16 GMT

I am creating a form to collect information on individual fish at several locations using Survey 123 Connect. I set up a repeat group to record individual fish attributes, however, the field crews need to see all repeated rows as the data is collected. Is there a method to display all completed repeated rows within a survey instead of having them stacked (1 of x)? The number of fish recorded at a site varies between 1 and ~100. I am using a grid formatted survey to replicate the field crews current data collection form. Attached is a screen capture of a simplified table example. Any advice is greatly appreciated.

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

Anonymous User — Tue, 17 Mar 2020 23:00:06 GMT

Hi Hassan,

No this is not currently possible, each repeat is its own record and therefore can not be displayed on the same repeat. Some other ways you could consider to redesign your survey would be to use grid theme which does allow you to have a table view, however this does not use repeats, all records would be part of the same parent record or the first repeat.

Regards,

Phil.

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

DougBrowning — Tue, 22 Jun 2021 08:46:47 GMT

I would also love this.

Vote up the idea here Appearance option to view Repeats stacked in Survey123 app

And here https://community.esri.com/ideas/17811

Talked about here also

How to Create a Survey123 with Fillable Table

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

HassanBasagic1 — Wed, 18 Mar 2020 19:27:37 GMT

Thank you Phil and Doug,

For now, I have deployed a grid theme with repeats.

--Hassan

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

ThomasBeers — Wed, 10 Mar 2021 16:59:50 GMT

This would be really useful to view the results of a repeat on a "review" page at the end of a survey.

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

ThomasBeers — Wed, 10 Mar 2021 23:05:46 GMT

There is a way to do this using java script functions. Read in what you want to display using a calc field:

pulldata("@javascript","displayrho.js","samples", ${RHO})

Simply make the function return the string:

function samples(RHO)
{
//dsiplay all samples
return RHO;
}

Then make a note field using ${DisplayRHO} . This will list them with comma's in between. Let me know if you find a way to get this in table format!

You can find a great write up on JS functions in survey123 here:

https://community.esri.com/t5/arcgis-survey123-blog/extending-survey123-smart-forms-with-custom-js-functions/ba-p/898782

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

StrathconaBTS — Wed, 15 Sep 2021 19:14:01 GMT

I came up with a hack for this. I used an HTML table to display the entire contents of the repeat. Unfortunately CSS is not supported so I had to revert to deprecated table attributes:

For each repeat I created a calculate that created a table row by concatenating each field surrounded by tr and td tags- in my case named veg_html_row
I then concatenated all the rows inside some table and table header tags using another calculate outside of the repeat - see veg_html_rows
I then put the results in a note field

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

JesseKalwij1 — Wed, 29 Dec 2021 10:01:35 GMT

I am very interested in this vegetation survey form. I tried reproducing the form using these screenshots, but I received a validation error. I have just started using Survey123, so the problem lies with me. Still, would you be willing to share this form with the community, or with me? Thanks so much in advance.

Edit: I managed to reproduce the example. I am very happy now.

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

AndrewPuchalski — Tue, 11 Jan 2022 22:21:47 GMT

I too would be interested if possible to get a copy of the form to help re-work the table. I have been trying for a few days with no luck.

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

TristanGingras-Hill — Wed, 19 Jan 2022 15:46:17 GMT

I am also getting error mistakes, particularly with the join statement in veg_html_rows. Any suggestions? Is there a missing coma?

Thank you

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

JesseKalwij1 — Wed, 19 Jan 2022 19:43:30 GMT

I managed to get it to work. Note that you also need to increase the length of the bind::esri:fieldLength column to fit all characters of your html table. The attached xlsx form is still very much a work in progress, but you can hopefully find what you need in there.

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

DuncanKinnear — Thu, 20 Jan 2022 02:30:05 GMT

I'm in the process of creating a (somewhat clunky) workaround to this for our flora sampling form, which allows the user to update heights and cover % in a grid-like table underneath the repeat.

This relies on creating duplicate height and cover questions for each possible repeat (which will be null-type fields), outside of the repeat. The height and cover values within the repeat then update based on what is entered in these duplicate fields, using a javascript function, or a complex if statement. I'm trying to build a string to reference the correct field based on repeat number (see this post: https://community.esri.com/t5/arcgis-survey123-questions/method-to-build-a-string-to-reference-another/m-p/1135275#M39855), but haven't worked that out yet. Note that i'm still showing height and cover within the repeat in the screenshot below, but I will probably hide these fields eventually.

The summary table species names update using the indexed-repeat function.

In my example below I only have 3 species, i'd imagine that by going up to 50 or 100 performance may suffer (and we'll need a lot of extra fields in the XLSform), but we shall see if this works... Either way it will save time on our current process of scrolling back through each repeat to find the right species..

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

StrathconaBTS — Tue, 25 Jan 2022 00:52:14 GMT

Hello folks - looks like there is a lot of interest in displaying repeats in an HTML Table. I've attached an export of the form for the repeat section plus the extra logic that ensures there is a record for at least one of each type. Happy Survey123ing!

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

Strahanjen — Wed, 13 Apr 2022 03:48:38 GMT

Duncan, our biologists are asking for this feature for their veg surveys. Have you had any luck fleshing out this approach? If so, I'd love to borrow from your work!

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

DuncanKinnear — Tue, 04 Oct 2022 06:05:03 GMT

Hey, sorry I never got back to you. I ended up giving up on this workaround - it became way too clunky and slow when I scaled up to 50 or so repeats (which we often have a need for). We've settled for an HTML summary table which displays below the repeats as suggested by @StrathconaBTS (thanks!), but is not editable. Still major improvements to be made here as our field teams still need to scroll through each repeat to find the right record.. Hoping ESRI will improve this functionality soon otherwise we may need to use alternative software.

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

PegGronemeyer1 — Tue, 04 Oct 2022 12:47:40 GMT

@StrathconaBTS and @DuncanKinnear We are also looking for editable table-like capability so that biologists can see multiple rows of data as they enter... Has there been any update on this capability?

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

DuncanKinnear — Thu, 06 Oct 2022 01:35:36 GMT

No updates yet as far as I'm aware, we are now at the point where we are needing to use other software for this functionality - we lose too much time in the field otherwise with sometimes 80+ repeats.

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

PegGronemeyer1 — Thu, 06 Oct 2022 12:52:57 GMT

Thank you for your reply. We are also using something different than S123.

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

Strahanjen — Thu, 06 Oct 2022 13:44:41 GMT

No problem. We tested out your approach for 100 repeats and also concluded that it was too slow. Also, when the user updated data in the tabular view, they still needed to click through all of the repeats at the end for the values to be updated in the actual repeat records.

Re: Is there a method to display all repeat rows within a survey instead of having them stacked (1 of x)?

Strahanjen — Thu, 06 Oct 2022 13:45:20 GMT

I'd love to learn more about what you are using in places of S123?