Survey123 Connect: Select_one question chooses lowest descending string value from 8 other select_one questions.

138
1
04-09-2020 10:49 PM
MasonPahl1
New Contributor

I have 8 categories (fields) of inspection components: each component has its own defect rating (select_one, A-E).

ratingAA
ratingBB
ratingCC
ratingDD
ratingEE

The structure is usually (but not always ugh) summarized by the worst rating of all of the 8 components (A is best, E is worst). I have created an 'Overall_rating' field, I need it to pick to the lowest alphabetical letter of the 8 separate select_one choices. No idea where to begin. I thought of changing the choice values to integers but not sure if that makes it easier or harder. 

Thanks in advance.

0 Kudos
1 Reply
DougBrowning
MVP Notable Contributor

Little clunky but not too bad.   Do a concat on all the CAV values.  Then a big if statement.  If contains E, E, if contains C, C, etc.  If you just have A-E not so bad.

Hope that helps.

0 Kudos