Inventory
toNumber(prop("Price 1")) + toNumber(prop("Price 2"))Test Rollups in Formula with toNumber
Now let's discuss a workaround for rollup values within a complete database with multiple variables. The final database properties are as follows:
- Quantity - Number
- Item - Relation
- Price - Rollup
- Sent - Checkbox
Here is what the sum formula will determine:
If Sent 1 and Sent 2 checkbox true, then multiple Quantity 1 by Price 1 → add sum to Quantity 2 multiplied by Price 2
((prop("Sent 1") and prop("Sent 2")) == true) ? (prop("Quantity 1") * toNumber(prop("Price 1")) + prop("Quantity 2") * toNumber(prop("Price 2"))) : 0Test Checkbox Rollups in Formula