Convert char to ascii value

Hi ‌

Can you explain your requirement a bit further? What are you evaluating to get the char?

Hi,

The Requirement:

   (A Tasklist) I'd like to auto-assign all new Employees with surnames begining A~I, to Team A, and surnames J~Z to Team B.

To do that I'm extracting the first character of the surname and trying to compare with ascii values to determine greater or less than.

I'd also appreciate any approaches to this workflow.

Hi Moses I‌

This is how i would approach this

First of all I have a Build String action configured:

This would give me the first letter of the title field in upper case

eg Crawford, Paul = C

Next i have a Set a condition action configured:

The regular expression matches and character between A-I

This evaluates the variable and if it matches the regular expression the workflow will continue down the yes branch, if not it will continue down the no branch.

Yes - assign A-I to team A

No - assign J-Z to team B

Hope this helps

‌ ‌ ‌‌

This is brand new information! Who knew you could run regex in a set a condition action?!