Profile cover photo
Profile photo
Bjorn Behrendt (EdListen)
23,116 followers -
Google Certified Trainer & host of the EdListen.com Podcast.
Google Certified Trainer & host of the EdListen.com Podcast.

23,116 followers
About
Bjorn's posts

Post has shared content
Choice Eliminator Update ~ use dropdown instead of multiple choice for better reliability.

Please spread the word. A user reached out to me today and noticed that it was only Muliple-choice questions that were unreliable, and that changing the question to a dropdown caused many of the issues to go away. The person is using the form with over 1200 students.

I updated the warning when you open CE, it now reads:

Take Note!!!!

Use dropdown question type instead of multiple choice for better reliability.

Questions are set to required automatically to prevent two people taking the form at the same time from choosing the same option. When Google launched their new forms they broke this functionality for multiple-choice questions. This means that if two people are taking the form at the same time and have the form up. If person A selects 8:00 and submits, then person B selects 8:00 and submits it will go through as if the option was still available.

A user of CE has discovered that if you use a Dropdown type question instead of multiple-choice, the question will be stopped if the option has been chosen already. There is still a process time of a couple seconds per question where errors can occur but using a dropdown will increase reliablity greatly.

~ Bjorn Behrendt

Post has shared content
Choice Eliminator Update ~ use dropdown instead of multiple choice for better reliability.

Please spread the word. A user reached out to me today and noticed that it was only Muliple-choice questions that were unreliable, and that changing the question to a dropdown caused many of the issues to go away. The person is using the form with over 1200 students.

I updated the warning when you open CE, it now reads:

Take Note!!!!

Use dropdown question type instead of multiple choice for better reliability.

Questions are set to required automatically to prevent two people taking the form at the same time from choosing the same option. When Google launched their new forms they broke this functionality for multiple-choice questions. This means that if two people are taking the form at the same time and have the form up. If person A selects 8:00 and submits, then person B selects 8:00 and submits it will go through as if the option was still available.

A user of CE has discovered that if you use a Dropdown type question instead of multiple-choice, the question will be stopped if the option has been chosen already. There is still a process time of a couple seconds per question where errors can occur but using a dropdown will increase reliablity greatly.

~ Bjorn Behrendt

Choice Eliminator Update ~ use dropdown instead of multiple choice for better reliability.

Please spread the word. A user reached out to me today and noticed that it was only Muliple-choice questions that were unreliable, and that changing the question to a dropdown caused many of the issues to go away. The person is using the form with over 1200 students.

I updated the warning when you open CE, it now reads:

Take Note!!!!

Use dropdown question type instead of multiple choice for better reliability.

Questions are set to required automatically to prevent two people taking the form at the same time from choosing the same option. When Google launched their new forms they broke this functionality for multiple-choice questions. This means that if two people are taking the form at the same time and have the form up. If person A selects 8:00 and submits, then person B selects 8:00 and submits it will go through as if the option was still available.

A user of CE has discovered that if you use a Dropdown type question instead of multiple-choice, the question will be stopped if the option has been chosen already. There is still a process time of a couple seconds per question where errors can occur but using a dropdown will increase reliablity greatly.

~ Bjorn Behrendt

Post has shared content
After many user requests, I have chosen to keep Choice Eliminator 2 and Choice Eliminator Lite open. But I have added a warning that automatically pops up every time you open the add-on. I really wish I could make it better, and if google ever changes how they let developers handle submissions I will be happy to update.

After many user requests, I have chosen to keep Choice Eliminator 2 and Choice Eliminator Lite open. But I have added a warning that automatically pops up every time you open the add-on. I really wish I could make it better, and if google ever changes how they let developers handle submissions I will be happy to update.

Post has shared content
Announcing User Gopher -- Google Sheets just got G Suite user management superpowers. Sign up for early access (free). Unlimited free license through July 1. (longer term pricing still TBD).

Some key User Gopher (beta) features:

- All bulk user actions provide a full, granular preview where you can inspect all changes and optionally exclude unwanted fields from the update.
- Load users by OU, active state, or last login time and apply Sheets filters to any user field or property to limit users for update.
- Load all group memberships to Sheet.
- Bulk generate and reset user passwords and distribute them via a printer-friendly email to designated points of contact.
- Bulk modify all of these key user properties and attributes directly via Sheets edits:
-- Org unit
-- Global contact visibility
-- Suspended / active
-- Password
-- Force password reset on next login
-- Basic information, including
-- First name
-- Last name
-- Primary email address
-- Contact information, including
-- Work phone 1
-- Home phone 1
-- Mobile phone 1
-- Work address 1
-- Home address 1
-- Employee details, including
-- Organization name
-- Employee type
-- Location
-- Employee ID
-- Employee title
-- Department

Anyone else seeing issues with App Script? I am getting "Could not connect to server" errors when I try and run functions. 

I am shutting the Choice Eliminator Add-on down at the end of February. Google changed things when they launched the new Google forms, that have make it very unreliable. I have tried many different approaches to make it work better, but at this point I don't feel comfortable keeping it active.

I am shutting down the Choice Eliminator add-on unless someone wants the project. (Any Takers?) Since the launch of new Google Forms, the reliability has gone down, and dispute many approaches, I have not figured out a way to make it work better.



Post has shared content
Wait while more posts are being loaded