Jess147 Posted January 31, 2019 Report Share Posted January 31, 2019 How can I calculate the amount to be paid by customer? If user enters 1-amount is $5, if 2- $20, if 3- $35. TIA Quote Link to comment Share on other sites More sharing options...
0 JolliBeng Posted January 31, 2019 Report Share Posted January 31, 2019 Hi Jess147, You can create a Calculated Value for that. You can try the following formula: CASE WHEN [@field:Amount_Paid] = 1 THEN 5 WHEN [@field:Amount_Paid] = 2 THEN 20 WHEN [@field:Amount_Paid] = 3 THEN 35 END You just need to change the field name. -JolliBeng Jess147 1 Quote Link to comment Share on other sites More sharing options...
0 Jess147 Posted February 1, 2019 Author Report Share Posted February 1, 2019 This works! Thanks a lot JolliBeng! Quote Link to comment Share on other sites More sharing options...
0 JckDY Posted February 3, 2019 Report Share Posted February 3, 2019 you can also try putting the formulae in a formula filed so it can be also saved on your table Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted February 15, 2019 Report Share Posted February 15, 2019 In submission page you can select calculated value as form element for the amount : CASE WHEN [@field:Amount] = 1 THEN 5 WHEN [@field:Amount] = 2 THEN 20 WHEN [@field:Amount] = 3 THEN 35 END Quote Link to comment Share on other sites More sharing options...
Question
Jess147
How can I calculate the amount to be paid by customer? If user enters 1-amount is $5, if 2- $20, if 3- $35.
TIA
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.