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.
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.
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
Thank you Phil and Doug,
For now, I have deployed a grid theme with repeats.
--Hassan
This would be really useful to view the results of a repeat on a "review" page at the end of a survey.
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 samplesreturn 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
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:
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.
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.
I am also getting error mistakes, particularly with the join statement in veg_html_rows. Any suggestions? Is there a missing coma?
Thank you
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.
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..
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!
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!
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.
@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?
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.
Thank you for your reply. We are also using something different than S123.
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.
I'd love to learn more about what you are using in places of S123?
I would also be interested to know what alternative solutions you have put in place
@StrathconaBTS This worked perfectly in Survey123 Connect but when I published and started entering data in the web browser none of the information went into the table. It all started showing up above the table heading and ran all together. Any thoughts?
Curious what you did to get this to work. Thanks.
Hey Holly, this wouldn't work in the browser, as the position(..) value is only relative to the sqlite database that the field application passes values to.
Hey Duncan, I am curious about your approach to an editable table inside of your survey. I will never need more than 20 repeats and I was wondering if you would be willing to assist me in that development?
Thanks, Sam
Could you please share the excel form for this?
This is incredible. I am in the process of fine tuning our S123 connect form for vegetation surveys and have been trying to find a way to display collected inventories on the form in an orderly fashion. I am going to give this a shot. Much obliged.
Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
