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.
Solved! Go to Solution.
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.
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.
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.