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
How to Convert AppSheet Image URLs into Google Drive Viewable Links Using Apps Script? AppSheet is a powerful no-code tool from Google that lets you build mobile and web apps using Google Sheets data. But if you’ve worked with AppSheet image fields, you’ve likely encountered this issue: The image URL saved
How to Compress File Size Using ChatGPT (No Code Needed) Whether we are doing some online registration or submitting scanned documents for government services, we often face one common issue — the file size is too big. I too faced a similar problem. I had to upload a PDF under 1
