Forums - Thread Details
  • State Verified Answer
  • Replies 1 reply
  • Subscribers 319 subscribers
  • Views 754 views
  • Users 0 members are here
Forum Actions
Related

calculated field get text from field based on dropdown

Joe Carter

Hi

I want to copy a value from a field based on a dropdown.  The statements below work if there is only one in the formula box but I need all 4.  Can anyone explain what I am doing wrong and any pointers on how to do it.

ifElse(equal(getDropdownValue("ce_no_of_users_list",$no_of_users),1),$one_user_price,"0.00")

ifElse(equal(getDropdownValue("ce_no_of_users_list",$no_of_users),3),$three_users_price,"0.00")

ifElse(equal(getDropdownValue("ce_no_of_users_list",$no_of_users),4),$four_users_price,"0.00")

ifElse(equal(getDropdownValue("ce_no_of_users_list",$no_of_users),"Unlimited"),$unlimited_price,"0.00")

  • 0

    Sorry solved it,

    ifElse(equal(getDropdownValue("ce_no_of_users_list",$no_of_users),1),$one_user_price,
    ifElse(equal(getDropdownValue("ce_no_of_users_list",$no_of_users),3),$three_users_price,
    ifElse(equal(getDropdownValue("ce_no_of_users_list",$no_of_users),4),$four_users_price,
    ifElse(equal(getDropdownValue("ce_no_of_users_list",$no_of_users),"Unlimited"),$unlimited_price,"0.00"))))