You can use the CHARGE function to calculate the delivery fee based on the answer selected for the Collection question. Please follow the instructions below.
In the Edit page, click on the gear icon next to the Delivery Fee question > Field settings page will be displayed > click Answer > delete the existing formula and add the below CHARGE formula in the Calculate option and click Save.
CHARGE(Collection, 5, 0 )
5 is the fee for the first answer choice (Delivered), 0 is the fee for the second answer choice (Pickup). Please note that you must type @ and select the Collection field from the list when adding the formula in the Calculate option.
Please try this and confirm.
Comments (1)
Oct 31, 2023
You can use the CHARGE function to calculate the delivery fee based on the answer selected for the Collection question. Please follow the instructions below. In the Edit page, click on the gear icon next to the Delivery Fee question > Field settings page will be displayed > click Answer > delete the existing formula and add the below CHARGE formula in the Calculate option and click Save. CHARGE(Collection, 5, 0 ) 5 is the fee for the first answer choice (Delivered), 0 is the fee for the second answer choice (Pickup). Please note that you must type @ and select the Collection field from the list when adding the formula in the Calculate option. Please try this and confirm.
Add your comment
Add photo