I want to create a simple VLOOKUP style search in a list.
1. Costum module with two fields:
(CategoryID), (CategoryName) - these are unique values (like ZIP codes, or VAT numbers)
2. Accounts module with three costum fields:
(BusinessLongCode), (BusinessShortCode), (BusinessCategoryName)
(BusinessLongCode) is a text field with(16) 16 numbers - this is the entry and editable input field.
(BusinessShortCode) is a text feld with(2) 2 numbers - based on BusinessLongCodes first two numbers, with:
And here is the problem:
I want in Accounts module (BusinessCategoryName) field to auto filled from Costum modules record (CategoryName) if (BusinessShortCode) is equal with (CategoryID).
What i tried (in the Accounts module, in the BusinessCategoryName):
But its not working, i get the "No match" value from the ifElse all the time, but the values in BusinessShortCode and Category id is match.
How to implenet the right calculated field code?
Thank you for your help!
*We Have SugarCRM 7.X Professional on our own server.