December 2019

G Merge Plus is coming to town

No comments
G Merge Plus: A new, better version of G Merge

The wizy.io team is proud to introduce the newest add-on and application to our software portfolio: G Merge Plus.

G Merge Plus is a new, better version of G Merge in full compliance of Google’s User Data Policy, which emphasizes enhanced security controls for third-party apps. 

Same pricing, improved interface, and sensitive to user data. 

We’d like to invite all current G Merge users to transfer to G Merge Plus before January 1, 2020.

Your subscription: Paid G Merge users can use their existing subscriptions and license on G Merge Plus and continue to enjoy unlimited merges. 

Your settings and templates: With respect to user data, we will not be accessing templates and settings you have stored on your spreadsheet. You can follow the step-by-step instructions to transfer over your existing settings and templates from G Merge to G Merge Plus.   

What changed between G Merge 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).

As a result, our add-on/application requests much fewer permissions and none of the restricted API scopes. You can check how we use the permissions we do ask for in our Privacy Policy

  • Improved UI for the management web application.
    • 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? 

When Google launched Project Strobe and tightened their policies for Gmail, Google Drive, etc, we also wanted to fine-tune the permissions we request, as described in our own privacy policy

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.

If you’d like to ask for a demo or walkthrough on G Merge Plus, please reach out to our Customer Success team or email us at support@wizy.io. 

Leica PalileoG Merge Plus is coming to town
Read more

Planning a Field Trip with Parents, Students, and Multiple Approvers

No comments

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.

Click the “Create” button to create and link a form automatically
Edit the default form

(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.)

Customize the form to tailor to your needs

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. 

Approval workflows can be as simple or as rich as you want
If you are overseeing the workflow or process, you can set the default approver as yourself
Add your conditions, such as one approver per class
Filter requests per classroom to go to the homeroom teacher in charge

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. 

Filter all first-level approved requests by year level so that the second approvers can check

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. 

Under “Final notification” you can put the email address of the people who need to take action on the approved requests

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. 

Overseeing workflows 

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. 

We offer a 40% discount off our standard rates for educational institutions and non-profit institutions. If you need us to fill out vendor verification or send you an invoice for a purchase order, you may also contact sales@wizy.io

Leica PalileoPlanning a Field Trip with Parents, Students, and Multiple Approvers
Read more