Part 3: Pixel perfect reports with Skia (AppSheet's PDF generator)
Well, it's about time, isn't it? Some months ago I told you I'd make a final part 3 talking abour tips to get...
Forum Posts
FAQ: Add a number of rows
Add an arbitrary number of rows to a table based on a column value of type Number. Try the sample app! For thi...
Creating a calendar of events in Appsheet that puts them on Google Calendars automatically
Hello all. Often I come here to ask questions, but today I thought I'd share something I came up with that may...
Google Developer Expert Office Hours
Hey AppSheet Community!My name is Landan Quartemont. I am a recent addition to the Google Developer Expert Pro...
How to apply a custom file name to multiple images uploaded in the app
The goal User provides some information in the app User uploads a photo AppSheet applies some logic to create ...
Express DURATION values in Days (ie in automation Wait/Pause)
Sharing this nugget because I can't find it referenced anywhere in AppSheet Help or this Community and thought...
Export to Google Docs from AppSheet
AppSheet already provides the ability to automatically generate a PDF document based on a template, but someti...
Manage app user access with AWS Cognito and Google Apps Script
If you're working to Control user access using AWS Cognito in your apps, that can be greatly facilitated by ut...
How to generate direct image URLs
TEXT([Image]) Put the express in a virtual column with “URL” type. If you need to store the link itself, you m...
Single category headers in workflow templates for multiple records of same category
Say you have data like this: With “Group by” selection in a Table view, you can easily display this in the app...
How to control or rename uploaded files in a [file] column
(*NOTE: Only applicable for Google users (GSheet/GDrive))As you all know, when a file column is used in your a...
FAQ: How do I do something automatically the first time someone uses my app?
How do I setup/register a new app user automatically? How can I do something automatically the first time a us...
Export to Google Sheets from AppSheet
There are some cases when a user needs to export data from an AppSheet app and CSV/PDF may not be sufficiently...
Copy Parent and child records in one action. No API
I’ve managed to develop a way of copying a row from a Parent table along with its Child records. It uses a num...
Get data from "simple" APIs by using "Return Value" option in AppSheet
This tip is just to share a working example of "receiving" or getting data by using "GET" verb from an API usi...
Using INPUT() to update another table using a value from this row
Update regarding new syntax.I have not had time to update the images and text in this post to reflect the new ...
Use GAS : Create reports having different background cell colors, headers, footers and page numbers
This tip is mainly extension of a few tips that make use of Google Apps Script(GAS) for various reporting opti...
GDE Office Hours Recap [Scaling AppSheet Apps]
Hey Folks,As I mentioned a couple weeks ago, I just kicked off a weekly office hours at 11 AM CST on Wednesday...
FAQ: add row per value in EnumList
Add one row per value in an EnumList column list. Try the sample app! For this example, the table from which t...
OpenAI & AppSheet #3: Enhance Your ChatGPT Interface with Supporting Info for Continued Conversation
Hello AppSheet community! I'm back with the third video in my series on creating a ChatGPT-like interface in A...
Try out my Custom GPT for AppSheet with the entire AppSheet documentation underneath it
Hi everyone! I'm excited to introduce you to my latest digital team member: App Sheet Pro Assistent! Here i...
Bulk Select Multiselect Select All
We can do Bulk Select in Table, Deck and Gallery View. We can even navigate to a view that’s already in Bulk S...
Scheduled Reminders || Sample App
Hey everyone If you need to know how to include scheduled reminders that go out in either Email or SMS text fo...
Scan barcode with your native mobile camera and jump to target view
I suppose loads of people are using Scanning functions here and there withi the app you generated. Probably mo...
APPS SCRIPT: Download Gmails to GSheet, using Gmail Filters/Labels
This Apps Script will monitor your Gmail for new emails that match a certain label, and: Add a New Row to GShe...
Insert Colorful Status RYG Images in the Reports
This tip and trick started based on the requirement of the following post. https://www.googlecloudcommunity.co...
Quick Update System - How to update records in your app with a push of a button
“How can I update a parent record when a child record is changed?”“How can I mark all the line items in an inv...
Create elegant "in app" reports using Google Apps Script
Overview of The Tip Show More Describes the approach to create less frequency reports such as daily/weekly/mon...
Call Vertex AI via Apps Script
Generative AI This use case integrates with the PaLM 2 for Text model in Vertex AI via an API connection. Vert...
Create a PDF report with watermark or beautiful certificates etc. using Google Apps Script (GAS)
There are several requests in the community to create a PDF report with watermark. The below post has relevant...