Pipefy Automations don’t limit me when inputting formulas for the formula automation.
That makes me a bit confused, since I cannot imagine how certain things work, and I would be thankful for clear description.
Example of where the confusion comes in:
Let’s say I have a pipe, Sales, and a connected Database, Products, each with a price and a quantity. Consequently, for a card in Sales with multiple Products, one can argue price and quantity to be vectors. If I do SUM(MULTIPLY(price, quantity)), do I get the toal price of a card in Sales with all the connected Products, or does it work differently and e.g. MULTIPLY does a cross product rather than a component-wise multipication?
And what if I say I have two connected databases with different numbers of entries, i.e., I separate Products and Quantity into two databases and the user can select just one Product but multiple quantities – does the product price vector automatically scale to the size of the quantity, or the quantity vector to the size of the products?
