select_one - no integer values

Nicole_Ueberschär

Hello everyone, 

I have a form with two select_one fields where the value is an integer value with a text label. Even with saving the result from the select_one field as an integer value to a calculate field it will not be recognized as an integer value. When I try to calculate the average of the choices, it gives me just some weird numbers. It works though if I use an integer question to save the value from the select_one question as integer. But this looks awful (and stupid) in my form, I would rather hide this step if somehow possible. 

Anonymous User

Hi Nicole,

This is the expected behaviour, as a select one question is actually a text field due to it being a choice list, even though you may use numbers as the choices, if you look in the feature layer and the esri field type, you will see it is always a string field. 

Therefore you can not apply mathematical equations to a string field the same as you can for integer and decimal. The ebst way around this is to use a hidden question type (so the user doesn't see it) and put the value on the select one into this hidden question by a simple calculation that references the select one, and then use the hidden question in your further calculations in other questions.

We have an enhancement in our backlog to honour the bind:type field for select one questions, as currently that does not work, which would allow setting it as "int" which would mean it is treated as an integer even though the values are stored as text. 

Phil.