|
POST
|
Hi @EvanDarpini I think a JavaScript function will be perfect for this. For example: function squareRootOfSumOfSquares(nums) {
let sumOfSquares = 0;
let numsArray = nums.split(',');
for (let i = 0; i < numsArray.length; i++) {
sumOfSquares += numsArray[i] ** 2;
}
const squareRoot = Math.sqrt(sumOfSquares);
return sumOfSquares;
} The function takes a comma separated list of numbers, squares them all one by one and calculates the sum. Then it returns the square root of the sum. You can generate a comma separated list of numbers in different ways. Below is an animation showing the test I did with all of this. I created three experiences to enter the data. One using a single text question, a series of questions and a repeat. Just for fun. Attaching a the XLSForm illustrating the concept. If you are not familiar with JS functions check out this blog.
... View more
04-22-2023
09:42 AM
|
1
|
0
|
1228
|
|
POST
|
Hi @Tiff-Maps The Survey123 web app has limited support for editing repeats, and you are running into one of them. In short. The default behavior of the web app is such that it will display all related records and allow you to delete/add/update them according to the settings in your feature layer. If you disable query capabilities by making the layer add-only, the repeat will fail to load. If you enable queries to let the repeat load, you could disable updates and deletes, but respondents could still look at other related records. If using the Survey123 mobile app (Inbox), the above limitations do not exist, because you can control what related records are loaded (using a where filter) and even what permissions are set in the repeat (allowUpdates=false, for example). There are more details about this in the Repeats in the Inbox section of this blog. It does not seem like using the mobile app is an option in your case. In short, I think that you have reached a limit. I am copying here my colleague @ZhifangWang in case he can think of any other options or make a correction. As a workaround, I am thinking that you could have the popup launch a survey that ONLY works with the related record. That is, instead of loading a survey with a repeat, you load a survey that targets the repeat related table directly. You will need to pass the GlobalID field to populate the parentGlobalID field in the related record and open the survey in normal mode (not in edit mode). To do that you will need to: Create a survey from your original survey feature layer. This will automatically populate the submission url parameter in the XLSForm design settings worksheet so your new survey targets your original survey layer. Go into the survey worksheet and remove all questions that refer to the parent layer Take the name of your repeat and paste it into the Form ID column in the settings worksheet Remove the begin repeat and end repeat rows Add a new question that matches the name of the field in your related table that carries the parentGlobalId field. Set the question tyupe to Guid Publish Have your popup launch this new survey passing the parentGlobalId value When your new survey is launched, all the respondent will see is a survey to add comments or new info into the record. Submit and go. No options to see anything other people added. I hope this makes sense.
... View more
04-22-2023
08:42 AM
|
0
|
3
|
2506
|
|
POST
|
@Alexandre @BenCunningham As far as I know, it it not possible to attach the report file to an email without saving it first somewhere and then downloading it. I am not an expert in Microsoft Power Automate and not familiar with Sharepoint. It may be best to ask in the Microsoft forums. The output of the Create Report tool is a URL. What one can do with it in Ms Power Automate is... well Microsoft territory. If your fear is to leave a folder in the cloud full of files, you can also use the Delete file action after the email is sent. That way, you just upload the file temporarily. Hope it makes sense!
... View more
04-19-2023
06:13 PM
|
1
|
0
|
3998
|
|
EVENT
|
Recording, slides and Q&A now available here: https://community.esri.com/t5/arcgis-survey123-videos/survey123-tricks-of-the-trade-live-create-feature/m-p/1280375#M101 Thanks to all who attended!
... View more
04-19-2023
05:29 PM
|
3
|
0
|
4555
|
|
IDEA
|
https://community.esri.com/t5/arcgis-survey123-blog/understanding-web-form-version-locking-in/ba-p/898972
... View more
04-19-2023
05:06 PM
|
0
|
0
|
1222
|
|
POST
|
On April 19, 2023 we recorded a Tricks of the Trade session covering Survey123 feature reports. Thanks to all attendees! In this post you will find the recording, resources and Q&A. Highlights Survey123 includes a report service. With it, you can create beautiful PDF reports including maps, photos, tables and more. Build your own reports for compliance, to document the work you do, to share information with stakeholders in a format they are familiar with or simply to create high quality printable documents. This 60' session will help you get started creating your own Survey123 report templates. It includes some basic conceptual slides, plus live demos and practical tips. Next week we will host a session covering Report automation. Learn more about it and register here. Recording Watch here Slides Find the slides at the bottom of this post . They are attached in PDF format. Q&A How do you return multiple photos attached to a single feature in the report? It’s possible to display an image question that has a multiline appearance applied to it by using the following syntax: ${#image1} ${$file} ${/} The syntax above will display the images horizontally on the page, and adding carriage returns instead of spaces will display the images vertically: ${#image1} ${$file} ${/} Also see the Images and other attachments section of the Survey123 Report Templates documentation. Is there a way to connect reports to Excel so I can include a scatterplot or other chart based on site monitoring data being collected in my survey? Or is there another chart plotting tool that you would recommend? Currently it is not possible to export reports to Microsoft Excel. There is an open ArcGIS Survey123 Idea for this enhancement, please upvote this idea so the Survey123 team can track interest in this feature. As a potential workaround, you can insert dynamically generated images into your reports. For example, this expression concatenates a URL to a QR code-generating service, creating a QR code image for the question's response. ${$image | src:"https://barcode.tec-it.com/barcode.ashx?code=QRCode&data="+survey123question} It may be a long shot, but this may help you bring your plotting chart images into your reports, if you somehow can make them available via a URL ${$image | src:"https://mywebserver.com/plots/"+stationID+"jpg"} Can the report automatically be saved to a local network drive so staff can see it once generated? When a report is exported from the Survey123 website, the report will be saved in the user’s ArcGIS account in the location specified during export and also downloaded to the default download location. It is not possible to edit the default download location. It is also possible to use third party automation software to upload report exports to specified locations. See ArcGIS Survey123: Create Feature Reports with Integromat for an example of how to do this with Make.com (formerly Integromat). Is there a way to reference data from another layer (such as parcel data) that would not be collected in the survey itself? It is not possible to do this with a report template. It would, however, be possible to use pulldata("@layer") in the survey to populate a field based on the non-survey layer. This question could then be referenced in the report template. Can users rename photos while completing a survey? Yes, by default you can have users change the filename. Additionally, you can also have photo filenames automatically populated. Check this blog for details: Could we filter or limit the repeats? Yes. You will want to use the where method for that. Below is an example: Can I limit the repeat records that are shown to the last 30 days? Yes, you will want to use the where method. Here is an example ${#inspections | where: " inspection_date BETWEEN CURRENT_TIMESTAMP - 30 AND CURRENT_TIMESTAMP" | orderByFields: "inspection_date DESC"} ... ${/} Is there an update on implementing photos and maps within the "repeat" of a summary report No. In a summary section, printing a map or image, including retrieving properties from an attachment file except for attachment name and size, is only supported outside of repeats. Otherwise, an error message will appear. For dynamic visibility, how do you account for the large amount of empty space where those questions would be if they were visible? When using a conditional section, keep in mind that any line breaks, spaces, or other characters outside of the section start and end tags will be displayed in the exported report. The section start tag can be placed immediately after the previous section to prevent unwanted line breaks from displaying in the exported report. Do we have control over the pin symbol of the specific hydrant point in the map in your example? 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. ${location | drawingInfo:"currentLayer"} You can specify this information either from the current layer or from a specific feature layer through a provided URL. See the Map questions section of the Survey123 Report Templates documentation for more information. Can reports be created for surveys created in Connect and then linked to an SDE in Enterprise? Yes. Is there different syntax for reporting the summary of your selected attributes? Max, min, mean of the different features? Yes. Check the Summary section of the Survey123 Report syntax help, or check this blog. Upcoming sessions Join us next week to learn about automating Survey123 reports!
... View more
04-19-2023
12:10 PM
|
5
|
6
|
12148
|
|
POST
|
On April 12, 2023, Directions Magazine hosted a webinar covering Building Location-Aware Forms with the ArcGIS Survey123 Web Designer . In this post you will find the recording, resources and Q&A. Highlights Forms are a simple yet powerful way to collect information. They are regularly used to support many workflows. Forms are used to report incidents, document the condition of assets, assess damage to property... Forms are used for permitting, to request and inventory equipment, as a safety checklist... In many of these forms location is key. If you are reporting an incident, don't you want to make sure the incident location is accurately set? If you request a building permit, would not you want to have the location of the building be accurate? Survey123 is designed to help you build forms that collect accurate location information. Survey123 will also help you map your form data immediately. This webinar explores the Survey123 web designer: A web based visual form builder. The Survey123 web designer is an excellent starting point for you to start combining the power of forms and GIS. Recording Available here: https://mediaspace.esri.com/media/t/1_gtvmym4w Slides & Q&A Available here.
... View more
04-19-2023
11:53 AM
|
1
|
0
|
1342
|
|
POST
|
I think you are in the right track. You will definitively need to create a second survey targeting the related table. The trick, as you point out, is how to feed the Create Report tool with a Where statement so you can run a report for all records that match your parentGlobalID. Unfortunately, you cannot specify a Where clause yet (although this is something we would like to add in the future). So the only option left is to feed the Create Report action with an objectID. This should be possible through the HTTP module. You will need to make a call with this module to the feature layer REST API and get back the ObjectIDs for your parentGlobalID. Then either use an iterator to generate reports for each ObjectID, or pass all ObjectIDs as a comma separated list to the ObjectID argument. I am not 100% sure if passing the comma separated list will work. It will only work if the default policy for bulk reports is split. I am not sure if that is the case. Never tried it. In any case, you always have the option of using an iterator.
... View more
04-18-2023
08:40 PM
|
1
|
1
|
2051
|
|
POST
|
Hi @AnnaScholl If you are an authorized Esri Tech Support caller, please open a Tech Support incident so an analyst can work with you on diagnosing the problem. If not, please email [email protected] with your contact details so we can get on a screen sharing session.
... View more
04-18-2023
09:05 AM
|
1
|
0
|
4557
|
|
IDEA
|
@Katie_Clark Thanks for the quick response. I adjusted the original text to make it more direct. Lets wait and see if this idea gets traction. Thanks again.
... View more
04-13-2023
01:51 PM
|
0
|
0
|
3564
|
|
IDEA
|
04-13-2023
01:45 PM
|
0
|
0
|
3566
|
|
POST
|
@Vinzafy @ChristopherCounsell You rock! Agreed 100%. This is ready for an official Tech Support case to be opened. In the meantime, I will also let my colleagues in the Survey123 team know as a heads up to the Tech Support case. Many thanks!
... View more
04-13-2023
10:19 AM
|
2
|
1
|
2496
|
|
IDEA
|
04-13-2023
10:13 AM
|
0
|
0
|
3582
|
|
IDEA
|
Hi @Katie_Clark Thanks for your idea. I see a couple of different asks in your idea. Please let me know if I understand your request correctly: You want to be able to control the date/time format used by the end user in the form. That is, when the date/time is captured by the end user. You want to define the format of a Date/time value when create a custom PDF report. For #1 above, what do you think about using the body::esri:style column to define the format that the Date/Time widget should use? Would that make the trick for you? It is not currently implemented, but this could potentially be a solution for consideration. For #2: Regardless of the format used to capture the date/time, you can control the format used to outptut a Date/Time value in a PDF report. For example: If you want to add AM/PM, use A (or a if you want it as am/pm).
... View more
04-13-2023
10:13 AM
|
0
|
0
|
3583
|
|
POST
|
Hi @JoseBarrios1 Unfortunately, it is not possible to use XLSForm syntax to define the time format to be used in the time widget. That is: You cannot control the format used to collect the date/time value in the calendar/time widget in the form. The date and time format in the widget is dictated by the operating system and locale. The format-date function is used to get a time value and generate a string, which you can then store as an attribute or display in the form as a note. Your ask looks similar to this idea. https://community.esri.com/t5/arcgis-survey123-ideas/different-formats-for-time-field-in-survey123/idc-p/1278387 Feel free to add your input to the idea if appropriate. Thanks!
... View more
04-13-2023
09:46 AM
|
0
|
1
|
3357
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-03-2021 09:03 AM | |
| 1 | 04-01-2022 12:48 PM | |
| 1 | 03-22-2022 08:44 AM | |
| 1 | 08-26-2021 02:43 PM | |
| 1 | 10-30-2019 10:15 PM |
| Online Status |
Offline
|
| Date Last Visited |
Tuesday
|