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