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 =
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
