The formula is designed for easily specifying the cost term. It follows the input and output manner. It accepts multiple inputs and yields one output. The output will be stored in a cache table for future use.
The type suggestion engine will suggest a proper cache type for you based on the input type and output type of the formula specified, which help you avoid conflicts.
The Visual Formula is divided into two main components, cache, and pure formula.
The goal of cache is to cache an item’s data in a separate table. It can avoid accidentally modifying the Item data in the calculation, which may cause unnecessary surprises. You can do whatever you want with the cached data, and the changes would not be applied to the item’s data.
Pure Formula
It computes the cached data and puts the result into the cache.
More formulas are coming.
An example of the cache formula.