I’ve found the need for an Eval() (Evaluate Function) that would allow you to have a different formula for each record in a table. For example, if you have a field called Formula Text with the following data for the first 3 records:
TRIM(UPPER({Input Field 1}))
CONCATENATE({Input Field 2}, " ",{Input Field 3})
CONCATENATE("Expiration Date: ",{Input Field 4})
The Eval() function would allow you to create a new field called Formula Result, who’s properties are set to Formula with the following formula: Eval({Formula Text}), and the results for the first 3 records would be (I’ve omitted sample data and have just performed the functions in the formula to the names of the Input Fields):
INPUT FIELD 1
Input Field 2 Input Field 3
Expiration Date: Input Field 4
... View more