• Resolved rja.tcu

    (@rjatcu)


    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]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Wow-Company

    (@wpcalc)

    You can use the dropdown menu for selected the values.
    Like

    5 cm = 5.2

    Thread Starter rja.tcu

    (@rjatcu)

    ????????

    Actually it’s a bit more complicated, since I have two data charts (one for girls, and one for boys).

    But I guess I can manage from here now!
    ??????

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Array lookup instead of formula’ is closed to new replies.