I am trying to find a process where I can display 2nd field value when I type in mix case value in a 1st field (String Type). Hope someone might have already done this similar scenario or might know how to do it. Your help would be greatly appreciated.
I have a 1st field called "Customer" (String Type field) and 2nd field called "Market" (look up list type field). Now, for Produce and Market field I have hard coded in workflow as follow:
If FieldName= "BG_USER_01" Then ‘CUSTOMER
Select Case Bug_Fields(FieldName).Value
Case "salex" _
Bug_Fields("BG_ USER_02").Value = "local" ‘MARKET
Note: I choose to do with case statement cause I have several customers and Market list.
In my above code I would like to implement mix case condition. When I have mix case, I do not have to worry how I type in about customer First name initial and complete last name.
Now, When I type in Customer's First name initial and complete last name example: salex or SAlex or Salex in "Customer" field, I should get correct value in my 2nd field which is "Market". The correct value for Market in this case is "local".
So, how I can set up upper-case or lower-case ignorance condition to satisfy my scenario? Please advise.
Marked as spam
Question ID: 108513