asha gopal Avatar

asha gopal

Ghama Ghama Bhojana

hello, I just started using neartail forms instead of google forms. After all the customers add their details in the order form. I would like to see names in one column and each products in individual columns. what time they arre interested to pickup food that will be in another column but all of this in the same page how I used to get it in google sheets when people order in google form. could you please help me with that. Thanks.
Hi Asha, if you would like to export the responses to Google Sheets similar to the Google Forms format, then please follow the instructions below. Sync Google Forms responses to Google Sheets Login to Neartail. Click on the form to open it. Edit page will be displayed. In the Neartail Edit page, click on the gear icon next to the form title. Form settings will be displayed. Click Advanced. Click Launch to open Google Forms. In Google Forms, click Responses and click on the spreadsheet icon to sync responses to Google Sheets. All the fields in the form are included as columns and each row is a response. Export order line items data from Neartail Reports If you used the Neartail templates to create your order form, then you can sync the data to google sheets. Login to Neartail > click on the form to open it > Edit page will be displayed > click Reports > click on the sync button in the bottom right corner. The responses will be synced to Sheets ONLY when you click on the Export button in Neartail. When you sync the Neartail reports to Google Sheets, we create three sheets. (1) Order summary: This includes the customer contact details, amount and other fields in the form. (2) Order lineitems: This includes the order lineitems data. You can use the pivot table option on this sheet to create the aggregate reports you need. (3) Order details: This includes the quantity ordered for the products in each order. Each product will be added as a column. For products with variants, each variant will be a separate column. Please try this and confirm.
Fri Nov 10 2023
| 2 Replies
I would like to edit the form every week but I don't want to have the previous week's history, for example previous orders. also I would like to know how to delete orders that I used for testing purpose.
Delete redundant 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. Please note that you cannot change the order status for abandoned orders. You can move redundant responses to Trash status. These responses will not be included in the Reports. Enable Strict Privacy You can enable the Privacy option to delete the responses in Abandoned and Trash status permanently. Login to Neartail > click on the form to open it > Edit page will be displayed > click Orders > In the Orders page, click on the three dots next to the Abandoned or Trash status > You can enable or disable the privacy settings. When enabled, the responses in Abandoned and Trash status will be automatically deleted after 7 days. Please note that the Abandoned status will be automatically hidden when the privacy option is enabled. Weekly order form Instead of editing the existing form and deleting the orders each week, you can make a copy of the existing form, edit it to add the products for that week and then share the link with your users to collect orders. Login to Neartail > List of your forms will be displayed in the Forms dashboard > click on the More option for the form you would like to duplicate > click Make a copy.
Sat Nov 11 2023