Nic Windley asked 3 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
Staff replied 3 years ago
Would the ranges be a drop-down field or what kind of input field would that be?
replied 3 years ago
Thanks for the response Bobby. The ranging would be based on qty which is usually an input field.
Staff replied 3 years ago
This is probably the most appropriate approach:
https://formidableforms.com/knowledgebase/field-calculations/conditional-calculations/#kb-calculate-total-cost-per-number-of-units
replied 3 years ago
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.