Community
Hello,
I made a meal order form for our school cook. There are two possibilities: children can eat a meal during lunch at school or families can order a take-away meal (with warranty on re-usable glass containers).
Our products are configured per day: e.g. September 5th - Soup - School, September 5th - Meal - School, September 5th - Soup - Take-away, September 5th - Meal - Take-away in various portion sizes.
Families can order for one month (each month will be a form).
I have two questions:
I. I included ${response()} in the e-mail confirmation to the customers. Not all amounts are shown with the €-sign.
Amount meal orders is calculated with TOTAL() and has an €-sign in the overview of the responses.
Because take-away meals are delivered in glass containers with a warranty, I configured two extra calculations:
1. Amount of warranty
2. Total amount = amount meals + amount warranty
These last two amounts have no €-sign in the overview of responses.
All three of them are configured as a number.
Is there any way I can have them shown in euro?
II. Customers can cancel orders up until a certain time before delivery. We chose not to allow customers to change orders once submitted. Is there a way for the admin to cancel a submitted order? I know how the admin can change orders, but I'm looking for a way to cancel it entirely. We want it to disappear from the reports. Orders are typically done way up front. Our cook relies on the reports to know how many soups - meals in which sizes she has to prepare each day for school / take-away, she doesn't handle order by order.
Just wanted to say that the Neartail Order Form is a huge way forward to the old way via simple Google Form and calculations in Google Sheets.
Thank you in advance for your help with my questions.
Best regards,
Martje
Comments (1)
Jul 14, 2024
Email notifications ${response()} formula will show a summary of all the answers in the form (products ordered + other fields in the form such as contact details, address etc) ${BILL()} formula will show a summary of the products ordered in the bill format. It will include the product name, quantity, unit price and amount Order summary / Formatting amounts Summary settings page allows you to select the relevant fields from the form for the Amount, Discount, Tax, Delivery Fee, Tip, Net amount option. The mapping in the Summary settings allows Neartail to identify the field with the amount to be charged and pass this amount to the selected payment option such as Stripe or Paypal and also show the order summary. If you have mapped a field for the Net amount option, the answer for that field will be passed to the selected payment options. Otherwise, the answer for the field mapped for the Amount option will be passed to the selected payment options. We do not have a specific setting for Warranty amount. You can map this field to the Delivery fee or the Tip option in the Summary settings. Login to Neartail > click on the to open it > Edit page will be displayed > In the Neartail Edit page, click on the form title to select it > click on the gear icon next to the form title > Form settings page will be displayed > click on the configure key fields icon next to the Save button in the bottom right corner > Summary settings page will be displayed > select the warranty amount field for the Tip option and click Save. Calculate total amount including warranty In the Edit page, click on the Add price field icon > select Net amount, click Next > select Standard calculation using NETTOTAL() formula, click Next > click Create. When you use the Add price field option, it will automatically map the field in the summary settings. NETTOTAL function calculates the net amount based on the fields mapped in the Summary settings page. It will automatically add the fields mapped for Amount, Delivery Fee, Tip, Taxes and subtract the Discount to calculate the net amount. Edit order Login to Neartail > click on the form to open it > Edit page will be displayed > click Orders > In the Orders page, click on an order to view the details > click on the three dots more icon > click Edit > the order will open in a new tab > you can amend the order and submit it. Delete orders Login to Neartail > click on the form to open it > Edit page will be displayed > click Orders > In the Orders page, you can drag and drop (place the cursor on the profile image/default icon to drag) orders to the Trash status or click on an response to view the details, select the Trash status for the Move to option and click Submit. The orders in the Trash status will not be included in the Reports.
Add your comment
Add photo