Google Sheet Adds-On

-
Today, I want to share my useful adds-on with you.
  • autoCrat: This adds-on makes PDF and send emails to users with the attached PDF.
  • formmule-Email merge: It sends email according to sheet data.
    You can create email templates and set up triggers such as form and time triggers.
  • Remove Blank Rows (and more!): It remove or hide blank rows.
  • copyDown: There are formula in the 1st row. This add-on paste formula or paste as value on the other rows.
    P.S. If you use ARRAYFORMULA, you may need to use it!
  • formMule-CalendarMerge: It creates Google Calendar event and put in the assigned Google Calendar and shared with assigned users.
  • formRanger: Remember, student and staff forms. You do not need to update the form lists everytime one by one. formRanger takes the form choices directly from a sheet. It allows you to populate multiple choice, list, checkbox, and grid options from columns in any Sheet or Doctopus roster. 
  • Choice Eliminator 2: You can create a parent teacher conference. It automatically remove options that have already been selected in a Google Form.





Comments

Post a Comment

Popular posts from this blog

My CCNA Useful Links

-
Summary of All Topics-1 Click on the "Sections (Theory)" part. Summary of All Topics-2 Summary of All Topics-3 Cisco Networking All-in-One Cheat Sheet GENERAL INFO&TERMS IPv4 IPv6 ROUTING OSPF Explanation Video OSPF Lab - 1 OSPF Lab - 2 EIGRP Explanation Video EIGRP Lab - 1 EIGRP Lab - 2 Troubleshooting: Check AS, networks must be configured under eigrp (check the interface ip to see there is any missing network), metric values must be same. Static and Default Route Lab HSRP Vs VRRP Vs GLBP Redundancy Protocols How to Break Cisco Routers Password Using Rommon Mode Don't forget to go rommon mode back and start your router with default register value which is 0x2102. This part is not in the video. SWITCHING STP VTP STACKABLE SWITCH ETHERCHANNEL VLAN HOW TO CONFIGURE ROUTER ON A STICK - 802.1Q TRUNK TO CISCO ROUTER How to Confi gure Port Security on a Cisco Switch   OTHER ACL Router1(config)#access-list 101
Read more

My Rise Vision Experience

-
Image
I want to post the photos in Google Drive. HOW? There's a 3rd party widget, the Photo Feed Widget, which you can use to show images in a Google Drive folder.   Here's a quick video walkthrough . The photo comes at the corner of the screen. It should be center. HOW? ( I was using Samsung 65".) The resolution should be 4K which is  3840 x 2160 I have several photos and am adding more! What should I do for duration. It should be "Play Until Done" on Photo Feed Widget under Presentation and under playlist under Schedule How can I add Google Slides? https://help.risevision.com/hc/en-us/articles/360029722492-Edit-Google-Slides Please make sure that  a slide duration and total slide duration fits.
Read more

General Printer Errors

-
Q: When I send a print to the copier it takes several minutes to print ! A:   The reason can be the size of the file and the resolution. (What are the size of the file and how many pages?) or driver issue (needs to update latest version) or printer firmware issue (needs to update latest version) or speed negotiation issue (set speed/duplex manually on both ends (switch and copier)). Q: The address label doesn't fit on the paper! A:   Make sure that it fits the page. You will see it when you goes the print > more settings (The scale may not 100%. ) Q: The wifi drops down! A:   I recommend you to do the followings: Check the printer firmware. (Refer the manufacturer website.) Check your machine wifi capability and you network band. (2.4GHz or 5 GHz) Check your network minimum bitrate (Mbps) Be careful! increasing or decreasing it may affect your network, if you have close AP in the building. Try usb cable no longer than 2 meters. (Some devices doesn't
Read more