AppsScriptPulse

Community News

Totally Unscripted: Beyond Basic Bots – Building Intelligent Assistants with Google Chat and Vertex AI 21 February, 2024 at 1200 PT / 1500 ET / 2000 GMT

Tags:
| | 0 Comments |

Totally Unscripted returns on 21 February 2024 at at 1200 PT / 1500 ET / 2000 GMT with an episode exploring how you can unleash the power of intelligent assistants and apps in Google Chat.

Say goodbye to simple chatbots and hello to intelligent assistants and apps! On 21 February 2024 at at 1200 PT / 1500 ET / 2000 GMT on Totally Unscripted, we dive into the world of building advanced enterprise apps and assistants using interactive dialogs and Vertex AI in Google Chat.

As part of this, we will be exploring how you can harness the capabilities of the Google Chat Platform to promote collaborative work within Chat spaces, taking advantage of Google’s advanced machine learning models to create assistants that can help with complex tasks, such as summarizing conversations and generating complete task descriptions from simple titles.

Get ready to go beyond the basics and learn how to build sophisticated assistants that help you get more work done, collaborate with your team, and revolutionize the way you work with Google Chat and Google Workspace.

As always the show is broadcast live and you can ask questions via the YouTube chat, but also interested to hear in advance any of your burning questions for our panel using the comments section below.

Show Live/Recording link – https://www.youtube.com/watch?v=UGwj4dVTe4A

Community News

Totally Unscripted: Google Workspace Development: Now with a Side of Smart Chips! 07 February 2024, 2024 at 1200 PT / 1500 ET / 2000 GMT

Tags:
| | 0 Comments |

Totally Unscripted is back on 07 February 2024, 2024 at 1200 PT / 1500 ET / 2000 GMT. There have been a number of saucy updates and announcements around Smart Chips and other integrations to Google Docs, as well as Sheets and Slides.

In this episode we review how you can start to create Google Workspace Add-ons for Google Docs, Sheets, and Slides users which let you preview links from your third-party services. In addition we will be dipping into how you can let users of Google Docs add third-party resources from the @ menu.

For this episode we will be joined by some of the Google team behind Smart Chips with guests Allison Hodsdon (Technical Writer at Google) and Pierrick Voulet (Developer Relations Engineer (Google Workspace) at Google.

As always the show is broadcast live and you can ask questions via the YouTube chat, but also interested to hear in advance any of your burning questions for our panel using the comments section below.

Show Live/Recording link – https://www.youtube.com/watch?v=IPrWpV_bf4c

Community News, Official News, AppSheet, Drive

Changes to drive.google.com/uc URLs which break embedding images/files from Google Drive in your websites and AppSheet apps

Tags:
| | 0 Comments |

Google Drive broke the ability to embed images with the /uc path. Here’s how to embed images from Google Drive in your website.

Previously Google Workspace developers could use a /uc path for embedding images and other files hosted in Google Drive. For example, images could be embedded in websites and emails using markup like:

<img src="https://drive.google.com/uc?export=view&id=1234567890abcdef" />

To my knowledge this was never an officially documented endpoint, but widely known about and shared within the community. Back in October 2023 Google announced Upcoming changes to third-party cookie requirements in Google Drive, which has started rolling out from the beginning of 2024.

The impact of this change is it breaks /uc embeds and these have started returning 403 errors. There is no reference to the /uc endpoint in the original announcement, which is why I think many people are only just finding out about the impact now. Google’s official guidance is to move to <iframe> with Google Drive publish and preview links. This post from Justin Poehnelt discusses the options and limitations for images.

There has also just been another announcement in the AppSheet community that Drive download URLs for embeddable content to be updated by May 1st, 2024. This is an extended window for AppSheet users and where possible Google will be emailing affected app owners where /uc urls have been detected. This announcement includes a link to a help page with tips for finding /uc occurrences in your AppSheet apps.

Source: Embed images from Google Drive in your website | Justin Poehnelt

Community News, AppSheet, No Code

Unlock the power of your data with no-code! Join the CTS AppSheet Hackathon at the Google London 08 February 2024 

Tags:
| | 0 Comments |

Be part of our AppSheet Hackathon Series in 2024! Join us at the Google office in London for this in-person event in February. Find out more.

My employer CTS/Appsbroker is hosting a free AppSheet Hackathon in Google Office in London on 08 February 2024. This in-person event is the first of four we are planning this year designed to bring both new and existing AppSheet users together to learn and share.

For new users there will be a guided ‘no-code along’ to help you get started, followed by a hackathon with on-hand support. You can find out more including registration by following the link (if you are able to attend my tip would be bring a work colleague as this will help you bottom out your business use cases). I’ll be attending the event so if you are able to attend please come and say ‘hi’.

Source: AppSheet Hackathon – CTS

Community News

Totally Unscripted: How developers are shaping the future with Google Workspace and GenAI – 24 January, 2024 at 1200 PT / 1500 ET / 2000 GMT

Tags:
| | 0 Comments |

For the next live broadcast of Totally Unscripted we will be exploring how Vertex AI and other GenAI solutions can be used to extend the capabilities of Google Workspace with targeted solutions that integrate seamlessly with Google Workspace Add-ons, Editor Add-ons, Chat apps, Drive apps, and more!

In this episode we will be joined by a panel of expert guests: Donato Meli (Workspace Go-To-Market at Google), Mohammad Al-Ansari (Developer Advocate (Partnerships) at Google), and Allen Firstenberg (Project Guru at Objective Consulting, Inc).

As always the show is broadcast live and you can ask questions via the YouTube chat, but also interested to hear in advance any of your burning questions for our panel using the comments section below.

We will be LIVE on 24 January, 2024 at 1200 PT / 1500 ET / 2000 GMT

Show Live/Recording link – https://www.youtube.com/watch?v=IPrWpV_bf4c

Community News

Totally Unscripted Returns! Since We’ve Been Gone: A Recap – 10 January, 2024 at 1200 PT / 1500 ET / 2000 GMT 

Tags:
| | 0 Comments |

WE ARE BACK!!! Totally Unscripted returns for more Google Workspace Developer community chat about new features, popular solution trends, best practices, the Google Workspace Marketplace and everything else related to Google Workspace development.

To kick off the return of Totally Unscripted for Season 5, in this episode the TU crew will take a look back at some of the more significant updates and additions involving the Google Workspace Platform “Since they’ve been gone!”

As always the show is broadcast live and you can ask questions via chat, but also interested to hear in advance any of your questions using the comments section below.

Show Live/Recording link – https://www.youtube.com/watch?v=V-Z3BcAjRKk

Community News, AppSheet

[Event] Connected Workers: Using AppSheet to bring the frontline and head office together – Online October 19, 2023 at 14:00 UTC

Tags:
| | 2 Comments |

Join us for an exciting showcase event with Google presenting an AppSheet demo developed to connect frontline workers with head office.

On October 19, 2023 at 14:00 UTC you can join me for a free online live webinar with Tony Martin, Google Workspace specialist and Dominic Parkes, Google Workspace Customer Engineer at Google to discuss a demo app created in Google AppSheet to help bring frontline/deskless workers and head office together more efficiently.

This session is an opportunity to discover how AppSheet can be used to make it easy to administer everyday business tasks such as: reporting sickness, managing shifts, payslips and HR records, onboarding and training. We’ll be discussing the benefits of using AppSheet to solve this problem and getting Tony and Dom’s top tips when it comes to Google AppSheet app creation.

Follow the source links to reserve your place…

Source: Connected Workers: Using AppSheet to bring the frontline and head office together – CTS Website

Community News, Library, Solutions, Sheets, Intermediate

Management of rich text cell formatting in Google Sheets with Google Apps Script

Tags:
| | 0 Comments |

In order to add and delete a text for the rich text in a cell, it is required to create a script while the current text style is kept. This is actually complicated. In this post, I would like to introduce the enriched management of rich text on Google Spreadsheet using Google Apps Script. In order to enrich the management of Rich Text using Google Apps Script, I created a library RichTextAssistant.

Some very clever work from Kanshi Tanaike which can help with the management of cell text formatting in Google Sheets.  The RichTextAssistant Apps Script library included in the post has some nice methods for both handling and preserving cell text formatting. It’s worth spend a little time checking the various samples provided to see what is possible and how these might enhance one of your own script projects.  If you are curious the source code for the library is also on GitHub and linked from the post.

Source: Enriched Management of Rich Text on Google Spreadsheet using Google Apps Script

Community News, AppSheet, No Code

Register for an online AppSheet ‘no-code’ along with Tim McLardy and Martin Hawksey 3-5 May, 2023

Tags:
| | 0 Comments |

Did you know? We’re offering 20% off registrations for our FIRST public AppSheet no-code-along! ⭐️

With AppSheet, you can simplify business processes without ever needing to write a single line of code. This can help you out if you have users managing data on mobile devices, getting lost in spreadsheets, or even still using pen and paper!

Our two part course will include hands-on experience of building a simple app alongside our in-house expert Martin Hawksey as well as covering all the basics you need to get your creative juices flowing!

Don’t sleep on it, this offer is only available until the end of March. Sign up today to secure your discount

If you are still unsure where to start with Google’s no/low code platform, AppSheet, on 3 + 5 May I’ll be joining Tim McLardy to help you get started on your journey as part of our two part ‘no-code along’. There is a discount if you register in March and Tim and I will be working extra hard to make sure you get the most out of the session.

Source: AppSheet No-Code-Along

Community News

Google Apps Script trends in Stack Overflow for 2022

Tags:
| | 0 Comments |

From the above results, it can say that the current Google Apps Script has still been useful for a lot of users. But, the number of questions for one answerer is increased proportionally to the square of the year. Furthermore, the ratio of the solved questions for the total questions in 2022 is lower than that of 2021. So, in order to improve these issues, it is considered that growing answerers will be one of the important factors for the selectivity of Google Apps Script by users.

Kanshi Tanaike has recently published the 5th annual review of Google Apps Script tagged questions and answers on Stack Overflow [google-apps-script] to include data from 2022. This type of data always has to be read with caution. For example, whilst the total number of questions has again declined this year it could be argued this is because there is now a much bigger published knowledge base of both official and community resources. Declines in the number of people answering questions is more concerning. If you are someone who contributes to Stack Overflow a big thank you!

Source: Trend of google-apps-script Tag on Stackoverflow 2023