AnsweredAssumed Answered

Let Function Help

Question asked by JasonPenner on Jun 16, 2015
Latest reply on Jun 16, 2015 by philmodjunk

Title

Let Function Help

Post

I'm trying to set up an input field that upon saving the data will evaluate if there's a letter at the end of the input. If there is I need it to then choose the long version of the unit. For the sake of testing it out I used the value "50r". I was expecting to get back "Reps" but I'm getting "r" as a return. What am I doing wrong? I know if I were just put in "r" as my calc I would get "Reps" returned.  

 

Let (

[

r="Reps";
s="Secs"; 
m="Mins"; 
h="Hrs"; 
e="Meters"; 
k="KMs"; 
f="Feet"; 
t="Miles"; 
j="Jumps"; 
l="Lengths"; 
o="Rotations"; 
p="Laps"

] ; 
Right ( "50r"; 1 ) )

Outcomes