AppsScriptPulse

Add-on, Solutions, Sheets

Goal Seek in Google Sheets – How To Use Goal Seek In Google Sheets

Tags:
| | 0 Comments |

Learn how to use Goal Seek in Google Sheets. The Goal Seek feature enables you to change input values to make a formula result match the goal you specify.

We’ve highlighted the new Goal Seek Add-on previous in Pulse, but if you missed it or wanted to see some more practical use cases Ben Collins has expertly covered how to setup and use it.

Source: Goal Seek in Google Sheets – How To Use Goal Seek In Google Sheets

Solutions, Maps, Sheets

The classic Halloween dilemma: how to visit as many homes as possible solved by Eric Koleda with a little Apps Script

Tags:
| | 0 Comments |

Solutions, Calendar, Sheets

Creating Calendar events using Google Sheets data with AppScript

Tags:
| | 0 Comments |

Today I’m going to show you how to automatically add Meetings/Events data from Google Sheets into a Google Calendar. This trick came really handy for me so I hope this will serve you the same.

How to automatically add Meetings/Events data from Google Sheets into a Google Calendar.

Source: Creating Calendar events using Google Sheets data with AppScript

Solutions, Sheets

How to edit a row in Google Sheets via ManyChat using Apps Script – Baloka

Tags:
| | 0 Comments |

I’ve not come across ManyChat, a service to build chat bots on Facebook Messenger, but they have free account options. In this demonstration by Gilbert Mizrahi (@GilbertMizrahi) you can learn how ManyChat can be used with Apps Script to update data in a Google Sheet row.

Source: How to edit a row in Google Sheets via ManyChat using Apps Script – Baloka

Solutions, Sheets

Google Apps Script Physics Problem Database

Tags:
| | 0 Comments |

Database

This post will be mostly about how to use GAS as a data-driven, responsive website, with the Physics Problem Database really just the example Andy Rundquist (@arundquist) put together to show things.

Source: Google Apps Script Physics Problem Database

Solutions, Forms, Sheets

Create a seat booking form with Google Forms, Google Sheets and Google Apps Script – Yagisanatode

Tags:
| | 0 Comments |

In this tutorial, Yagisanatode (@LifeOfSpy) is going to build a simple seat booking Google Form that will contain a registeree’s name and the session that they wish to attend. Each time a registeree submits a request to book a seat for a session, that seat is taken from the list displaying only the remaining seats for that session for when the next user submits the form.

Source: Create a seat booking form with Google Forms, Google Sheets and Google Apps Script – Yagisanatode

Solutions, Sheets

Amazon Price Tracker – Monitor Price Drops on Amazon with Google Sheets

Tags:
| | 0 Comments |

Learn how to use a Google Sheet to track product prices on Amazon shopping websites and get email alerts when the prices go down or up.

Always interesting to see the projects Amit Agarwal comes up with. This post includes a link to the free version of the Google Sheet.

Source: Amazon Price Tracker – Monitor Price Drops on Amazon with Google Sheets

Add-on, Official News, Sheets

G Suite Updates Blog: Goal Seek add-on now available for Google Sheets

Tags:
| | 0 Comments |

You can use the Goal Seek add-on to calculate the required value of a cell to achieve a desired value in another cell. This is particularly useful when conducting break-even analysis or sensitivity calculations, like determining how changing one value affects other correlated values in your sheet.

Interesting to see Google extending the functionality of Google Sheets with this official add-on

Source: G Suite Updates Blog: Goal Seek add-on now available for Google Sheets

Add-on, Solutions, Forms, Sheets

Create a Branching Google Form – Teacher Tech

Tags:
| | 0 Comments |

Alice Keeler’s architecture on designing your Google Forms to provide immediate feedback by utilizing branching options is fascinating and efficient.

Create multiple sections in your Form and add only one question per section that determines which section to jump to next. Answer correctly and the branching should take the student to the next question. Answer incorrectly and be taken to a section with a tutorial or hint and a chance to answer a new question.

Source: Fast: Create a Branching Google Form – Teacher Tech

Solutions, Forms, Sheets

How to use Google Sheets and Google Apps Script to build your own blog CMS

Tags:
| | 0 Comments |

Build a “Content Management System” (CMS) for an online blog using Google Sheets, Google Forms, and Google Apps Script.

Source: How to use Google Sheets and Google Apps Script to build your own blog CMS