View responses When responses are synced to Google Sheets, they are always appended at the end. As a result, the sheet displays responses in chronological order, from oldest to newest. This order cannot be changed. We recommend using Formfacade Reports, which allow you to group and view responses by week, month, or year. Export to Google Sheets Formfacade does not have permission to create a sheet in your Drive. When you export data from Formfacade Reports to Google Sheets, the sheet is created in the service account, and your email address is added as a collaborator to provide access. The first column, which contains the unique ID, is locked. You will not be able to delete rows or apply filters that affect this column.

If you are only using cash on delivery and manual Venmo option for payments, there will be no transaction fees from Neartail for those payment methods. However, please note that if you enable automated Venmo payments through a PayPal business account, PayPal will charge a transaction fee.

Hi Marchelle, only submitted orders count towards your monthly limit. Abandoned orders, which occur when a customer starts filling out the form but does not complete it, do not count against your order limit.

If you exceed the 100 responses limit in the Premium plan, you will not be able to collect any additional responses until the next month begins. To continue collecting responses, you would need to upgrade to a higher plan that supports more responses.

Hi Stacia, you can sign up for a monthly subscription, use Formesign to collect e-signatures for just one month and then cancel the subscription before it is renewed for the next month. Monthly subscription is automatically renewed each month and you can cancel it anytime. When you cancel your subscription, it will be valid till the end of the current subscription period.

Login to Formesign > click Forms > click on the form to open it > Edit page will be displayed > click Responses > In the Responses page, click on the three dots more icon next to the Submitted status > click Notify collaborators > follow the prompts to complete the email set up. When the user fills the form and submits it, the email address added in the Notify collaborator setup will automatically receive email notifications for new responses.

Submit to google forms Login to Formfacade > click on the form to open it > Edit page will be displayed > In the Edit page, click on the form title to select it > click on the ⚙️ settings gear icon > Form settings page will be displayed > click Advanced > enable the Submit to google forms option and click Save. Sync google forms responses to google sheets In the Formfacade Edit page, click on the form title to select it > click on the ⚙️ settings gear icon > Form settings page will be displayed > click Advanced > click Launch > Google Forms will open in a new tab > click Responses > click Link to sheet and sync responses to an existing spreadsheet or create a new spreadsheet.

You will be charged a transaction fee per order based on the calculated order amount for submitted orders, regardless of whether payments are enabled. Please note that abandoned orders are not included. For example, if you collect 50 orders with the total amount of $1,000, you will be charged 3% of $1,000 as fees = $30. Your card will be charged on the 1st of every month for the previous months' orders.

Hi Lexie, You can set up your form to record the responses in Google Forms, enable the Link to sheets option in Google Forms to automatically sync the form responses to Google Sheets in real time and use Zapier to integrate with Iterable. Submit to google forms Login to Formfacade > click on the form to open it > Edit page will be displayed > In the Edit page, click on the form title to select it > click on the settings gear icon > Form settings page will be displayed > click Advanced > enable the Submit to google forms option and click Save. Once enabled, new responses will be recorded in Google Forms. Sync responses to Google Sheets Open your form in Google Forms > click Responses > click Link to sheets and follow the prompts to set up the Google Sheets sync. Zapier Google Sheets - Iterable integration You can use the New spreadsheet row trigger to integrate with Iterable. https://zapier.com/apps/google-sheets/integrations/iterable

Hi Roxanne, you can check the email status in the Formfacade Responses page. Login to Formfacade > click on the form to open it > Edit page will be displayed > click Responses > In the Responses page, click on the response to view the details > check the Additional details section. Does it display the email address for the Email respondent / collaborators? - By default, it will display the configure link that indicates that the emails have not been set up. - If the emails are configured and sent successfully, email addresses will be displayed. - Otherwise, it will display the error message or 📫 icon next to the email to indicate that the email was not delivered. Form submissions By default, the responses will be recorded only in Formfacade. You can view the form submissions in the Formfacade Responses and the Reports page. If needed, you can enable the option to submit responses to Google Forms. Submit to google forms Login to Formfacade > click on the form to open it > Edit page will be displayed > In the Edit page, click on the form title to select it > click on the settings gear icon > Form settings page will be displayed > click Advanced > enable the Submit to google forms option and click Save. Once enabled, new responses will be recorded in Google Forms. If you have linked your google forms with google sheets, the responses will be synced to google sheets. Note: Link to sheets is a Google Forms feature. If the responses are recorded in Google Forms, but it is not synced to the linked Google Sheets, then you can try to unlink the form and link it to sheets again. Track submit status We implemented a feature to show a warning message along with the resubmit option for failed submissions. Login to Formfacade > click on the form to open it > Edit page will be displayed > click Responses > In the Responses page, click on a response to view the details > scroll down and check the Additional details section > The status for "Google Forms" should be displayed as "Submitted". Otherwise, it will display the error message along with the option to resubmit.

When you customize your google form using our addon, the service account is added to the google form as a collaborator. If this service account is removed as a collaborator from your form, you will not be able to make edits using the Formfacade Editor. That's why we show a warning message at the bottom of the Edit page. If you have manually added the editor@formfacade.com service account as a collaborator in google forms, then click on the addon icon > click Formfacade > click More options > click Update or Customize to sync the changes. Once completed, you will be able to make the edits directly in the Formfacade Edit page.

Hi Ken, You can set up the email notifications directly in Formesign. Login to Formesign > click Forms > click on the form to open it > Edit page will be displayed > click Responses > In the Responses page, click on the three dots more icon next to the Submitted status > click Notify collaborators > follow the prompts to complete the email set up. When the user fills the form and submits it, the email address added in the Notify collaborator setup will automatically receive email notifications for new responses. Check email status If you have already set up the email notifications, you can follow the instructions below to check the email status. Login to Formesign > click Forms > click on the form to open it > Edit page will be displayed > click Responses > In the Responses page, click on the response to view the details > check the Additional details section. Does it display the email address for the Email collaborators? - By default, it will display the configure link that indicates that the emails have not been set up. - If the emails are configured and sent successfully, email addresses will be displayed. - Otherwise, it will display the error message or 📫 icon next to the email to indicate that the email was not delivered. Note: I replied to your message on 2-Sep, but the email wasn't delivered to truda@tripanicknation.com (see screenshot below). Looks like there is an issue with that email address.

If you would like to collect payments in your form, you must first calculate the amount in the form and then configure the payments. Open your form in Google Forms > click on the addon icon > click Neartail - Order form > click Calculate order amount > select the currency, click Next > select the price option, click Next > click Customize > Order amount calculations will be automatically added in the form > Edit page will open in a new tab > In the Neartail Edit page, scroll down to the payment section > click Enable > Payment settings page will be displayed > click Enable payments > The payment options supported in your country will be displayed > configure the preferred payment options and click Save. You can then use the near.tl share link for your form to collect responses.

Hi Shelley, you can customize the footer text to replace your name. Login to Neartail > click Forms > click on the form to open it > Edit page will be displayed > click Preview > Theme settings will be displayed in the right pane > click Page > Enter the required text in the Business name (header / account name), Footer option (replaces "This site belongs to..."), upload your logo to replace the default profile picture and click Save. 1️⃣ Header text can be customised by free and paid users. 2️⃣ Header logo (applicable only for Minimal theme) can be customised by free and paid users. 3️⃣ Footer text can be customized by free and paid users. 4️⃣ Footer logo can be customised only by paid users. 5️⃣ Disclaimer and report abuse options will always be displayed in the share link.

Formfacade supports public forms only. You must disable Google Forms' features that require signin to use Formfacade. You are facing issues with submit because you have enabled the "Send respondents a copy of their response" option in this form. You must disable this option and then click on the addon icon > click Formfacade > click More options > click Update to sync the changes with Formfacade. You can then use the form to collect responses. For more details, refer to the help article below. Disable features that require signin https://formfacade.com/website/form-not-publicly-visible-fix.html If you need to send confirmation emails, you can set it up directly in Formfacade. Login to Formfacade > click Forms > click on the form to open it > Edit page will be displayed > click Responses > In the Responses page, click on the three dots more icon next to the Submitted status > click Notify respondent > follow the prompts to complete the email set up.

We have integrated with Stripe (Card, Bancontact, Paynow, Cash App, iDeal) and Paypal (Paypal, Venmo) for automated payments. In addition, you can also enable manual & offline payment methods such as UPI, Cash App, Zelle, Lydia, cash on delivery, bank transfer, check. Enable payments 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 Submit button. Button settings will be displayed. Click Enable payments. The payment options supported in your country will be displayed. You can configure the preferred payment options and click Save. Once you complete the setup, you can use the Neartail share link to submit a response and test the payment process to ensure everything is working correctly. Automated payments When this option is enabled, users will be able to submit the order only if the payment is successful. Please note Stripe, Paypal charges a transaction fee. Manual payments When the user submits the form, we automatically generate the QR code/ pay now button that autofills the amount. The payment details are displayed after the user submits the form. Please note that you will have to manually reconcile payments by checking the transactions. When a user places an order, the payment status will be either marked as "Pending" (not paid) by default. If the user clicks on the Mark as paid button, the status will be updated as "Paid, not verified". Once you verify the payment, you can mark the order as "Paid".

When using Neartail with products that have variants, the unique identifier for each variant will always be recorded alongside the variant name in Google Sheets linked with Google Forms. Unfortunately, you cannot remove this unique identifier as it is necessary for tracking orders and inventory. If you need the variant name without the long number, you can view the orders in Neartail Reports or export the data from Neartail Reports to Google Sheets. Login to Neartail > click on the form to open it > Edit page will be displayed > click Reports > in the Reports page, click on the settings gear icon > click Sync all responses. Please note that this is not a real time sync; the responses will be synced only when you click on the sync option in the Reports page. When you sync the responses in Neartail 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.

Log in to Formfacade > click Forms > click on the form you want to edit > Edit page will be displayed > In the Edit page, scroll down to the submit section > select "Redirect to webpage" > Enter the URL you want users to be redirected to after submission > You can then preview the form and submit a response to test the redirect.

The free trial automatically ends after 7 days. We don’t request card details when you install the addon or create your account, so there’s no way for you to be charged automatically or receive payment reminders. If you have installed the addon and would like to uninstall/remove the app from your Google Forms, here's the instructions: Open your Google Forms > click on the three dots icon next to the SEND button in the top right corner > click Addons > search for Formesign > select Formesign > click on Uninstall. If you would like to delete your account, please confirm.

Hi Wes, when you subscribe to the paid plan, you can choose the monthly or annual option. If you need it only for short term, you can choose the monthly subscription, use it for one month and then cancel the subscription before it is renewed for the second month.

Submit to google forms Login to Formesign > click on the form to open it > Edit page will be displayed > In the Edit page, click on the form title to select it > click on the settings gear icon > Form settings page will be displayed > click Advanced > enable the Submit to google forms option and click Save. Once enabled, new responses will be recorded in Google Forms. If you have linked your google forms with google sheets, the responses will be synced to google sheets. Track submit status We have implemented a feature to show a warning message along with the resubmit option for failed submissions. Login to Formesign > click on the form to open it > Edit page will be displayed > click Responses > In the Responses page, click on a response to view the details > scroll down and check the Additional details section > The status for "Google Forms" should be displayed as "Submitted". Otherwise, it will display the error message along with the option to resubmit. Reports: Sync to sheets You can also sync the responses from the reports page to google sheets. Please note that this is not a real time sync; the responses will be synced only when you click on the sync option in the Reports page.

Subscription Yes, in addition to the monthly subscription fee, there may be transaction fees depending on the type of payment you accept. For manual payments (such as QR code or instruction-based payments), there are no transaction fees. For automated payments processed through Stripe, PayPal, or Yoco, transaction fees are charged directly by the payment service providers, and the rates vary by country. Automated payments The email address used to receive payments does not have to match your Google account email. You can set up a different payment email address when you configure your payment processor.

Hi Carla, If you have set up automatic syncing to Google Drive, you can find the signed forms in the designated folder there. Otherwise, you can manually download the signed waiver forms in Formesign. Login to Formesign > click Forms > click on the form to open it > Edit page will be displayed > click Responses > In the Responses page, click on a response to view the details > scroll down to the Additional details section > click on the signed form to access the pdf and download it. Please note that you can download the files one at a time only.

Enable payments Login to Neartail > click Forms > click on the form to open it > Edit page will be displayed > In the Neartail Edit page, scroll down to the payment section > click Enable > Payment settings page will be displayed > click Enable payments The payment options supported in your country will be displayed > configure the preferred payment options and click Save.

Hi Nick, you can use the POINTS() function to calculate the total score. If you would like to record the total score in the form, please follow the instructions below. Login to Formfacade > click Forms > click on the form to open it > Edit page will be displayed > In the Edit page, click on the last question "Innovation Competency Assessment" to select it > click on the + Add new field icon > enter the title "Total score", select Short answer question type, click on the settings gear icon > Question settings page will be displayed > click Answer > enter POINTS() in the Calculate option, select Hidden for the Appearance option and click Save. Once you make this update, you can submit a response to test the form and check the total score in the Responses and Reports page.

Hi Simon, By default, system fields are displayed first, followed by form fields in the same order as they appear in the form. You can use the Freeze column option to rearrange them as needed. Rearrange columns In the Reports page, click on the preferred report. Click on the filter icon for the Order ID column, select Freeze column and click Ok. The Order ID column will be fixed as the first column. You can then click on the filter icon for the Name column, select Freeze column and click Ok to move the Name column after Order ID. Similarly, you can freeze other columns as needed to arrange them in the preferred order one at a time. Please note that there are two options: "Freeze column" and "Free upto this column".

Formesign addon You can use the Sync to drive addon menu option in Formesign to automatically generate the signed form in pdf format and sync it your google drive folder. For detailed instructions, refer to the help article below. Sync to drive https://formesign.com/esign/how-to-sync-signature-and-signed-document-to-google-drive.html Formesign - Demo video https://youtu.be/GPaSEioRKJ8 Missing menu options If you open your form in Google Forms, click on the addon icon and select Formesign (or any addon) immediately, sometimes only the Help option will be displayed in the addon menu. This is a Google Workspace issue. Please click on the addon icon a few mins after opening your Google Form (once the form is loaded); the addon menu options will be displayed.

Hi Chelsea, You don't need to turn off payments in your form. Instead, you can simply close the form to stop accepting responses. When you close your form in Neartail, users will not be able to view the form or submit their response, but you can edit the form and manage responses. Login to Neartail > click Forms > click on the form to open it > Edit page will be displayed > In the Neartail Edit page, click on the form title to select it > click on the settings gear icon next to the form title > Form settings page will be displayed > click Advanced > check Close this form option, add a custom message and click Save.

Hi Namie, You can directly update the subject and message of the confirmation email in Neartail. Login to Neartail using the registered email > click Forms > click on the form to open it > Edit page will be displayed > click Orders > In the Orders page, click on the three dots more icon next to the Submitted status > click Notify respondent > follow the prompts to update the email set up. You can then submit a response to test the confirmation email. Forms dashboard When you customize a google form using the Neartail addon, it will be added to the Forms dashboard in Neartail. You can login directly to Neartail to access your customized forms, make edits, and manage responses. If you delete a form from Neartail, it will no longer be displayed in the Forms dashboard.

Neartail supports only public forms. When publishing the form, you must select 'Anyone with the link' in the Responders settings. Currently, you have selected 'Restricted', which limits access to specific people. Please update the settings, sync it with Neartail, and then try again.