Latest Contributions by JoshHabel

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

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

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

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

That worked! Thanks, Josh ... View more

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

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

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

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