Latest Contributions by DerrickWestoby

Each OID will reference a single survey submission, so it makes sense that you only get the single report output.  You're trying to generate a summary report where OID=* and something like where=date_collected=today.    I have no idea how to do that via integromat with the built-in modules and configurations, but I assume you might be able to do it in integromat with a custom HTTP module.  If  you're comfortable using your browser's developer tools (F12) to view network traffic, you could probably go to the Survey123 website and manually generate your summary report of the day's activities just so that you can view the REST API call that it makes.   If you can find that, you should be able to fill it in the HTTP module and replace a few things with what's in the webhook payload (token, today's date, report template to use, etc).    Ismael posted a blog about setting up those HTTP modules to generate feature reports a few years ago, before Integromat had a ready-to-use module.   Actually,  I guess you wouldn't want to have it trigger off a webhook because you'll end up with duplicates if it's running per-submission.  Assuming you can even have an integromat scenario without having a webhook initiate it, it would probably be better to just set it up to run at the end of every day and handle the token generation and API call for report generation with HTTP modules.   Since it can be time consuming to try to set all of this up just to see if it works in the first place, I'd try constructing that summary report REST call and test it out in Postman before even messing with bringing it in to Integromat.  ... View more

 +1 for  AdminGIS2's recommendation, but a couple more points -   There was a bug in ArcGIS Pro where the Append tool would not maintain attachments when appending to an AGOL hosted feature layer.  This was resolved with the latest release (2.9.0 I think). Make sure you're using the latest version of ArcPro.  I was doing the same thing as you about 2 years ago and I think I ran into the same problem because I was using the "Export to FGDB" option to export the data (your "V1" data) in AGOL, which didn't export attachments (at the time).  Instead, I used "Create replica" and that resolved the issue for me.  ... View more

@Anonymous User - Your recommendations worked for creating the feature layer initially via Connect, but Survey123 is submitting geoshapes with null geometry if the geoshape question is moved to a row lower than a null geopoint after initial publishing.   My first geo question is a geopoint set to null, then I have a repeat with a geopoint in it, then a geoshape that's calculated from the min/max lat/lon values extracted from the repeat.   If I publish the survey with the first geo question being null, I end up with a table and an error message that matches the original poster of this thread.  Your recommendation to move the non-null geo question to the top for initial publishing fixes this issue.  If I do a test submission without changing this order of questions, the geometry for my geoshape is stored.  If I move it lower than the null geopoint (and the repeat that contains another geopoint), submission succeeds but the geoshape geometry is null.  If I move it back up to the top of the form, the geometry is included in the submission.  If I move the first null geopoint below the geoshape (and the repeat table), the geometry is once again included in the submission.    I've tried this a few times now, including publishing a new survey multiple times.  I also queried the feature layer to make sure it wasn't just an issue with the map viewing visualization.  I'm using Connect 3.13.234, fyi.  Pictures: 1. Query on first submission, OID1, before moving the non-null geoshape question at the top of the form.  2 & 3. Query on OID2 & 3 after moving the geoshape below the null geopoint.  OID2 is automatically created with my calculation. OID3 was a manually created polygon in the app. (extent_acres is one of my calcs on the geoshape, so you can tell the app is recognizing it) 4. Query on OID4, after moving the null geopoint to the bottom of the form (and under the repeat), making the non-null geoshape the first geo question in the form again.  Geometry is included on submission.          ... View more

Welcome, and I'm glad it helped you!  (Credit to  @IsmaelChivite and his awesome blog posts for teaching me how to do this in the first place) ... View more

You should be able to add it via the AGOL interface for the feature layer, too.  I've done this when updating published surveys with new select_one or select_multiple questions created from a new list.   (As others have said, back up your feature layer before doing this)   Update the list with the exact values you have in your list in the Survey123 XLS form.    ... View more

I'm sorry I can't help you on Power Automate specifically, but I can show you how I have it set up in Integromat if that helps.   It took me a bit to get this working in integromat as well.  Same setup as you, photos in a repeat.    The array I'm passing to the iterator is the repeat itself (field_observations)   Then I run the scenario once by triggering the webhook with a submission, so that now I can see the structure for the next module.  Here's where I'm grabbing the URL using an HTTP GET module   And uploading each photo to google drive, while renaming the photos. Note that in my scenario, I have to include the file extension when renaming.       ... View more

Was there any further info on this since the last post? I have the same question.  CSV file added via linked content and used in 6 different surveys. I update once a week (through the AGOL interface, replacing existing CSV with a new one using the same file name and column names).  I'm not seeing any of the forms updated with the new data (projects) in the CSV file, 60 minutes after updating the CSV.   I can see that the mobile app is downloading the new CSV when starting a survey due to the file size being reported, but the options haven't changed.  Same thing with the web form.  ... View more

Oh man, this is my jam!  @VincentPignato  - Are you still active (4 year old post)? I picked up a laser cutter/engraver about 2 years ago to make 3D Topos and engraved maps with it.  I've made it through about 15 map projects with it so far.  Would love to talk shop with you if you're still active with Maps & Lasers.  ... View more

Thanks Doug.  I may try this in a test version of the XLS, but not too fond of the javascript implementations based on experience and if you're already reporting it struggles with large surveys.  The surveys I have in use with javascript running are much less stable already.  ... View more

Thanks for the response, Philip.   I'm not attached to this specific way to accomplish the goal, just the goal itself.  If there's another way to make a question's default answer match the input from the previous record in the repeat, I'd love to hear that!  I sent you a message with my XLS as well.  Thanks for taking a look.  ... View more

Hi @chaims - I just spent a half hour trying to find the TTS service/link that I was using, but haven't been able to find it.  I'm afraid I might have deleted the dashboard that was using it when I replaced it with the new one using the new map viewer.   I'm pretty sure that I found it on RapidAPI and the reason this one was unique was that I could use it with URL parameters.  Sorry I can't find that right now, but I'm pretty sure I documented it somewhere (R&D Sandbox scratchpad kinda thing), so I'll look for that this afternoon or tomorrow.  Here's the general setup though -  1. Create an 'embedded content' element in a Dashboard, aimed at a feature layer.  2. Source for me was something like https:\\www.[can't-remember-tts-service].com?tts=New UAS Flight log submitted for {projectnumber} - {projectname}.&autoplay=true  (I don't think I had to encode the URL, but I don't remember how I had it set up initially) 3. Using the steps laid out by this blog post, I set it up so the most recent submission (from a survey123 UAS flight log submission) would update the embedded content element and play the sound when a new record was submitted.    All of this really hinges on finding that TTS site that supported the URL parameters, including auto-play.  I'll keep digging for it, but would appreciate it if someone else could post it if they happen to find it.   ... View more

That's possible as well.   I'm typing on my phone and being brief, but you could restrict the questions that editors would have access to, or even use your static layer to prefill questions on an entirely different survey.   Read through the help docs and blog posts about url parameters to launch the web form and you'll get some good ideas about how to integrate it.  I'll be back in the office on Friday and could show a few examples as well if needed.  ... View more

Here's another help doc on the same topic - https://support.esri.com/en/technical-article/000021897    And a few blog posts from Ismael that I always find really helpful: https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-embedding-a-survey/ba-p/899140  https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-web-form-url/ba-p/894722     ... View more

All I can do with you on that one is commiserate.  I agree it's tough watching for the rug to be swept out from under you all the time.  I've gotten into the habit of spending ~1 hour per week at work going through all of the release notes and blogs of all of the software I use at work (Normally my Monday mornings, which is why I'm here right now...)   Anyways, I'm back in the office and here's a copy & paste from my updated templates.  The "currentLayer" tag here is the new one I was describing: ${image_location | drawingInfo:"currentLayer"| mapSettings:" b2519fd7a45647a0946f50b0535b6ddd":36000| size:175:250:0:0} I can't even find the blog post that this was first mentioned in, but I see that it's been added to the help doc for the report template: https://doc.arcgis.com/en/survey123/browser/analyze-results/featurereporttemplates.htm ----------------------------------------------------------------------- If your survey doesn't contain a map question or you're creating reports for feature layers without an associated survey, the geometry of a question can still be returned using the ${$shape} placeholder. By default, a map question will display using a default map symbol, regardless of symbology set in the feature layer. You can use the drawingInfo method to extract and use the drawing information stored in a specific feature layer, including the symbol, label, and transparency used. You can specify this information either from the current layer or from a specific feature layer through a provided URL. ${location | drawingInfo:"currentLayer"} ${location | drawingInfo:"https://.../FeatureServer/0"} If your survey doesn't contain a map question or you're creating reports for feature layers without an associated survey, the geometry of a record can still be returned using the ${$shape} placeholder. ------------------------------------------------------------------------------ And I can confirm that it works for points and area features.  In the web map being called, my point features will display a radar box/arrow icon (that's hosted elsewhere) based on the viewing direction if it's available. If not, a blue circle will be displayed.   Started working perfectly as soon as I put that flag in there to use current layer from the web map.    ... View more