topic Re: New Error class java.lang.Double cannot be cast to class java. lang. String in ArcGIS Survey123 Questions

New Error class java.lang.Double cannot be cast to class java. lang. String

ShariForbes — Fri, 01 Oct 2021 18:09:36 GMT

Hello. A few days ago our calculation to prepopulate a field based on the default of another field and worked fine but now we get that java error that I don't fully comprehend.

For ProjectNo X, fill in Project Address, like follows.

if(selected(${ProjectNo}, '1'), '783 Antoine Dr', if(selected(${ProjectNo}, '2'), '860 Acadia Dr’, if(selected(${ProjectNo}, '3'), '770 Andre Ct’, if(selected(${ProjectNo}, '4'), '860 Cambridge Dr’, if(selected(${ProjectNo}, '5'), '868 Cambridge Dr’, if(selected(${ProjectNo}, '6'), '812 Grand Teton Dr’, if(selected(${ProjectNo}, '7'), '929 Grand Teton Dr’, if(selected(${ProjectNo}, '8'), '3321 Nice Dr’, if(selected(${ProjectNo}, '9'), '784 Noel Trl’, if(selected(${ProjectNo}, '10'), '768 Pierre Ln’, if(selected(${ProjectNo}, '11'), '804 Rushmore Ln’, if(selected(${ProjectNo}, '12'), '753 Warwick Dr’, if(selected(${ProjectNo}, '13'), '3301 Thunderbird Ln’, ‘Please choose a project number’)))))))))))))

I've attached my .xls form too. Appreciate any advice.

Re: New Error class java.lang.Double cannot be cast to class java. lang. String

DeonLengton — Mon, 04 Oct 2021 08:31:44 GMT

Hi Shari

I found a few issues in your survey. Your if statement contains inconsistent single quotes - some of them seem to have been copied from Word so they have a different format. I usually copy those text blocks into Notepad to get rid of any special characters and then copy it from there into my Excel sheets.

I do however suspect the biggest problem was that ProjectNo is defined as an integer and the selected() function compares it to a String value. I would change the bind::type for ProjectNo to string it should fix your survey:

bind::type changes the way Survey123 looks at your field in survey calculations such as selected()

I have attached a working Excel design file for your survey.

Hope that helps.

Re: New Error class java.lang.Double cannot be cast to class java. lang. String

ShariForbes — Tue, 05 Oct 2021 14:02:54 GMT

Deon. Thank you for taking the time to look at my survey and sending me back an improved example.

I appreciate the advice about copying into a text file and I try to do that, but that expression had been copied and pasted so many times I am not surprised something went out of whack.

Thanks also for the tip about bind:type

Every time I do a project with Survey123 I learn something new.