How to create custom running number with prefix. Simple steps!
If you're managing documents, invoices, or records in AppSheet, you may need a custom numbering system that resets at the beginning of each month. For instance, you might want your document numbers to follow a format like KKM/YYYY/MM/1 and automatically reset to 1 when the next month arrives. In this guide, we’ll walk you through the steps of creating a custom document numbering system that resets monthly in AppSheet, along with troubleshooting common issues. Why Use a Monthly Reset Document Numbering System? A monthly reset document numbering system can be highly beneficial when you: Manage
How to calculate distance between two points in Appsheet. FREE Method!
Have you ever needed to calculate the distance between two addresses in your Google Sheets? Whether you're managing logistics, planning a trip, or handling deliveries, knowing the distance between locations can be crucial. In this tutorial, we’ll show you how to use Google Apps Script and the OpenRouteService API to automate this process. function updateDistance() { const spreadsheetId = 'SPREADSHEET ID HERE'; // Replace with your spreadsheet ID const sheetName = 'Distance'; // Replace with your sheet name const sheet = SpreadsheetApp.openById(spreadsheetId).getSheetByName(sheetName); const range = sheet.getDataRange(); const values =
Mastering Google Apps Script: Holiday Calendar Automation in Google Sheets
Managing schedules, deadlines, and projects becomes significantly easier when you have a clear overview of upcoming holidays. Unfortunately, manually updating your Google Sheets with the latest holiday information can be time-consuming and prone to errors. In this blog post, I will walk you through how to automate this process using Google Apps Script, tapping into the power of the Calendarific API to fetch and display public holidays based on your specified country and year. This tutorial is suitable for anyone looking to streamline their planning and scheduling tasks in Google Sheets, regardless of their coding
Automating Email Encoding in Google Sheets using Base64: A Step-by-Step Guide
In today's interconnected world, ensuring the security of our digital communications is paramount. Whether you're sharing sensitive information with colleagues or clients, safeguarding your email content from prying eyes is essential. Fortunately, with the power of Google Apps Script, you can automate the process of encrypting and decrypting emails directly from your Google Sheets, adding an extra layer of security to your communication workflow. Why Encrypt Emails? Email encryption protects the contents of your messages from unauthorized access, ensuring that only intended recipients can read them. By encrypting your emails, you can safeguard sensitive information
How to Create a Website Monitoring Tool with Google Sheets and Apps Script
In the digital age, website uptime is critical for businesses and individuals alike. Downtime can lead to lost revenue, decreased user trust, and lower search engine rankings. While there are many website monitoring services available, they often come with a cost. But what if I told you that you can create your own website monitoring tool using tools you're likely already familiar with, such as Google Sheets and Google Apps Script? In this blog post, I'll walk you through the steps to set up your own monitoring system, complete with email notifications for any downtime
Automate Your Google Spreadsheet Backups with Apps Script
In the digital age, data is invaluable, and its loss can be detrimental. Whether you're a freelancer managing client data, a teacher tracking student progress, or a business analyzing sales trends, safeguarding your spreadsheets is crucial. Google Sheets is a powerful tool for data management and collaboration, but what happens when data gets accidentally deleted or corrupted? Regular backups are the answer, and Google Apps Script provides an efficient way to automate this process. Why Automate Spreadsheet Backups? Automating backups for your Google Sheets ensures that your data is periodically saved, reducing the risk
Streamlining AppSheet: A Guide to Removing Unused Images with Google Apps Script
In the realm of app development and management, efficiency is key. For those utilizing AppSheet, Google's no-code platform for app creation, maintaining a clean and optimized application can significantly impact performance and user experience. A common challenge faced by developers and project managers alike is the accumulation of unused images within their applications. These digital remnants, if left unchecked, can clutter your project and slow down your application. In this blog post, we will explore a practical solution to this problem using Google Apps Script. The Challenge of Unused Images As applications evolve, images and
Embracing Real-Time User Interaction in AppSheet with the New INPUT Function
In the landscape of no-code application development, AppSheet has continually stood out for its user-friendly interface and robust features. As a dedicated user and creator of AppSheet applications, I was thrilled to explore the platform's latest update - the new INPUT function in its General Availability release. In this blog post, I'll share my journey mastering this dynamic feature and how it can revolutionize the way we interact with apps. A Game-Changer for App Interactivity Gone are the days of static data entry forms. The updated [_INPUT].[user_input_urgency] syntax opened up new possibilities for real-time
Email Automation in AppSheet with LOOKUP Expressions
As businesses grow, the need for efficient communication channels becomes undeniable. AppSheet, with its robust automation features, presents a solution for those who juggle multiple tasks and need to keep stakeholders informed. Today, we're diving into the world of conditional email automation using AppSheet and how a simple LOOKUP expression can transform your workflow management. The Magic of LOOKUP: In AppSheet, the LOOKUP function is your key to unlocking dynamic and conditional email notifications. The expression: LOOKUP([_THISROW].[ItemType], "Email", "ItemType", "EmailRecipient") is a game-changer. Here’s how it works: [_THISROW].[ItemType] serves as a pointer to the
How to create Multi Box SVG in Appsheet
Creating multi-box SVG images for AppSheet applications offers a dynamic way to visualize complex data through scalable vector graphics. This method enhances your app's user interface by presenting data such as employee counts, scores, and more within visually distinct boxes, each customizable to reflect different metrics or categories. This guide will explore the fundamentals of SVG coding within AppSheet and provide a step-by-step approach to designing a multi-box SVG image that dynamically displays data, ensuring your AppSheet projects are both informative and visually appealing. Understanding SVG Coding in AppSheet SVG, or Scalable Vector Graphics, is
