Latest Contributions by BrandonA_CDPH

Hello,    I have been working at this for a while and cannot seem to figure out what's going on. I worked with ESRI Tech Support on pat of this, but am still having issues.  hoping someone in the Community can help me before reopening the ticket. I have a Survey123 Report Template. In the template, I have a summary section at the top (that's what Tech Support helped with) and a section below for individual entries. What I want to do is filter on the Survey123 website for a particular criterion (Sampling ID). In the body of the report, I only want details for a subset of the filtered entries (the individual items that were positive). I'm working with non-GIS users, so trying to make the process as streamlined as possible. Problem: When I run the report using the attached template, it does everything correctly (only the selected results are tabulated at the top and only the subset are in the "body".) Problem is that the "body" entries are repeated several times (a report for two entries is 120 pages long). Solutions tried (all with the same result of a 120-page report): - The number of pages doesn't seem to be related to any other numbers (total entries, filtered entries, etc.) - made all "smart quotes" into straight quotes - removed a nested filter in the analysis table - searched Google and the Community for answers - pulled out hair Thank you in advance for any help on this. ... View more

I would like the ability to reorder fields in the actual table of the Feature Service (more than just visualization). Visualizations work well for most purposes (seeing it on a map, use in dashboards, etc.). The use scenario: I have a form I developed in Survey123 Connect. The data from this form is exported to a spreadsheet for further processing.  The order of fields in that exported spreadsheet are important, so I designed the form to have the fields in a certain order, published the form, then redesigned the form to match field workflow. After republishing, the columns on the spreadsheet are in the same order they were originally (as designed and expected).  Now, I need to add an additional column to the spreadsheet. When I add a field through AGOL or Survey123 Connect, the field adds to the end of the spreadsheet. Since the service is already published, this is to the "right" of several system fields (Collection Date, etc.). The columns in the spreadsheet then need to be reordered before further processing, adding a step (and potential errors) into the process. Thank you for your consideration.  Community, if you like this idea, give it a thumb up so we can tell the ESRI team we need this. Even better, add your own use case.  Thanks. ... View more