Hi everyone, I'd like to ask if anyone has an experience with using formulas for product pricing. This is my use case - I'm building new workflow for our standard Order Forms and I'm thinking how to implement our pricing to it. We have several editions of the main product and then several add-ons. Each edition has a standard pricing that is prepared for several currencies. My idea is to build a workflow that would automate: if "product X" + if "USD" then "price XY".
Basically I'd like to add the entire pricing matrix to IC - I don't need add too many items so I've started working on the fixed table with conditional fields (for example value "Y" is under the condition "plan X", etc). However, this is getting messy and I'd like to automate it if possible.
Does anyone has any similar use case and would like to share some tips? 😊 I'd be super grateful as I'm still not sure how to use formulas properly 🙈
Thanks in advance!
