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

ShariForbes

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. 

LWYL_fromscatchTestSite1.xlsx

DeonLengton

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.

 

LWYL_fromscatchTestSite1.xlsx