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...
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
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...
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 "&...
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...
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...
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...
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 ...
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...
Use Yes/No instead of Enum with two buttons
Here's a view where I stopped using an Enum column in favor of a Yes/No column: It looks like an Enum button d...
Apps Script - Google Groups - List all groups and users + Add/Remove User
Hi guys, here is my lastest script. It adds/removes users from google groups. Feel free to use it as you wish....
Drawing: Control size by initial value
A Drawing field might look too big on mobile devices. You can control the size by using an initial value like:...
Dropdown List Exclutive
I’m trying to make a dependent dropdown list, exclude items when selected for other fields (other dropdowns). ...
Table with heat map
Hi, I'm creating a table where I need to represent the counta distinct (because is text) of a dimension and th...
Cálculo digito verificador RUT (DNI) Chile / Calculation of verification digit RUT (DNI) Chile
soy nuevo en AppSheet, quisiera dejar mi primer aporte a la comunidad, como resolver el cálculo y la verificac...
Youtube embed link made easy with Appscript
My needWell, It turned out that I needed one app where I could add youtube links and watch them inside the App...
Export to Google Slides from AppSheet
Building presentations can be a time consuming process. There are many cases where the slides we need are simp...
Sample App: Multiple (and optional) dependent dropdown filters
I created a sample app to demonstrate setting up multiple search filters to narrow down the possibilities in a...
ChatGPT prompt: Repeating pattern in long expression
Here's a way of using ChatGPT that doesn't require much "intelligence" (even ChatGPT 3.5 can do it easily) but...
ChatGPT prompt: Correcting open and closed parentheses issue
Here's how I got help with an expression that had mismatched open and closed parentheses:https://chat.openai.c...
Appsheet assisted with OpenAI ChatGPT
Hi everyone,I'd like to use this post to share information and discuss the possibilities of using ChatGPT with...
Digitizing Shipping Documents with Google Docs
AppSheet Workflows can be used to automatically send notifications, change data, or generate documents. Below ...
How to Display 24Hrs Format
Hi all, As many know, Appsheet do not have support for 24Hr formats. In the forum there are many work arounds,...
How to control the Action Name and the Confirmation Button
Usually the Confirmation Button is the same as the Action Name or the Action’s Display name. By grouping the A...
