Calculate order quantity for a specific category
If you have created a separate page with the title “Desserts” and added different product items, then you can use the QUANTITYIN function to calculate the order quantity for that category.
Login to Neartail > click on the form to open it > Edit page will be displayed > In the Neartail Edit page, click on the + Add field icon > enter the title (for example, Desserts Order Quantity), select the Short answer question type > click on the settings gear icon > Question settings page will be displayed > click Answer > enter the QUANTITYIN(“Desserts”) formula in the Calculate option and click Save.
Calculate order amount for a specific category
Login to Neartail > click on the form to open it > Edit page will be displayed > In the Neartail Edit page, click on the + Add field icon > enter the title (for example, Desserts Order Amount), select the Short answer question type > click on the settings gear icon > Question settings page will be displayed > click Answer > enter the TOTALIN(“Desserts”) formula in the Calculate option and click Save.
Note: The title you add in the formula must exactly match the title of the category page. It is case-sensitive.
Comments (1)
Jun 2
Calculate order quantity for a specific category If you have created a separate page with the title “Desserts” and added different product items, then you can use the QUANTITYIN function to calculate the order quantity for that category. Login to Neartail > click on the form to open it > Edit page will be displayed > In the Neartail Edit page, click on the + Add field icon > enter the title (for example, Desserts Order Quantity), select the Short answer question type > click on the settings gear icon > Question settings page will be displayed > click Answer > enter the QUANTITYIN(“Desserts”) formula in the Calculate option and click Save. Calculate order amount for a specific category Login to Neartail > click on the form to open it > Edit page will be displayed > In the Neartail Edit page, click on the + Add field icon > enter the title (for example, Desserts Order Amount), select the Short answer question type > click on the settings gear icon > Question settings page will be displayed > click Answer > enter the TOTALIN(“Desserts”) formula in the Calculate option and click Save. Note: The title you add in the formula must exactly match the title of the category page. It is case-sensitive.
Add your comment
Add photo