Latest Contributions by JasonCyphers

‎05-26-2021

Thanks for the info! I'll play around with it!

‎05-26-2021

Thanks for the reply. A little more detail... I have a Survey123 form, with a select_multiple field. I also created individual numeric fields for each of the selections that is auto-populated with a "1" if that value is selected in the select_multiple field. The serial chart is comprised of these individual fields, and sums the value of these fields to return the total # of times an option was selected (this was the only way I could get a count of each individual selection). This is all being done in an enterprise portal, and it looks like that option to do a data expression is only in AGOL. Looked at a pie chart; but, with over 80 items I'm trying to report, it's a little busy. In additional to the above, I'd really like a way to sort by record count, as I've been asked several times to view the "top 10 most selected items", but creating a serial chart from individual fields won't allow that.

‎05-26-2021

I created a serial chart, with categories from fields. While the chart shows record count, I'd like to include percentages of overall records, either as a label or using guides. Is there any way to do this? If using guides, I'd like something like this:

‎05-12-2021

Ok, this sounds a little more promising. I've seen info on Field Maps, but was reluctant to tell the crews to now use Field Maps, instead of Collector, for the sake of change management. I'll research Field Maps a little more, as it sounds like it's the solution I need. Thanks for the info!!

‎05-12-2021

Yikes! So, your saying the field users that will be walking our mains & services have to have the Tracker app running (in the foreground) and the Tracker app's map won't show any of our mains or services - so the field users won't know where they need to walk; nor will they be able to see tracks that have been walked by themselves or other inspectors that were obtained prior to 72 hours ago?

‎05-12-2021

My org. is in the process of obtaining tracker licenses for our Enterprise Portal, and while we wait for ESRI to provide them to us, I'm trying to put together our first project utilizing it - a regulatory inspection where field users walk out our mains and services, and inspect meters within a portion of our system, which needs to be started ASAP. As we need to get this project started as soon as possible, I'm wanting to get some questions answered so I'm able to get everything set up as soon as the licenses are available. I'm assuming I have to create a Location Tracking feature layer in Portal that Tracker will utilize, or does Tracker create its own? Am I able to utilize a collector map that the field users will use to view our mains & services, and to perform inspections on meters, while Tracker runs in the background, or does everything have to be done from the Tracker app running in the foreground? If Tracker has to be in the foreground, am I able to customize the basemap to show our mains, services, and meters; and, to show tracks walked that are older than 72 hours (the inspection will take a few months to complete, and field users will need to know, for the duration of the project, what areas have been inspected, and which ones haven't)? If I'm able to use Collector, with Tracker running in the background, I'm guessing I can just add the feature layer to the Collector map, applying a refresh rate, so field users will be able to see what mains/services have been walked for the duration of the inspection. Any other tips/trick/suggestions? Any project examples anyone is able to provide? I've watched the handful of YouTube videos related to tracker, but none of them seemed to address my questions above (or if they did, I missed it). TYIA!

‎05-11-2021

Is there a way to sort a dashboard's series chart that contains categories from fields? I have a Survey123 form with a multi select field called Hazards. I then created an attribute in the database for each selection. Within the Survey123 form, I hid those attribute fields and created calculations to populate them with a 1 or 0, based on the Hazard being included in the Hazards selection. I then created a dashboard to show those individual attribute fields and the number of times they were included in the multi-select Hazards. I'd now like to be able to sort them by record count (highest to lowest) and alphabetically, but don't see any sort option in the chart's configuration. I'm assuming there isn't one, and the sorting is just based on what order you add the fields?

‎05-10-2021

It's a little cumbersome, but when I have instances like that, I create two lists... one with related table data, and the other with the feature's data. I add 'actions' to each so I can filter each one based on the other. In the below example, the "Riser List" is the feature, and the "Inspections" list is the related table. When I click on an inspection record, only one feature is displayed in the "Riser List", which I can then click on to filter/zoom the map. Alternatively, I can click on a feature in the "Riser List" to filter/zoom the map and to see all inspections (related records) associated with it. If someone has any better/alternate methods, I'd love to see those as well.

‎05-10-2021

Thanks! Didn't even think about a concat statement.

‎04-30-2021

I've added a note to a Survey123 web form that a user can click on to submit an email, with the contents of the survey. The script in the XLS Form looks like this: <a href="mailto:email@email.com?subject=Review of ${sp_number}&body=${sp_number} - ${name} has been reviewed, and has a status of ${status}.">Click Here to send status update email</a> However, when opening the survey in a web browser, the note looks like this: ...and clicking on the link populates a new email in Outlook like this: How can I modify the code to work correctly? I've tried various combinations of "?" and "&" before the subject and body, with no luck. I went down the Power Automate route, to automatically send an email; however, there are too many variables with the form to limit the number of emails sent to just one, when the feature was approved, and to not send duplicate ones when the point was updated again.

‎04-22-2021

Correct. Both the select_one and select_multiple are looking at the exact same list choices. I have another select_multiple question in the survey that is looking at the same list choices as well. Never had any issues with that one, which is what made me try to change the select_one I was having issues with.

‎04-22-2021

Oddly enough, the field type, in Survey123, was select_one. I changed it to a text field and manually typed 3/4" in, and it didn't have any errors. I then changed it to a select_multiple field, and that worked as well. Really confused as to why select_one will not work.

‎04-22-2021

the attribute field with the error is called "bypass_size". I deleted the field and everything worked fine. I created a new field called "size_of_bypass", and it caused the same error. I even tried entering a value other than 3/4", and it still caused an error.

‎04-22-2021

Half of the fields get populated. The field that has the error is a 256 character string field, and the value is 3/4"; so, wouldn't think it's a formatting issue. There is another 256 character string field that has that same value in it, and it loads & populates without issues.

‎04-22-2021

That did it! Getting closer, but now I'm getting an error: and the field name and value that its supposed to contain is listed. And, every field after that one is blank as well (almost like Survey123 went field by field, populating it with the values previously entered; but, when it got to that field, it errored out and just stopped.

Online Status	Offline
Date Last Visited	‎09-10-2023 05:18 PM

My Ideas

Latest Contributions by JasonCyphers

Re: Serial Chart Guides based on Percentage

Re: Serial Chart Guides based on Percentage

Serial Chart Guides based on Percentage

Re: Tracker Newbie Questions

Re: Tracker Newbie Questions

Tracker Newbie Questions

Sorting Fields in a Serial Chart

Re: How to add related tables data in dashboard

Re: Syrvey123 Web Form email hyperlink

Syrvey123 Web Form email hyperlink

Re: Link from ArcMap to a submitted Survey123 form

Re: Link from ArcMap to a submitted Survey123 form

Re: Link from ArcMap to a submitted Survey123 form

Re: Link from ArcMap to a submitted Survey123 form

Re: Link from ArcMap to a submitted Survey123 form

Conditional Text Formatting in Operations Dashboar...

Dynamic Content Expression

Getting API data on a map

Fields not showing up in Smart Editor (WebApp)

Map Viewer (Beta) Symbolize Related Table