Using Fee value in Fee formula field

  • Donna Torr
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
6 years 9 months ago #117983 by Donna Torr
Using Fee value in Fee formula field was created by Donna Torr
Hi all,

I am looking to have a list box to which there are 2 options:

2 Days
3 Days

The corresponding Fee values are
120
175

In the Fee formula field is it possible to use the associated Fee value?

i.e. If the user chooses 2 Days, I want the formula to be

120*[NUMBER_REGISTRANTS]

if they chose 3 days, I want the formula to be
175*[NUMBER_REGISTRANTS]

Basically, is there a shortcode to call the associated fee value field into the calculation?

Regards
Donna

Please Log in or Create an account to join the conversation.

More
6 years 9 months ago #117987 by Leon Treff
Replied by Leon Treff on topic Using Fee value in Fee formula field
Hello,

I guess your formula should look like this [FIELD_VALUE]*[NUMBER_REGISTRANTS] and it should work as you expect.

Sincerely,
Leon

Please Log in or Create an account to join the conversation.

More
6 years 9 months ago #117993 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Using Fee value in Fee formula field
Hello

The suggestion from Leon should work. Or better, you can use the syntax [NAME_OF_FIELD_IN_UPPERCASE], it should work, too. For example, if name of this custom field is eb_number_days, then fee formula could be
[NUMBER_REGISTRANTS]*[EB_NUMBER_DAYS]

Please try that and let us know if it works

Tuan

Please Log in or Create an account to join the conversation.

  • Donna Torr
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
6 years 9 months ago #118011 by Donna Torr
Replied by Donna Torr on topic Using Fee value in Fee formula field
Thanks Both, unfortunately this does not use the fee value field it only multiples it by the number in the list box (i.e. 2 or 3).

Please see screenshot attached. At present i have [FIELD_VALUE]*[NUMBER_REGISTRANTS] in the fee field.



Regards
Donna
Attachments:

Please Log in or Create an account to join the conversation.

More
6 years 9 months ago #118023 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Using Fee value in Fee formula field
Hello Donna

[FIELD_VALUE]*[NUMBER_REGISTRANTS] is not the right formula. [NUMBER_REGISTRANTS] must be replaced with name of the field No of days Required (in upper case)

Try to change it and it should work. If you still cannot get it works, submit a support ticket sending us super admin account and link to the form so that I can configure it for you

Regards,

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc