Latest Contributions by JamesTedrick

Hi, Dynamic selects from CSV data is not supported yet.  The current solution would involve creating a choice list in the form's excel file whose values are an id field in the CSV.  Updating the CSV would require a republishing of the form anyway, so the choice list can be updated at the same time.  Thanks for pointing out where the doc got a little stale! ... View more

Hi Weng, Right now, there isn't an elegant workaround- the best that you could do is to create a set of select_multiples that are relevant based on the select_one that is selected and then process the data in another field by adding the values together as a form of coalesce.  An example is attached ... View more

Hi Mike, Depending on what you are wanting as a report, there are several possible options. Data Driven Pages enable you to create a layout/report for each survey response. Essentially, it uses a template layout and updates it for each feature as it steps through each row in the table.  Without any coding, the layout can include one or more maps (say, detail/overview) and attribute information.  With some python scripting to extract and maintain linkages, it can also include attachments. Survey123's Analyze tab can provide a summary report of the surveys collected.  Further work can be done by exporting to a CSV and loading into another tool, like Excel. ... View more

Hello, What you would want is the sum() operator, which would add up the value of a field across repeats.  We currently do not yet have support for that function. ... View more

Currently, we do not support the functions that work across the values of a field in repeats, like sum() .   ... View more

Currently, we don't have a way to manually set bins.  We want to be able to support more customizing with the charts in the future, but don't have a timeline for that yet. ... View more

Currently, min() only supports the comparison of two values.  You could achieve what are trying to do using a set of nested min functions: min( min(${DueDate1},${DueDate2}) , min(${DueDate3},${DueDate4}) ) ... View more

Yes, please e-mail me to continue the discussion. ... View more

I'm not sure why you're not getting the resultUrl in the intermediate requests- it has always shown up in the job info I see.  I've updated the github repo to test for that property before assignment and also display the export sync messages to see if that provides more info. ... View more

My apologies for not getting back to you.  I've logged this in our issues list to work on. ... View more

It looks like several of your functions use division.  With the default value of 0, some of the fields are not displaying an answer asa you get a 'divide by 0' error.  As I go through entering in the value of 1 into the survey, the calculations appear.  Is this the error you are seeing? ... View more

Can you share your xls file? ... View more

Hi, I'm not sure what the installation would not have the .exe file.  Can you uninstall and re-install?  Also, if Desktop shortcuts aren't getting cleaned up by the uninstall, delete those as well. ... View more