How to Prevent Duplicate Item Entries Inside a Parent-Child Form Relationship in AppSheet? When building apps in AppSheet, one of the most common challenges in a parent-child form setup is avoiding duplicate entries.Recently, while creating an Expiry Management System for a Medicine Distributor, I faced this issue. The setup had
How to Remove 'sum' from Headers in QUERY Results in Google Sheets? When working with Google Sheets, one of the most useful formulas for summarizing large data is QUERY. It allows you to group, filter, and calculate totals without using Codes and Pivot Tables, which are often too clumsy. However, there’s a small issue that often shows up —When you use SUM() inside a QUERY, the output header
Parent — Child Relationship How to Create a Parent-Child PDF Layout in AppSheet (With Real Example) Recently, I was working on an inventory workflow where a receipt record had multiple items. The challenge? I wanted a PDF layout where the receipt header appears on top, and the child items are neatly shown in a table below. Sounds simple,
How to Send Grouped Bulk Emails by Party in Google Sheets (with Filters) Recently, I had a situation where I needed to notify multiple parties about discrepancies in their deliveries. But here’s the twist — the data was in Google Sheets, and I didn’t want to send individual emails for
How I Automated a Daily PDF Report From Google Sheets (And Emailed It Out Automatically) This used to be my routine: Open Google Sheet → filter today’s data → format → download as PDF → open Gmail → attach → send. Not anymore. I got tired of doing the same
How to Automatically Remove Date Validations from All Sheets in Google Sheets? Recently, while working on a shared Google Sheet, I noticed something odd. Every time someone edited a column that had a date header, it would automatically trigger a date validation. The cell would suddenly expect a proper date
How to Organize and Run Apps Script Functions with Custom Menus in Google Sheets? If you’ve ever created a powerful function using Google Apps Script — maybe to send Emails, clean up data, generate invoices, or sync records — the next logical question is:“How do I make this usable for
How to skip Google Apps Script Time Based Triggers on Sundays? Learn to avoid sending unnecessary emails on weekly off days. We recently created a Google Sheets-based automated report for one of our clients. The report was scheduled to be emailed every evening at 8 PM using a time-based trigger in Google Apps Script. Everything
How to Remove Duplicate Rows Based on Column A Using a Google Apps Script? Recently, while working on a Google Sheets solution for one of our clients in the pharmaceutical distribution space, we ran into a frustrating yet common issue — duplicate entries in their Party Master. Every time data was imported
Working with Time, Dates, and Totals in AppSheet: A Practical Guide Tracking and calculating time-based data can feel intimidating in a no-code platform like AppSheet. But with the right expressions and a practical understanding of how AppSheet processes rows, you can build powerful tools without writing a single line of
