Survey123 Populate a cell based on a previous choices list.

Question

Hey Gang,

In a column, I have a select_one function from a choices list of 45 string values. I am trying to populate a cell with an integer value based on this first choice. from a second choices list.

The first Choice list looks like this;

LotAcadia Street West (6)Acadia Street West (6) - 12

The second choice list looks like this;

LotnAcadia Street West (6) - 1212

I can build out a series of If statements (45 in Total), but just wondering if I can populate the second field with an integer from the second choice, based on what I chose from the first Choice List.

Hope this makes sense.

T.

JamesTedrick · Answer

Hi Trevor,

Typically, you would use the integer value as the name value of the list, which would get you the value directly.