AnsweredAssumed Answered

Conditionally Replace a field

Question asked by jaywalker7 on Mar 15, 2018
Latest reply on Mar 15, 2018 by jbrown

Hey Forum,

 

I want to replace a short string/number with a different string depending on wht is in the first string.

Specifically, if var1 = "1" then i want it to be "very light"

if var1 = "2" I want it to read "light"

and so on until you reach var1 = "5" which translates to "excessive"

I also have a var2, var3, var4, and var5 - all of which I want to do this same translation

 

My current method would require me to run through a loop for each variable, meaning five different long loops. Is there a way to shorten this process/ Can I replace the values in some umbrella function?

 

Thanks!

Outcomes