Add text as layer to Image - Free API service
Another free API and easy to handle to add “text” over image we capture through the app. https://textoverimage...
Tips & Tricks
Find and share best practices on getting started, building an app, and more, to help you create successful apps with AppSheet.
Forum Posts
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...
Place the Google Sheet Chart onto Appsheet app
For those who may add more fravour to your appsheet app with chart image. Set up is super simple. Basically, c...
How to truly get "Last Month"
In the article for the MONTH() expression, it states you can use MONTH(TODAY())-1 to get the integer value for...
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...
Fix for expression giving 0% or missing decimal part
Trying to divide two numbers to get a percentage but always getting 0? Trying to divide two numbers but losing...
Convert Birthdate to Current Age in Years/Months format
Calculating the current Age based on a date-of-birth column: Formula FLOOR(HOUR(TODAY()-[DOB])/365/24)&" yr "&...
[Guide] Using Google Cloud Document AI with AppSheet
Introduction This is a simple guide for using Google Cloud Document AI form processing with an AppSheet app. T...
Add images by drag and drop
Hi everyone, As many of you know, we can also register image files in the emulator by drag and drop them. Have...
ChatGPT and AppSheet for Beginners, Building, Troubleshooting, Expressions, and Erros.
I'm sure this won't make Google happy, but I built a GPT called AppSheet Helper for any beginners who might ne...
Transfer ownership of an app that is built out
I have built out an Appsheet app with a number of test records in multiple tables and it includes stored image...
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...
Introducing the Appsheet View Customizer Chrome Extension for Improved Usability
Hi everyone,In my previous post (link), I shared a CSS code to customize the user experience when editing colu...
INDEXOF()
What is the index of the first occurrence of value in list (a list that uses delim as the element separator)?C...
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...
Column formula value missing after action
Hi All, Face with some challenge with column formula and action. See belowDriver value missing from source aft...
Nested Action Loops
I built this functionality today for a client, it seemed very share-worthy, especially since I wasn’t quite su...
Enabling app users to add Google Calendar events from your app
With a few steps, you can create custom actions to add events to a Google Calendar: Create a URL type virtual ...
Google Sheets UniqueId Apps Script
Here’s a tip on creating unique ID’s directly in Google sheets with Apps script: The code works by scanning yo...
Add any number of rows from any row within a table
Definitely a frequently-asked question: how do I add some number of rows to a table automatically? It’s possib...
Send emails
Greetings i have data entry App, which had appointments dates etc, I have a column named "Assigned To" i would...
Searching the whole App
If you like to know where in the App you are using a column, you can use the App Documentation. In this you ca...
Install MySQL on Always Free GCE and use it from AppSheet
For production, we should use Cloud SQL. However, if we just want to verify the integration with MySQL, we may...
Here() = “0.000000, 0.000000”
Problem: On my Android phone the expression HERE() was “0.000000, 0.000000”. Even though in the Android settin...
How to start using an app on your phone
This post is for beginners.The AppSheet platform lets you make an app in a computer browser. The interface loo...
Efficient AppSheet Trick: Speed Up Column Ordering
Hello everyone, today I'd like to share a helpful trick for speeding up your use of AppSheet.One thing I reall...
Learn how to open a file generated in Appsheet
How can I open a file that I created in my automation using appsheet only?I see that some new users are having...
