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;
Lot | Acadia Street West (6) | Acadia Street West (6) - 12 |
The second choice list looks like this;
Lotn | Acadia Street West (6) - 12 | 12 |
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.
Hi Trevor,
Typically, you would use the integer value as the name value of the list, which would get you the value directly.