Nic Windley asked 2 years ago
Hello Community
I have some complex pricing formulas that require lookups and I'm thinking about using Formidable Forms.
Due to the distribution of values 0-10000 it would be more efficient to be able to enter ranges instead of 10K discrete values.
What I would like to be able to do is define the ranges and their values and when a lookup value falls between the range to have the respective value returned. Is this possible with FF ? If so, could you provide some pointers on how to achieve that please.
Example Range & Values
0-10 = 50
11-499 = 100
500-300 = 750
Many thanks,
Nic
Please login or Register to submit your answer
Would the ranges be a drop-down field or what kind of input field would that be?
Thanks for the response Bobby. The ranging would be based on qty which is usually an input field.
This is probably the most appropriate approach:
https://formidableforms.com/knowledgebase/field-calculations/conditional-calculations/#kb-calculate-total-cost-per-number-of-units
Great. I'll check it out. A lookup table would be ideal as I can auto generate that from something like Excel and I have about 50 breakpoints to deal with and 5 variations. However, I could probably auto generate the conditions based on the tabulated data in Excel.