Latest Contributions by JoshHabel

‎04-14-2022

Hello, I am having trouble with the Pulldata function when trying to work with a agol hosted csv file. My goal is to use a Pulldata function to do a lookup on a hosted csv file using the devices "deviceid" to return the users name and possibly additional info in the future. My formula pulldata('myusers', 'users', 'devices', ${ms_deviceid}) appears correct from what i can tell but it does not return anything. I've attached my test survey and csv file that i'm working with. PS The reason i'm trying to grab the user name this way instead of using the username field is that not all my users will have a esri login. This will be a publicly shared survey. Josh

‎12-10-2021

Johannes, Tried your expression above and it worked great! See below... Really appreciate the help!! Have a good holiday! Josh

‎12-08-2021

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

‎12-07-2021

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));

‎12-02-2021

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))

‎07-26-2021

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

‎07-23-2021

That worked! Thanks, Josh

‎07-08-2021

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

‎06-17-2021

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

‎02-11-2021

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>')

‎02-06-2021

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

‎06-05-2020

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

‎04-17-2020

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

‎09-24-2019

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

‎09-23-2019

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

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by JoshHabel

Pulldata From Linked csv Not Working

Re: Cumulative Chart With Arcade Expression

Re: Cumulative Chart With Arcade Expression

Cumulative Chart With Arcade Expression

Re: Create accumulative charts in Dashboards

Re: Add Dynamically Persistent Answers in Survey123

Re: Help! Inbox Not Returning Repeats

Help! Inbox Not Returning Repeats

Append Data Tool Failing To Maintain Attachments

Re: Survey123 Tricks of the Trade: Web form URL parameters

Updating Public Survey Causes Unpacking Failure

Re: Survey123 Tricks of the Trade: Embedding a survey in an ArcGIS Dashboard

Populate Address From Geopoint Question?

Re: Html Link Causing Data Errors

Html Link Causing Data Errors

June 2026 Update #Everything you’ve built still wo...

Re: Agol External Hosted csv Choice List Not Worki...

Re: TGI5 Episode 077 - Managing ArcGIS Online Cont...

Allow Button Widget To Update Attributes

Re: Survey123 'username' field is <Null>