Effective Release Date: January 10, 2017
In this release we have added a new function to the list of existing standard function i.e. FAST_TLOOKUP . The Syntax for the function is as follows .
FAST_TLOOKUP("SELECT field1 FROM table1 WHERE field2 = ( fName )
The FAST_TLOOKUP is also backward compatible with TLOOKUP function which means you can use the function FAST_TLOOKUP like shown in below
FAST_TLOOKUP("SELECT field1 FROM table1 WHERE field2 = '" + VALUE("fName") + "'")