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.

You can sync the orders to google sheets. Login to Neartail > click Forms > click on the form to open it > Edit page will be displayed > click Reports > In the Reports page, click on the ⚙️ settings gear icon (see screenshot below) > click Sync all orders to google sheets.

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.

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.

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.

Hi Michelle, We have integrated with Stripe (Card, Apple Pay, 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. How to enable payments? Login to Neartail > click on the form to open it > Edit page will be displayed > In the Neartail Edit page, scroll down to the bottom of the page > click on the Enable link in the Payments section (see screenshot below) > Payments settings will be displayed > click Enable > The payment options supported in your country will be displayed > configure the preferred payment options and click Save.

Summary settings 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. 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. This mapping is also used to show the order summary in the cart page. Update settings Login to Neartail > click on the to open it > Edit page will be displayed > In the Neartail Edit page, click on the configure key fields icon in the bottom right corner at the end of a page (see screenshot below) > Summary settings page will be displayed > select the correct fields for the Amount, Discount, Tax, Delivery Fee, Tip, Donation, Net amount option and click Save. If you are not charging a delivery fee, offering discounts etc, you can select None from the dropdown list for the respective options in the Summary settings page.

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.

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.

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

You will need to use the near.tl share link to collect responses for your form. Please note that customizations and calculations won’t work with the standard Google Forms link, as these features are not supported by Google Forms.

Hi Mave, You have enabled automated as well as manual payment options in your form. By default, there will be five order status: Abandoned, Submitted, Paid, Completed, Trash. 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. You can setup automated email notifications for Submitted and Paid status. Since you have enabled automated as well as manual payment options, I'd recommend the following set up. Setup Notify respondent option for Paid status 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 Paid status > click Notify respondent > setup wizard will be displayed > follow the prompts to complete the setup. This will be the automated order confirmation email sent to the customers confirming receipt of payment.

Sound alerts are automatically enabled when you open the Neartail Orders page. Currently, it cannot be disabled. I'll share your feedback with our team. In the meantime, you can mute the browser tab where you’ve opened the Neartail Orders page to disable sound notifications.

Currently, Neartail does not have the option to set a transaction fee for each payment method separately. This feature is part of the roadmap.

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.

You have added a file upload question in your google form. This feature requires sign-in, so you will not be able to use the "Import using URL" option to create your form. Instead, you can install the Formesign - eSignature add-on and use it to customize the existing google form. Formesign - Esignature addon https://workspace.google.com/marketplace/app/formesign_esignature/210002188569 Formesign demo video https://youtu.be/GPaSEioRKJ8

Yes, you can sync the orders with line items details to google sheets. Login to Neartail > click Forms > click on the form to open it > Edit page will be displayed > click Reports > In the Reports page, click on the ⚙️ settings gear icon (see screenshot below) > click Sync all orders to google sheets.

You have added a checkboxes question "Workshop date" with the two dates as answer choices and a product sold by quantity for "Registration fee". If you would like to limit for each workshop date, then you must set it up as a product and enable the inventory option. Login to Neartail > click Forms > click on the form to open it > Edit page will be displayed > click on the Add product icon > enter the product title "Workshop registration", select "Sold by variant", enter the price, set the max quantity as 2, enter the two workshop dates as variants > click on the settings gear icon > Product settings page will be displayed > enable the "Allow users to select multiple variants" > click Advanced > enable the inventory option, enter the available stock (see screenshot below) and click Save.

You can customize your existing google form using the Formesign addon to add signatures. Please note that you must use the Formesign link to collect signatures. Otherwise, customization and signatures will not work. Formesign - Demo video https://youtu.be/GPaSEioRKJ8 Formesign - Esignature addon https://workspace.google.com/marketplace/app/formesign_esignature/210002188569

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.

Hi Olivia, You can use the POINTS() formula to calculate the total score. 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 in the form to select it > click on the + Add new field icon > A new question will be added below the selected question > enter the title "Total score", select the Short answer question type > click on the ⚙️ settings gear icon > Question settings page will be displayed > click Answer > enter POINTS() formula in the Calculate option and click Save. You can also choose to hide this field in the form by selecting "Hidden" for the Appearance option.

Hi Ansley, You must set up your form to record the total score. Otherwise, you will not be able to show a conditional message based on score. Calculate total score 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 in the form to select it > click on the + Add new field icon > A new question will be added below the selected question > enter the title "Total score", select the Short answer question type > click on the ⚙️ settings gear icon > Question settings page will be displayed > click Answer > enter TOTAL() formula in the Calculate option and click Save. You can also choose to hide this field in the form by selecting "Hidden" for the Appearance option. Show conditional message In the Formfacade Edit page, scroll down to the submit section > select Message based on score > On submit settings page will be displayed > select Total score field for the "Conditional message based on" option, click Create > you can then configure the messages for different conditions as required.

Formfacade - File upload is a paid product. You will need to subscribe to the paid plan to use your form to collect responses. We responded to your posts last year (refer to the links below). https://near.tl/support/forum/formfacade/hi-on-your-website-it-is-mentioned-that-you-offer-.-Nqfm2jaA3HZVmL3jf8p.html https://near.tl/support/forum/formfacade/im-reposting-this-because-my-previous-post-was-del.-NxQAWRZO1-yY_r8nLHC.html

Currently, Neartail does not support adding a surcharge specifically for credit card payments directly on the form. This feature is part of the roadmap.

Hi - Formfacade has incorrectly flagged this as an unsafe form. We have reviewed and corrected the false positive so that warning message is removed from this form. Please check now.

Hi Tina, You can set up bulk discounts for products sold by quantity or weight. Login to Neartail > click Forms > list of your forms will be displayed > click on the form to open it > Edit page will be displayed > In the Neartail Edit page, click on the Add product icon > enter the product name, select the product type “Sold by quantity” > click on the settings gear icon > Product settings page will be displayed > click on the Bulk discount option > enter the actual amount for the different quantity options. Please note that you must enter the amount and not price per unit quantity. For example, if the standard price per unit is $3 and you would like to offer 6 for $15 and 12 for 30$, then you can have the set up as shown in the screenshot below.

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 the help article. https://formfacade.com/collaboration/check-email-status-error-codes-description.html

Delete redundant orders You can move orders to Trash status and enable Strict privacy to delete these orders permanently. Please note that deleting orders will not reset the order number. 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 the submitted orders to Trash status. These orders will not be included in the Reports. Enable Strict Privacy You can enable the Privacy option to delete the orders 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 orders 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. Delete Abandoned orders manually 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 more icon next to the Abandoned status > click Delete all > click Confirm. Please note that the draft orders created in the last 48 hrs will not be deleted; only the older orders will be deleted from the Abandoned status.