With the new year comes a reflection of the past year, and resolutions for the coming year. Let’s have a look back at what our 2019 was like, and what we’re looking forward to in 2020.
Google started verifying third-party apps in the G Suite Marketplace as part of their Project Strobe which involves updates to Google’s user data policy as of October 15, 2019, with the aim for greater security for users of Google Add-ons, especially when it comes to restricted permissions.
To address the above restrictions, Google Sheets add-ons powered by wizy.io are now completely verified and compliant, and we are confident that they handle our customers’ work/school data more securely:
We are committed to making G Merge Plus the best application it can be, and we will develop our own solutions to the restricted permissions of Google Drive API (to overcome restrictions in selecting a drive or converting to PDF) in the first semester of 2020.
We will continue to build our Help Centers for Form Workflow Plus and G Merge Plus to add answers to frequently asked questions and offer solutions and workarounds when available.
We will continue to provide support, and would be happy to provide demos and offer video calls to walk through users of G Merge Plus and Form Workflow Plus.
Please let us know if you have any questions or feedback about our add-ons. You can submit requests via the Help Centers above or by emailing email@example.com.
Leica PalileoNew Year, New Commitments to Form Workflow Plus and G Merge Plus
Compliance with Google’s User Data Policy: We refined the auth scopes we use and removed minor functions that required restricted scopes.
Google Drive API – We no longer ask permission to write to your Google Drive and sharing is restricted. As a result, you can no longer choose destination folder other than the default so we will be saving your document merges centrally to “My Drive”. This also affects the “convert to PDF” function. (We have a workaround for this where you can use the mail merge function to send the document you created from document merge as PDF via email.)
Gmail API for Aliases – We no longer ask permission to access your Gmail account for the purpose of sending as a different email address that you own. As a result the Alias function is disabled and you can only send as the user that is authenticated (signed-in).
Reports Page: This contains a list of all spreadsheets where you’ve used G Merge Plus and reports of how many emails have been sent and their click rates.
Enhanced Email Templates: While we still have the same easy template editor on the G Merge Plus add-on, we added a drag-and-drop editor, a template library for common ways people use mail merges, and a way for you to see all your templates laid out.
Subscription Management: You can now manage your account settings, view your usage, purchase additional licenses, upgrade your account, and add members to your team easily.
As a result, you can centrally manage your spreadsheets, templates, users, and subscription in a better way though app.gmergeplus.com (this replaces the old portal).
NOTE: If you have a Team or Enterprise Subscription, please inform all of your users or team members about the changes and to install G Merge Plus.
Why did Wizy create a new add-on/application instead of updating G Merge?
Creating G Merge Plus allows us to work on modifying features that Google has changed to restricted without disrupting how the current users of G Merge are using the add-on.
It also gives us confidence that all users opt-in to the changes and understand exactly how we use user data and the permissions granted.
With the current G Merge software, we understand that permissions have already been granted by current users, but due to the changes in Google’s User Data Policy, some API scopes for Google Drive and Gmail that we use to perform certain operations have been changed to restricted or sensitive scopes. Rather than risk that G Merge will no longer function as intended when Google disables or deprecates these, we created G Merge Plus which was designed not to use any of the aforementioned sensitive or restricted scopes, and encourage our users to install the new G Merge Plus instead.
We advise that you install G Merge Plus before January 1, 2020, as Google may suspend the existing G Merge add-on in January in application of its new User Data Policy.
Please refer to our Help Center for articles that will help you navigate the new G Merge Plus.
Many of our customers in Form Workflow Plus are admins or coordinators in schools or universities, and the most common approval workflows have to do with organizing students and teachers. Some literal “old schools” still use paper forms, but the modern school has gone paperless, using online tools and applications to manage the most basic processes.
In this blog post, we demonstrate how to use Google Forms, Google Sheets, and Form Workflow Plus for organizing a field trip to help you get started with your own process planning.
Organizing the student body
No matter what level, whether it’s kindergarten or school or college, the ratio of students to teachers is usually many dozens to one.
Organizing students can be challenging when there are between tens to hundreds of students per class, and even more so when taking them outside of school grounds, where you not only need to figure out who’s going or not to figure out the headcount and resources you need to book such as admission tickets and buses, but also secure waivers from parents if they are underaged, and collect any payments for additional fees required for expenses not shouldered by the school.
At the end of the day, it ends up that there is one person in charge of overseeing and coordinating everything. This is not only a humongous responsibility, but also one where you cannot afford to make mistakes.
How to begin organizing the trip
First, decide what information you need in order to organize the trip and get things done. As a coordinator, you may need to find out at a high level:
How many people want to go to the field trip so that you can book the right number of admission tickets you need to book (if any) or how many buses you need to take the students to the field trip destination.
The ages of the students going on the field trip to secure liability waivers from parents and guardians, and/or add parents who will accompany students so that you can add them to the resources you need. (This is easier with elementary students and more complex at the high school level where you get a mix of minor and adult ages per class.)
How many attendees have actually paid the appropriate fees for the field trip so that you can follow up on anyone who hasn’t paid yet or exclude them from the final headcount after the deadline has passed.
Miscellaneous information that is important to key stakeholders like the principal, the PTA, concerned parents, bus operators, the management at the venue of the field trip, etc. If your school doesn’t yet have a procedure for field trips, it’s important to keep in touch with and be able to assure transparency with all parties involved.
Second, break down what you need in steps to make it easier for everyone to coordinate with each other:
Teachers can coordinate per classroom or section the number of students attending, their ages, waivers required, and any accompanying parents
OIC for payments (this can be another representative per class, a department head, or a faculty leader per year level, depending on what the school’s organizational structure is like) can approve final headcount after confirming payment for field trip fees
Coordinator can base the booking of resources and finalize the itinerary based on the final headcount, which will then be shared back with the school heads and teachers
How to set up the field trip with Form Workflow Plus
The best way to accomplish this in Form Workflow Plus is to create a Google Form form to collect responses, and then set up a workflow with at least two steps of approvals.
REQUEST FORM: The Google Form must request information such as Name, Grade/Year Level, Class Name, Homeroom Teacher, etc. For fields that will require filtering later on (such as by class), we recommend setting up the answers as a drop-down menu or multiple choice rather than free text forms to avoid typos and mistakes.
(On Form Workflow Plus, click Add-Ons > Form Workflow Plus > Start > Create and then Edit Form. You can then edit the default form with the questions you want, such as below.)
STEP 1: The workflow creator would ideally set up multiple conditions, one for each class, so that the approver for each class would go to the specific homeroom teacher assigned to it.
Teachers are the first line of approval and they can cross-reference their class lists and note the information and consents prior to sending the approval to the next level.
STEP 2: The workflow creator can set this up in two ways: either set up specific approvers per class again, or the same approvers for all second level approvals (this can be the principal or an accountant/finance manager or an administrator). They would then look after whether the field trip attendees have paid up prior to approving.
In this example, we’ll set up the approvers per Year Level Head, who will check if everyone attending has paid up or not.
The workflow creator can then set up the coordinator/administrator to be CC’ed upon final approval, OR set up an optional third approval step for the coordinator to approve once actions have been taken.
OPTIONAL: STEP 3 and Onwards. You can set up as many conditions and filters and approval steps as you like, based on the question fields and conditions you set.
Form Workflow Plus allows different user roles to make workflow management easy. If the coordinator/administrator is also the workflow creator or has been set up as an admin or owner, they can also oversee the requests at every step of the way without needing to set up a third step with the admin/coordinator as an approver, unless it is required as a formality. You can do this via the web app by clicking on “Manage Workflows” at the bottom of the add-on or logging in directly from your browser at //app.formworkflowplus.com.
More power to the people
Fortunately, now that everything can be done online, virtually anyone can create an approval workflow. Form Workflow Plus makes it easier for those who work for schools by empowering anyone at any level to set up an approval process for their needs, with multiple steps and multiple conditions for each step, and be fully transparent to all users.
Try Form Workflow Plus now, or schedule a demo with us.
Google add-ons G Merge Plus and Form Workflow Plus are powered by Wizy.
Wizy is a Startup Studio for B2B SaaS built on Google technologies. We work with innovative customers to develop disruptive Cloud SaaS solutions. We leverage the power of the Cloud, AI and Mobile adoption to disrupt and innovate.
Wizy was launched in January 2015 simultaneously in San Francisco, Manila and Paris by co-founders Laurent Gasser, Gino Tria and Louis Naugès. We are bootstrapped, financed by our founders and our business. We are free of VC’s and external investors agenda, able to focus exclusively on the value delivered to our customers.
Wizy is “global by design” with founders and teams on 4 continents, as well as customers in 30 countries.