- Posts: 23
- Thank you received: 0
Using Fee value in Fee formula field
- Donna Torr
- Topic Author
- Offline
- Junior Member
-
Less
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
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.
- Leon Treff
- Offline
- Premium Member
-
Less
More
- Posts: 137
- Thank you received: 30
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
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
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
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
-
Less
More
- Posts: 23
- Thank you received: 0
6 years 9 months ago #118011
by Donna Torr
Replied by Donna Torr on topic Using Fee value in Fee formula field
- Tuan Pham Ngoc
- Offline
- Administrator
-
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
[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
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.