|
POST
|
Johannes, Tried your expression above and it worked great! See below... Really appreciate the help!! Have a good holiday! Josh
... View more
12-10-2021
10:40 AM
|
0
|
0
|
2917
|
|
POST
|
I really appreciate the help! That did get rid of the error for me but unfortunately my expression doesn't give me a running sum total like i thought it was going to. I don't have much experience writing these types of expressions so its a bit of searching around trying this and that. Josh
... View more
12-08-2021
08:54 AM
|
0
|
3
|
2937
|
|
POST
|
Hello, I am having trouble creating a cumulative chart for my dashboard using a modified arcade expression (see below). It doesn't give me an error or anything it just spits out this empty feature set. Any help would be appreciated! Josh var portal = Portal("https://www.arcgis.com/"); var vendor = GroupBy( FeatureSetByPortalItem(portal,"********************",0,["*"],false), ["Invoice_Date"], [ { name: "Invoice_Total", expression: "Invoice_Total", statistic: "SUM" } ] ); var combinedDict = { fields: [ { name: "date1", type: "esriFieldTypeDate" }, { name: "cost1", type: "esriFieldTypeDouble" }, ], geometryType: "", features: [], }; var i = 0; // Loop through each FeatureSet and store its attributes for (var v in vendor) { combinedDict.features[i++] = { attributes: { date1: "Invoice_Date", cost1: v["Invoice_Total"], }, }; } //return combinedDict; // Return dictionary cast as a FeatureSet return FeatureSet(Text(combinedDict));
... View more
12-07-2021
02:30 PM
|
0
|
8
|
2986
|
|
POST
|
Hello, First of all I am a beginner to all but the most basic arcade expressions so this is all brand new to me. I want to be able to create cumulative charts that sum a value and allow the data to be parsed by date. The example i'm trying here is to sum all my invoices starting from Jan 1st, 2021 going forward. I've modified the below expression which I got from the above post . Seems like it should work but all i get is a Execution Error: Error. Not very helpful for troubleshooting. Is there something i'm missing??? I feel like its probably with my filter date expression but that just a guess. Josh // Get your input layer var fs = FeatureSetByPortalItem(Portal('***********'), '************', 0, ['Invoice_Date', 'Invoice_Total'], false) // Filtering input to a single quarter. var invoices_21 = Filter(fs, "Invoice_Date > '2021-01-01'") // Grouping by sale date to get per-date total var invoicing = GroupBy(invoices_21, 'Invoice_Date', {name: 'total', expression: 'Invoice_Total', statistic: 'SUM'}) var fs_dict = { fields: [ {name:'date', type:'esriFieldTypeDate'}, {name:'running_sum', type:'esriFieldTypeDouble'}], geometryType: '', features: [] } var i = 0 for(var s in invoicing){ // Get all dates before or equal to date var filt_date = s['Invoice_Date'] var running_sum_fs = Filter(invoicing, "Invoice_Date <= @filt_date") // Populate dict fs_dict.features[i] = { attributes: { 'date': filt_date, 'running_sum': Sum(running_sum_fs, 'total') } } console(filt_date) console(sum(running_sum_fs, 'Invoice_Total')) i ++ } return featureset(text(fs_dict))
... View more
12-02-2021
09:49 AM
|
0
|
0
|
5480
|
|
IDEA
|
This is a hugely needed capability. In my view it is a frustrating mind boggling limitation to an otherwise excellent program. I agree it should be up to the form developer and should be able to be applied to some or all the questions as needed and be dynamic. I hope this makes it to development soon. Josh
... View more
07-26-2021
04:06 PM
|
0
|
0
|
2252
|
|
POST
|
Hello, I am having troubles getting my repeat answers to show up when i go to edit through the inbox. My workflow requires that i have a survey with a single repeat that i want one group to complete. A second group will edit the repeat answers if necessary through the inbox so they need to be able to see what the previous answers were. I set allowUpdates=true in the bind::esri:parameters column for the begin repeat row and republished the survey but this did nothing. When i open the sent survey through the inbox it doesn't pull in any of the previous answers. Am i missing something??? I have also tried adding quote "" marks around the allowUpdates=true but this has not worked either. Josh
... View more
07-08-2021
06:44 AM
|
0
|
2
|
1670
|
|
POST
|
Hello, I am having trouble updating my hosted feature layer on AGOL. I am trying to use the Append tool in ArcPro to add recent data and I want to keep the attachments. My source data is in a fgdb. The feature class I am working with has 2,814 point features and there are 5,688 pictures in the related attachment table. I am careful to make sure my fields match and I have the "Maintain Attachments" checkbox selected. I have successfully done this a number of times in the past but never with this many attachments. When i run the tool it runs through to completion with ought giving an error. The feature points get added but not the attachments. Is there some magic limit in ArcPro or AGOl that is causing this to fail or this there a better way to do this??? I am using ArcPro 2.8.0. Thanks, Josh
... View more
06-17-2021
11:12 AM
|
0
|
22
|
7982
|
|
BLOG
|
Is there a limit to the number of fields values you can send from one survey to another through a single url or am not doing something correct with my url? I have survey in which I want to send the values of up to 18 different fields over to a separate survey. I have had success sending up to 4 field values over but not with the rest. Thanks! concat('<a href="arcgis-survey123://?itemID=MYSURVEYSUNIQUEID&field:Code1=100&field:Form_Type=Damage_Log','&field:Crew_Size=',${Crew_Size},'&field:Truck_Units=',${Truck_Units},'&field:Name_1=',${Name_1},'&field:Position_1=',${Position_1},'&field:Name_2=',${Name_2},'&field:Position_2=',${Position_2},'&field:Name_3=',${Name_3},'&field:Position_3=',${Position_3},'&field:Name_4=',${Name_4},'&field:Position_4=',${Position_4},'&field:Name_5=',${Name_5},'&field:Position_5=',${Position_5},'&field:Truck_1=',${Truck_1},'&field:Truck_2=',${Truck_2},'&field:Truck_3=',${Truck_3},'&field:Truck_4=',${Truck_4},'&field:Truck_5=',${Truck_5},'">Send To Survey 2 Form</a>')
... View more
02-11-2021
01:08 PM
|
0
|
0
|
10872
|
|
POST
|
Hi, I am having a issue with 2 public surveys. These were both created using Connect and were working perfectly fine last week. Yesterday I made slight updates to a domain choice field and republished using Connect Vs 3.11.124. Now both of them are causing unpacking issues when the user tries to update on the field app. The survey appears to download but seems to get stuck in a endless loop while trying to unpack. I have tested this on a android phone, ipad, and windows laptop with the exact same results. Its a no go for the field user if you try to update the survey. From other posts it seems this may not be a new issues, has anyone had success fixing this problem??? Here are things i've tried so far. I first tried updating the form to the latest version and republishing but this also did not resolve it. Next I tried rolling back all my changes including the form update but that did not fix it either. Josh
... View more
02-06-2021
04:47 AM
|
0
|
21
|
8079
|
|
BLOG
|
Hi, I discovered what the issue was. I had some pull data formulas that were looking for CVS files that were missing. I removed the formulas as they were not necessary and it works now. Josh Sent from my Verizon, Samsung Galaxy smartphone
... View more
06-05-2020
04:37 PM
|
1
|
0
|
37231
|
|
POST
|
All, Is it possible in Survey123 to grab the address from a geopoint question and have that auto populate a Text Field question ${Address}? What i'm after is saving the user from having to manually type in the address. Has anyone successfully done this? Thanks, Josh
... View more
04-17-2020
08:09 AM
|
0
|
1
|
802
|
|
POST
|
Hi James, I removed the note name values and it seems like it works now just fine. I don’t get the data error anymore and the links are working as they should. I’ll continue to do some more testing but I’d say that has fixed it. Thanks, Josh
... View more
09-24-2019
05:46 AM
|
0
|
0
|
1002
|
|
POST
|
All, I am having an issue with a google maps url causing data errors that is prevent editing of the survey data. The Url that i am using is so the crews editing existing data can launch google map for driving directions. I originally copied the following expression esri's support page. FAQ: Is it possible to view a geopoint location from Survey123 Connect for ArcGIS in Google Maps? The expression in my survey form. concat('<a href="https://www.google.com/maps?daddr=',pulldata ("@geopoint", ${Gps_Coord}, "y"), ',' ,pulldata("@geopoint", ${Gps_Coord}, "x"), concat('&ll=">Click to open google maps</a>')) The issue seems to be the " qoute marks for "https and =">. This is causing some sort of data error that makes it impossible to edit any of the attributes for the survey. If i remove the quotes then there is no data error but then the link no longer works in the survey field app. Has anyone else experienced this issue? I have esri support looking into it. Josh
... View more
09-23-2019
05:42 AM
|
0
|
2
|
1048
|
|
IDEA
|
Secondly, are you saying assignments should so in the Survey123 Inbox? Why not use Workforce for ArcGIS and configure a Survey123 form to allow users to submit assignments and assign them that way if they absolutely need to do so in the field? Hi Marvin, . I do not have much experience using Workforce but from what I've gathered tinkering with it, it doesn't seem to work offline. If there is a way to do this in an offline environment i would be interested but i don't know what type of workflows that would create for crews or the lonewolf gis guy (me). I would say that my primary concern is connectivity, our system is very rural. Also, I am looking for a simple no frills system that is rock solid dependable for offline use and that doesn't require a lot of processing from my end. I first tried collector but couldn't get it to work for offline use. I settled on Survey123 because i have a history with it and the inbox will give my vegetation management contractors a simple method of receiving and completing their work in an offline environment. The only thing that they are not able to do is see the pictures taken from the inspectors. The other part adding pictures without needing a repeat would be a bonus but i agree with you there is a workaround, i've just never tried to use it because i try to avoid related tables whenever possible. Josh
... View more
09-18-2019
01:40 PM
|
0
|
1
|
3156
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 02-17-2025 05:20 AM | |
| 1 | 04-24-2024 05:28 AM | |
| 15 | 11-06-2022 04:59 AM | |
| 1 | 08-16-2019 07:57 AM | |
| 1 | 03-21-2018 09:38 AM |