Copy Down vs FORM PAL

copyDown adds a simple but revolutionary functionality to Google Form™-fed Google Sheets™ -- the ability to have formulas and cell formats carry into new form submission rows. With this ability, any Google Form™ submission can auto-calculate subtotals, perform a vertical lookup against another sheet, include conditional formats or data-validation lists in new form rows, or calculate a count or countif tied to a cutoff threshold -- and these are just a few examples -- don't get us started! Use in combination with the autoCrat or formMule Add-ons to bring calculated values and formatted numbers and dates into your form-triggered document and email merges. IMPORTANT: Due to limitations of Apps Script, copyDown is NOT COMPATIBLE WITH SPREADSHEET FILTERS on the form response sheet.

➤ ➤ ➤ FEATURES ➤ ➤ ➤ 1) Countdown timer Set a countdown timer for your Google Forms™ online tests or quizzes 2) Start and end date Activate and/or deactivate your form based on a date and time, ideally for your quiz or exam 3) Email notifications Receive email notifications for each form submission 4) Everything within the Google™ environment No external platform and no external account is required 5) Basic proctor functionality The user plus timestamp will be tracked for each attempt This addon is the perfect companion for: - Quizzes with time limits - Organising appointments - Planning events - …so all situations which require a form start/stop functionality Don’t be afraid of overbooked events, this addon will open and close your form at the exact time and date. 6) NEW: Limit choices Set different limits for your questions. As soon as all limits are reached, the question will display a final message e.g. “This question is no longer available”. In addition, already limited questions can be restored and email notifications are available to inform users as soon as a question has been completely limited. 7) NEW: Limit responses Set a response limit for your form. As soon as all limits are reached, the form will be closed and no more responses will be possible. ➤ ➤ ➤ ISSUES ➤ ➤ ➤ 1) Only the "Help" menu item does show up This issue can not be fixed by us. Just reload the page, then all menu items will show up. 2) The error message "drive.google.com refuses to connect" shows up within the sidebar This issue can also not be fixed by us. The cause for this error message is that multiple users are logged in within the browser. Solution 1: Just log out with all users, except the one which should be used to work with the addon. Solution 2: Use a different browser or the incognito mode. 2) The sidebar is completely blank Again, the cause for this error is outside the timer addon. The cause for this error message is that multiple users are logged in within the browser. Solution 1: Just log out with all users, except the one which should be used to work with the addon. Solution 2: Use a different browser or the incognito mode. ➤ ➤ ➤ SUPPORT ➤ ➤ ➤ Our website offers a FAQ section, with answered questions from other users. In addition you will find a contact form, to get in touch with us. We are grateful for any feedback and feature requests :) ➤ ➤ ➤ IN A NUTSHELL ➤ ➤ ➤ - This Google Form™ limiter addon lets you limit the number of answers your form can get - Let the addon turn on your form at a set start date and time - Based on a stop (end) date and time, let the addon close the form so it isn’t available after a certain moment - You can set a specific start date and time, defining when your form becomes active - Designate a disable (end) date and time, so your form becomes unavailable after a certain point in time - Limit the number of form responses your form can accept - Show countdown timer on the form during active form limit and close form limit phase - Choose custom open form limit message - Start and stop form by date and time schedule via our formlimiter Google Form™ addon - NEW: Limit responses based on predefined limiting rules ➤ ➤ ➤ CHANGELOG ➤ ➤ ➤ V6: Add response limiting functionality and rename to “FORM PAL” V5: Add user management, starts and closes form only for added email addresses V4: Fixed CSS bug for active form when time for it to close was set V3: Fixed timezone bug when form was open for answers V2: Added controls for start/end times to cap responses V1: Basic formlimiter functionality ➤ ➤ ➤ WHO IS BEHIND ADDONFORGE? ➤ ➤ ➤ We met while working together at a top-tier online marketing agency in Vienna, the first full-stack Google partner in the DACH region: Google Marketing Platform Certified, Google Marketing Platform Sales Partner and Google Cloud Partner. We gained experience in various areas like campaign management, digital analytics, Google SEO, and cloud & data science. We've worked with tools like Campaign Manager 360™, Display & Video 360™, Google Analytics™, Google Tag Manager™, Google Search Console™, Google Cloud Platform™, and more. Since we're so familiar with the Google ecosystem, developing Google Workspace Marketplace™ add-ons seemed like a natural next step 😊 - - - - - - - - - - - - - - - - - - - - - - Information for users landing on this page from Google Search: What does this add-on do? meta-description: A Timer Limit & Response Choice Eliminator add-on for Google Forms™. This is a Google Workspace Marketplace add-on, meaning that you need to be logged in to Google in order to install and use it. More information can be found here: https://support.google.com/marketplace/answer/172391?hl=en We are mentioning this because we regularly receive support requests for this matter. If you still have questions, please contact us.