Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
2 days ago
Solved

Formula needed to pull out most recent status of a logged multiple choice field

I have a multiple choice field, PICC Request Status, that is also a logged field. Most recent choices are at the top and on their own line. Trim(Right([PICC Request Status],"]")) pulls out the first...
formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    2 days ago

    Tag teaming with my buddy Don,

    You are doing two things that are unusual, the prepending newest at the top and using the entries on a separate line causing those dashes.

     

    Try this ridiculous looking formula

    NotLeft(SearchAndReplace(Left(NotLeft([PICC Request Status],"]"),"["),"-",""),2)

     

     

DonLarson's avatar
DonLarson
Qrew Elite
2 days ago

Dawn,

I like to do these in stages so I can follow my logic

var text ParseOne = Right([PICC Request Status],"]");
var text ParseTwo = Right($ParseOne, "-");
$ParseTwo

Give this a try.

DawnRene3's avatar
DawnRene3
Qrew Trainee
2 days ago

Don, that was close. But it pulled out the oldest status, not the most recent status, with a space before it. 

 

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 days ago

    Tag teaming with my buddy Don,

    You are doing two things that are unusual, the prepending newest at the top and using the entries on a separate line causing those dashes.

     

    Try this ridiculous looking formula

    NotLeft(SearchAndReplace(Left(NotLeft([PICC Request Status],"]"),"["),"-",""),2)

     

     

    • DonLarson's avatar
      DonLarson
      Qrew Elite
      2 days ago

      Dawn,

      Do it Mark's way and you will get the first entry from the bottom.

    • DawnRene3's avatar
      DawnRene3
      Qrew Trainee
      14 hours ago

      Mark, as crazy as that looks it worked like a charm! Thank you! It pulled the most recent Status only with no dashes or spaces.