GreenFlux, LLCblog.greenflux.us·Sep 6, 2024Talk To Your SpreadSheet: Apps Script + Cohere AIAI can be a huge productivity boost, but it can also become a new bottleneck if it doesn't have existing access to your data. Bouncing back and forth between tabs and pasting sheets data into ChatGPT might solve one problem, but it creates another. I...Discuss·1 like·142 readsllm
GreenFlux, LLCblog.greenflux.us·Sep 3, 2024FeaturedBuilding an Interactive XY Image Plot with Google Apps Script and Leaflet.jsGoogle Maps has a ton of features for plotting points on a map, but what if you want to plot points on an image? These XY Image Plot maps are commonly used for floor maps, job site inspections, and even games. In this guide, I'll show you how to crea...Discuss·22 likes·323 readsgoogle-sheetsgoogle apps script
GreenFlux, LLCblog.greenflux.us·Aug 27, 2024Generating Heatmaps in Google Sheets using Apps Script and EChartsHeatmaps are a great way to visualize aggregate data so you can easily see trends and spikes in the data. They can summarize data across a range of time, display traffic and weather patterns, or any other series of data comparing two axis. One popula...Discuss·37 readsecharts
GreenFlux, LLCblog.greenflux.us·Aug 25, 2024Creating a Google Sheets Sidebar with MermaidJS ChartsGoogle Sheets has a ton of different chart types built-in, but there are a few types missing like Class, Sequence and Sankey diagrams, to name a few. When it comes to these types of charts, you usually have to export your sheets data to another tool,...Discuss·155 readsMermaidJS
nConnectaskai.nc.co.th·Jul 19, 2024Claude 3.5 Create CRUD WebAPP (Code)Make CRUD WebAPP On Google Appscript and Get Database from Google Sheets แจก Codeและ Prompt ภาษาไทย สามารถทำ APP แบบ CRUD (Create , Read , Update , Delete) ใช้ฐานข้อมูลของ Google Sheets ด้วย Claude ใช้คำสั่งบน Claude "ให้สร้าง HTML แบบ CRUD โดย ให้เ...Discuss·215 readsClaude AIcode
Eric Festablog.efcomputing.solutions·Jun 16, 2024Introducing Formstar: Simple, Serverless Form ProcessingIn the past, when I needed to host "static" sites - those that do not rely on server-side functionality like login sessions but instead rely fully on visitors' browsers (client-side) for rendering and interactivity - I looked to traditional web hosti...Discussforms
Eamonn CottrellforfreeCodeCampfreecodecamp.org·May 16, 2024How to Create a Pop-up Image in Your SpreadsheetIn this article, I'll show you two ways to create a lightbox effect in a spreadsheet. The first will trigger the image to be displayed in a large area in the sheet. The second will be an actual HTML popup on top of the sheet. If you want to follow al...Discussgoogle apps script
LebCitlebcit.hashnode.dev·May 3, 2024Creating Conditional Selections in Google Forms using Apps ScriptIntro I mentioned in the previous post that I was working on a project that made me develop Google's Query Language Wrapper.At the project's end, its owners asked if it was possible to use a Google Form, from where the users will submit their data in...Discussgoogle apps script
Nibesh KhadkaforfreeCodeCampfreecodecamp.org·Feb 9, 2024How to Create a Search Form in Google Sheets – Google Apps Script TutorialHave you ever struggled with navigating a massive spreadsheet? You can do away with the endless scrolling and unlock the power of targeted data retrieval with a custom search form using Google Apps Script. In this hands-on guide, we'll craft a searc...Discussgoogle apps script
Sam Borgessamborges.hashnode.dev·Feb 7, 2024Integrate UiPath and Google Apps Scripts using Orchestrator APITL;DR This article walks you through integrating UiPath with Google Workspace products to automate workflows by connecting to the UiPath Orchestrator API using Google Apps Script. Learn how to create queue items, read from queues, and start jobs. Ess...Discussautomation
