Ask questions about our products
I want to round a field answer to two decimal places, reducing the accuracy of the number, how would I do that? I have a special entry that will calculate depending on a couple criteria that the user provides, but the number always goes past two decimal places, can someone help me?
You can use the ROUND function to round the answer to the nearest integer or decimals. Use ROUND( existing formula ) to round to 2 decimal places. Use ROUND( existing formula, 0 ) to round to the nearest integer.
I close my google form and simultaneously update Formfacade to sync my action. However, every time I do this, the underlying google form is set back to accepting responses. Please help fix it.
You can close the form to stop accepting responses. When you close your form in Formfacade, users will not be able to view the form or submit their response, but you can edit the form and manage responses. Login to Formfacade. 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 will be displayed. Click Advanced. Check Close this form option, add a custom message and click Save. Note: If you close your form in google forms, you will not be able to edit the form or view the submitted responses in Formfacade.
How can you delete entries. I would like to go to 0 I am starting a new year-New Groups.
Hi Mike, The response id cannot be reset. The workaround is to make a copy of the existing form and use it collect responses. The response id will start from 1 and it will be incremented by 1 for each new response.
Hello, I have added formfacade add-ons to my google form and from icon add on I have configured the score points for multiple choice options. I can see the total score from formfacade however when I am testing google form URL the total score is now showing at the end of questions or in the cutom Confirmation message (that I have added in the formfacade and removed from Google form settings. Why the this ${POINTS()} is not working in google form? How I can get the google form working to be able to share the google form assessment with the total score?
Hi Mara, you will have to use the Formfacade share link to collect responses. Otherwise, customization and score calculations will not work as these features are not supported by Google Forms. When you use the Formfacade Share link, the responses will be recorded in Formfacade and Google Forms. You can also sync the google forms responses to google sheets.
I have the results of my survey, but I am not able to produce a report of the abandoned questionnaires. How do I fix this, please?
Hi Michael, login to Formfacade > click Forms > click on the form to open it > Edit page will be displayed > click Reports > In the Reports page, click on the report to select it > click on the Edit report icon (see screenshot below) > Report setup page will be displayed > click More options, enable the "Include abandoned responses" option, click Next > customize the report columns as needed, click Next > choose the report option -- table, nested table, matrix, click Finish.
We are experiencing issues with our form where the taxes and delivery charges are not translating to our payment methods (with Stripe). I have communicated with Stripe directly and they told me that the issue is with Formacade and not with Stripe. I can provide the message thread by e-mail once you contact me. Thanks, Derick Bryan
Hi Derick, The Summary settings page allows you to select the relevant fields from the form for options such as Amount, Discount, Tax, Delivery Fee, Tip, Donation, 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. This mapping is also used to 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 option. Otherwise, the answer for the field mapped for the Amount option will be passed. Update 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 correct fields (see below) for the Amount, Tax, Delivery Fee, Net amount option and click Save. Amount - Select the Order Subtotal field Tax - Select the Sales Tax (15%) field Delivery Fee - Select the Delivery Charge field Net Amount - Select the Total amount to be paid field Please try this and let me know if you have any questions.
I can not find out from your FAQ or UI how to output which categories received the most points. I assigned points with category names to each question, but I can not see which formula I should use to determine which category is the winner.
You can use the TITLE function with the MAX function to display the name of the question with the max score. MAX function You can use the MAX function to find the highest value in a set of give data. MAX(category_score_field_1, category_score_field_2, category_score_field_3) The above formula will return the highest score of the 3 fields. For example, if the value for the category_score_field_1, category_score_field_2, category_score_field_3 fields are 2, 10, 8 respectively, then the above formula will return 10. TITLE function If you would like to find the field with the highest score, then you can use the TITLE and MAX function. TITLE(MAX(category_score_field_1, category_score_field_2, category_score_field_3) The above formula will return the name of the field with the highest score. For example, if the value for the category_score_field_1, category_score_field_2, category_score_field_3 fields are 2, 10, 8 respectively, then the above formula will return the name of category_score_field_2. Note: You must type @ and select the fields from the list when adding the formula in the Calculate option.
link formfacade form to google sheet
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.
We’re currently using Google Forms integrated with Formfacade. While responses are now visible within Formfacade, they’re not appearing in the Google Form’s connected response sheet. How can we resolve this so that responses are also reflected in the Google Sheet?
By default, forms created using Formfacade templates do not submit responses to Google Forms. If needed, you can enable the "Submit to Google Forms" option 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.
NO PUEDO CERRAR EL FORMULARIO
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 will be displayed > Click Advanced > Check Close this form option, add a custom message and click Save. When you close your form in Formfacade, users will not be able to view the form or submit their response, but you can edit the form and manage responses.
Please contact me for support. (2nd Request)
Hi Julie, we removed your last post from the community forum and sent an email as requested on 11-March. If you need further help with your form, please post your question here in the community forum, reply to my email or send an email to support@formfacade.com with the relevant details.
The form we have created is like a self-guided assessment. We have assigned points for each question and a response outcome based on the total points tallied at the end of the assessment. The assessment gives the user key details/suggestions based on how they scored during the assessment. The problem I am having is 1. I am not receiving notifications of completed forms 2. I would like to give a copy of the recommended options steps to the user as a PDF copy (not just an outline of the questions they have answered) 3. I also want a copy of their recommended options 4. Are you connected with Zapier for more advanced automations How can I add/update these options?
Track email status 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 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. For more details, please refer to this help article. https://formfacade.com/collaboration/check-email-status-error-codes-description.html Customize PDF You have subscribed to the Formfacade Assign points Basic plan. If you would like to customize the PDF attachment in the email, you should upgrade to the Formfacade Assign points Business or Formfacade Enhance plans. Zapier You can enable the "Submit to google forms" option in your form so that the responses are recorded in google forms. You can link the google forms to google sheets so that the responses are automatically synced to Sheets. You can then use the Google Sheets Zapier integration.
How can I access copies of my signed forms. When I view the form response, the signature field has a bunch of numbers and letters.
Hi Sharon, you can view the signed forms in the Formesign Responses or the Reports page. 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 > click on the signed document to access it. You can also set up your form to sync the signed forms to your Google Drive folder. For detailed instructions, please refer to the link below. https://formesign.com/esign/how-to-sync-signature-and-signed-document-to-google-drive.html
On my form my profile picture is at the bottom, I wish to remove that photo from the form please.
Login to Formfacade. Click on the form to open it. Edit page will be displayed. Click Preview. In the Preview page, theme settings will be displayed. 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. Note: [1] The theme settings are for your account and it will be applied to all the forms you create using your account. [2] Footer logo can be customised only by paid users. When you subscribe to the paid plan, the profile picture will be automatically replaced by the logo you have uploaded.
Hi, We're seeing fon't issues on our embedded form. Specific parts of text are smaller than the rest despite not being able to set size, and is making the forms look messy. See here: https://www.dropbox.com/scl/fi/epv8lrmoyo3hnt3j0wld0/Screenshot-2025-03-31-at-6.06.15-pm.png?rlkey=i21bjuymwlc62r53973qnpuu4&dl=0 Form embedded here: https://microstartfarming.com.au/pages/liquid-microbes-order-form
Hi Ryan, You have added content in the description option for the multiple-choice question highlighted in your screenshot. That's why the formatting is different. Note: You cannot set the font size or styles for different form elements. Formfacade will automatically apply the necessary styles based on the font selected in your theme settings.
Frequently Asked Questions
Hello! Why do some say completed and others read PAID, I am not understanding the difference. Is there something I need to do?
Hi Katrina By default, there are four order status: Abandoned, Submitted, Completed, Trash. You cannot rename the default status, but you can choose to hide a default status. When you enable automated as well as manual payments in your form, the default order status will include Abandoned, Submitted, Paid, Completed, Trash. Abandoned orders If a user starts filling the form, but does not submit it, it will be displayed in the Abandoned status. These orders will be displayed only in the Neartail Orders page and it will not be included in Reports. Abandoned orders will have * prefixed to the order number in the Neartail Orders page. Submitted orders When the user chooses the automated payment option and submits the form, the order will be displayed under the Paid status. When the user chooses the manual payment option and submits the form, the order will be displayed under the submitted status. Once you verify the payment and update the payment status, it will be moved to the Paid status. These submitted orders will be recorded in Neartail and Google Forms. You can sync Google Forms responses to Google Sheets. Submitted orders will have # prefixed to the order number in the Neartail Orders page. The order numbers should be in sequential order. Trash orders You can move redundant orders to Trash. 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 order to view the details, select the Trash status from the dropdown list for the Move to option and click Submit. Delete orders The orders in Abandoned and Trash status will not be included in the Neartail Reports. You can enable the Privacy option to delete the orders in 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 orders in Abandoned and Trash status will be automatically deleted after 7 days. Please note that the Abandoned status will be hidden when the Privacy option is enabled.
Can I remove or edit my name at the bottom of my form? "Created by_______"
Hi James, You can customize the footer, header, theme, logo, but please note that this is common for all the forms you create using your account. Customize header, footer, theme Login to Formfacade. Click on the form to open it. Edit page will be displayed. Click Preview. In the Preview page, 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...") and click Save. You can upload your logo (square image 1:1 aspect ratio) to replace the default profile picture in the footer.
Hello, I am getting two errors on my form, when fully submitted, here are two screenshots: 1. Right at submit: https://prnt.sc/C9idKb4uTbtI 2. Another error note, which also happens on submit: https://prnt.sc/d2hkzBekDrAv Thank you!
Submit failed: Not able to update in google forms https://prnt.sc/C9idKb4uTbtI When the user submits the form, the response is recorded in Formfacade and Google Forms. If there are any issues with submitting the form or recording the responses in Google Forms, we show an error message to the user and also send a notification email to the form creator. The submit can fail because there is an issue with the form, internet connectivity issue etc. The notification email will include the error message, draft id, link to the response (abandoned or submitted). If the draft id is prefixed with the *, it indicates that the response has not been submitted. If it is prefixed with a #, it indicates that the response has been submitted. If the error for response shows "Not able to update this response in Google Forms", then this indicates that the submit was successful and the response was recorded in Formfacade, but it was not updated in Google Forms. Google Forms might reject the responses if it fails any response validations (incorrect answers, missing answers for required questions) or if you have enabled any of the features that require signin such as limit to 1 response, collect email address - verified input, send response receipts, response too large etc. You might have also noticed that sometimes Google Forms throws a "Something went wrong" error without giving any additional details. Request entity too large error https://prnt.sc/d2hkzBekDrAv You have added 28 paragraph questions in your form. When the user fills the answer for these paragraph questions along with other required questions in the form, the resulting response exceeds the size limit supported by google forms. That's why you are getting the entity too large error. To fix this, you can add a response validation for these paragraph questions to restrict the max characters or you can enable the option to not record the responses in google forms. Login to Formfacade > click on the form to open it > Edit page will be displayed > 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 > enable the toggle button for "Don't submit to google forms" and click Save. When this option is enabled, the responses will be recorded only in Formfacade.