To change a String into an Integer, the Int32 C# library must used, for example,
Int32.Parse([#MyString#])Note that if the string is not a number, the process will error. Int32.TryParse is not available in functions to check that the string parses to a number.
This is handy for ordering lookups without changing advanced settings by entering the order of a lookup in the Description field. Multiple levels of ordering can be easily combined. For example, details with and order could be sorted with a grouping characteristic:
(100*Int32.Parse([#GroupOrder#]))+Int32.Parse([#DetailOrder#])