Generating repeat summaries in a note field

387
5
03-31-2022 03:49 PM
RyanDurand2
New Contributor

hello, 

I am trying to create a summary of repeat records in a S123 survey in a note field. The goal of this is to be able to provide the user with what has been entered so they can reference information as they add more repeats. I have looked all over and have had some success with the join() and concat() function but the load times are poor when switching pages while using a phone or tablet. This summary will not need to be retained in the feature layer after form submission which is why I am using the note field to display the summary. 

What I need in the summary is the repeat number, a couple integer fields and text fields that are separated by a "/" or "I"

In a perfect world I would have this information formatted into a table using HTML formatting but that is a bit out of my realm of understanding. If this is feasible it would be preferable.  

Any help or tips on making this work smoothly is appreciated! 

exls and csv's are attached. There are summaries being made for three of the pages (organic, mineral and species list) 

Thanks for any help! 

 

0 Kudos
5 Replies
DeonLengton
Esri Contributor

Hi Ryan

You should be able to achieve this with html by using a note field with a table in html:

<html>
<table border=1 width=100%>
<tr>
<td>
<strong> Heading </strong>
</td>
</tr>
<tr>
<td> Some information 123 </td>
</tr>
<tr>
<td> Other information 234 </td>
</tr>
</table>
</body>
</html>

Regards

Katherine_Clark
MVP Regular Contributor

Hi @DeonLengton , will this method work if the data is in a repeat, so we don't know exactly how many rows we need? Or is it only possible to hardcode the number of rows using this method?

Best,
Katherine
0 Kudos
Katherine_Clark
MVP Regular Contributor

@RyanDurand2 I've done something very similar, just using concat and join. I used this method because the data summary the users wanted was for data entered in a repeat, so the number of rows needed would vary from survey to survey.

A quick note/tip - make sure you set the field length to a very high number (I ran into issues with the string truncating and throwing an error when more records were entered in the repeat than I anticipated) and also set the field type to null so it won't appear in your feature layer's attribute table. 

Best,
Katherine
RyanDurand2
New Contributor

hello @DeonLengton 

As Sarah has asked, how does this work within a repeat? This note populates well from the information I enter for a single row but when I add additional repeats it simply overwrites the previous entry so I can only see the current repeat that is open. 

 

What I need is for each new repeat to add in a new row to build the table longer. I also need to have the data populate in columns and not just down the rows. How is this coded using HTML? The screenshot below will give you a clearer idea of what I am trying to accomplish. Where Attributes1-3 are all within a repeat

RyanDurand2_0-1648829378743.png

Thank you very much for the help, 

0 Kudos
DeonLengton
Esri Contributor

Hi

Sorry for the delayed response.

I would look at generating the HTML table in a JavaScript function for each repeat value.

I will see if I have time to give it a try in this week.

0 Kudos