Save respondent info (including their responses!) to your CRMĪdd respondents to your email marketing list, tagged a certain way depending on their answers Save form entries in a database or spreadsheet other than Google Sheets Get a notification wherever you want when your form is filled out (or even when your form is filled out in a specific way) Build add-ons with Google Apps Scriptīy connecting Google Forms to Zapier, you can automatically do things like: Or, if you're storing your form data in a Google Sheets spreadsheet, there's a wealth of Sheets add-ons to do more with your data. Each response can be added to unique documents based on form questions, or they each can be added to the same document.įorm Notifications sends custom email notifications to you and optionally to form respondents with details about the form results and a thank you message.įorm Publisher makes template Google Docs documents, PDF files, or unique spreadsheets for each entry, and then shares them via email.įormRecycler imports questions from other forms to quickly reuse them without copying the entire form. You could use it to sort all similar entries into different sheets automatically.ĭocAppender adds your form results to the end of a Google Docs document instead of a spreadsheet. It's a great way to, say, make a signup form where respondents can each select one day or an order form for limited-quantity items.ĭata Director adds form responses to alternate sheets and sends email notifications based on conditions. It's a great tool for managing inventory or shared items, or it could be used creatively to, say, approve tasks or do other jobs where you need to move items between two categories.Ĭhoice Eliminator Lite eliminates options from multiple-choice, list, or checkbox questions if they've already been selected. Here are some of the best Forms add-ons to get started:ĬheckItOut lets you check in or out items with a form, essentially by rearranging data from one category to another in a spreadsheet. There's no menu option to manage or remove add-ons instead, just open the add-ons pane again, find the add-on you want to remove, click Manage, and then select Remove in its menu. To open an add-on, just select it in the add-ons menu, manage its settings from its add-on pop-up, and it'll then run in the background automatically. Most add-ons run in a pop-up square on the lower right side of your forms editor, and they may also include an options pane for options that opens in the center of your editor. It can ask for a date and month and, optionally, the year and time as well. This form field works great for ranking grid questions, voting/poll questions, and comparison questions.ĭate: Want to ask for a specific date or time, perhaps to schedule an event or log an activity? The date field is the one you want to select. You can limit users to choose just one answer per row, and you can also shuffle the row order to eliminate bias. It lets survey respondents make comparisons or select, say, their levels of satisfaction with a product. In addition to the standard option to require responses, the grid lets you require a response per row and can also limit users to only one response per column.Ĭheckbox grid: The Checkbox grid allows respondents to select multiple answer options (columns) for each row in a table. You might want to keep the form preview open while setting up grid questions-just tap the eye icon on the top right, and refresh that page to see your changes. I've raised this as a feature issue and we'll see whether that generates any clarification and/or change.You can include as many rows and columns as you want, though do note that readers will have to scroll right to see more than six columns on desktop browsers or just three columns on mobile. These are relatively new commands (at the time of writing) and there are very few examples to be found online. The auto-fit outcome appears deliberate on Google's part - even though the effect is very different to the effect of the manual "Wrap" adjustment. I've re-run my initial tests and I believe that I may misinterpreted your auto-fit comments when comparing my results. In the later case, the amount of text displayed otherwise depends on the width of the column.īy comparison, when the settings are adjusted manually (the row height set to 50 pixels and text wrapping set to wrap), the row does not revert to auto-fit. "Cells with wrap disabled display as much as possible in the cell without resizing or running to multiple lines". That is, the cell width remains unchanged, and the row height changes to enable display of the entire content. The documentation for setWrap and setWraps says " Cells with wrap enabled (the default) resize to display their full content" ( emphasis is mine). Programmed ( setRowHeight/ setRowHeights) row height adjustment. It appears that setWrap and setWraps override any manual or
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |