Array lookup instead of formula
-
Hello,
Please allow me to ask one more question.
I try to recreate the above Ultrasound Gestation Period calculator with my own data.
However, the result is not based on a formula but instead on a data chart.
The data looks as follows (just an example):
____________________EL: embryo lenght in cm PW: pregnancy week ------------------ EL PW 1 3.0 2 3.5 3 4.1 4 4.6 5 5.2 . . . . . . 60 42 62 43 64 44
____________________
Example:
The user selects EL in a dropdown menu, e.g. 5 cm. Then the calculator form shall return 5.2 weeks.Based on your description I should use the Conditional Formula to solve this. This would mean 64 nested if-then-else statements, which is rather tedious.
Is there a more efficient way to code this?
Like are there more formula types that your plugin can handle and that you didn’t mention?
E.g. can your formula field handle data that is stored in an array?Thanks for any feedback in this regard.
Best Regards.The page I need help with: [log in to see the link]
- The topic ‘Array lookup instead of formula’ is closed to new replies.