Search multiple columns with different criteria
The built in search is very easy to use, but it only allows a single search term across all (searchable) colum...
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
Google Forms Integrations: Best Practices
Google Forms & AppSheet Best Practices The intent of this post is to document certain Google Forms behavior as...
Feature: Changing the language in your app (localization)
Feature: Changing the language in your app (localization) If your team could benefit from incorporating differ...
Limit a bot set to run hourly to specific hours or days
The hourly Bot event is a nice addition. But sometimes you might not want/need it to trigger 24hrs per day and...
How to format a field that is a checkbox in Google Sheets
I am new to AppSheet. I searched for an answer to this question in the help forums, but did not find an answer...
Flexible user role management
I’ve been working on my first AppSheet app and of course that meant reading through the vast amount of informa...
Bot timing out? Get the just the first 100 records formula
So I had a both that needs to send some SMS's to Twilio. Issue is that its doing other stuff as well and takes...
Easy Icon/Background/Launch image generation with no public URL needed (SVG)
Some time ago I took a look at this awesome idea from @RatatoskSVG launch image - Google Cloud Community With ...
Strip thousands separator from Enum
To Strip thousands separator1. Create Virtual Column names [YEAR_] Type NumberApp formula =YEAR( [DATE] )From ...
dynamic formating in form view
dynamic formating in form viewhttps://youtu.be/_52J7PY-btQ
SUMMARY TIP: User permissions, roles, and settings
The community frequently receives questions about how to provide different data, functionality, or design to d...
Step-by-step parent child copying method.
Previously published copying methods:Koichi_Tsuji : Copy parent record together with child records ; Action On...
Reset on edit functionality explanation (draft in progress)
There are myriad discussions in the community of the column-level Reset on edit property, but no comprehensive...
BULK IMAGE UPLOAD: Drag Files to Google Drive Folder and Auto-Add to AppSheet/Google Sheets
IMAGE UPLOADS: Current Limitations in AppSheet Only one image can be uploaded at a time Filename is tied to ke...
Non-English AppSheet Content
Hi All, Trying something a little different today. I know for many of you, English is not your first language ...
Add "Like It" features in a simple way
It is common to app user explicitly put a flag of “Like it” which will add “heart mark” to record you did so, ...
Manual Sorting (Move Items ↑↓ w/Buttons) || Bonus: Sequential Numbering
Hey everyoneThis has been on my list of things to do for awhile now, finally getting around to it. (^_^)In thi...
Convert RGB to Hex (decimal to hexadecimal)
Here is an expression to convert a RGB decimal number to a Hexadecimal. I used it in a color mixer. The column...
AppSheet session in Google I/O 2023
The AppSheet session at Google I/O 2023 was released.It seems that a demonstration of Chat integration and inf...
Calendario en español Looker Studio
Hola!En Looker Studio, hay alguna forma de poner el calendario en español? Gracias
Serial Numbers, If You Must
Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two ...
Mobile Dashboard Tabs
Dashboard views are great for apps that will be used at the desktop, but when accessing the same app from a mo...
New action: App update/Force sync
There are sometimes where the change the users are making through an action is so important that we need to ma...
In-app purchases
The community has periodic questions, and sometimes detailed discussions with links to many other resources, r...
Using a return value that is an array of objects to populate table
The return value of a call to an App Script returns an array of objects in the following format:[{"a":1,"b":2,...
Quickly adding multiple Columns to Column order (accidental discovery)
I find when I add a lot of columns for a View, making multiple mouse clicks is annoying; but, just one Column ...
Sample App - User Form with Multilingual Questions based on User Language Selected
Hi all,This Tip is posted for better visibility to all. The basis of this tip is the Query asked by @Surdusvac...
Create A FAQ Page with Card Views
We can create a simple FAQ page that expands /collapses the question answer pane using card views. Implementat...
The notions of TIME and DURATION and how to use in expressions
The notion of TIME: A TIME is a specific hour of the day You should write it in the following format: "00:00:0...
