New Chart series - Half round gauge chart ; QuickChart new chart type
In addition to circle gauge chart as well as progress bar chart, which are generated using QuickChart Open Sou...
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
Integrar Google agenda e Google contatos com o Appsheet usando GAS
Integrar Google agenda e Google contatos com o Appsheet usando GASOlá a todosSeguem dois scripts do Google App...
Transparency / Opacity in Format Rules
You can use Hex colors with transparency / opacity in Format Rules. This one will look like this: If you add t...
KML Image Overlay / Ground Overlay for Watermark / Annotation
In column types like Address, LatLong, XY we can add an Optional Url for KML File. This can be used also for I...
Quick Tips (Easy) : Expression to construct URL to reach to your files
Manually constructing URL to reach out to your file with expression is found painful, when we need to get the ...
Convert a virtual column into a real column--or the reverse
At least some of this is pretty basic and maybe self-evident to others, but I didn't realize it was possible u...
Create Dynamic Links to Group the Same Table View BY ANY COLUMN!
Table views (and a few other types) have a ‘Group by’ option, to group rows by a certain column. But if you wa...
SECURITY FILTERS: Filter grandchild records based on parent ( [THISROW-2] ) without virtual column
Scenario Multi-user app, with tables for Client, Invoice, Line Item Client table contains client’s email Invoi...
Quick Tip Friday - Limit Functionality & Data Based on the User
Three tips today - they focus on how you can limit what users can see based on their role AND how to test that...
Bypass Security Filter ; Mystery solved
It was my long running mystery, "how and when we use “Bypass Security Filter” in workflow settings, but now th...
Timed out waiting for a resource
We got this Error Message when syncing the app:Unable to fetch app definition. Error: Data table 'TableName' i...
Quick Tip Friday - Find View Settings & Control Your App Based on Context
Two tips today focused on finding view and table settings and then controlling your app based on the user cont...
GEO-FENCING TRIGGERS: Send Webhooks to Add/Edit Rows or Trigger Actions Based on Location
Want to add a row or trigger an action when a user enters/exits a certain geographical area? App-creators can ...
42601: syntax error
This is not a trick or technique, but just a basic FYI tip in case someone receives the same error I did and s...
Great way to make [List of Notices] for a record
Often I find myself needing to find a way to communicate several things to a user for a record. Things like: -...
Quick Tip Friday
Hey folks, Hoping to kick off a series of quick tips from the archive to support those on their learning journ...
Dev Checklist | In-App checklists for keeping track of your development progress (FREE Auto-Table)
While building your app, it's helpful to have a list of tasks and ideas right there - in the app - to help you...
Open a Microsoft Teams conversation with AppSheet
Dear AppSheet Community, I just found a nice trick if you work with the Microsoft environment on your computer...
Sample App: Invoicing and Employee expenses, Report Generator
I made this Sample App as a playground for my Part 3 post (check the first reply) but it doesn't mean that you...
Postgres column types vs AppSheet column types
If you are planning to move to SQL, and you might came across my post about Supabase, you may be thinking abou...
Clickable Image with Hyperlink in PDF
In Google Doc Template we cannot apply a Hyperlink to an Image. I mean - we can. But when you create a PDF wit...
Easy way to add a hyperlink in your posts
I discovered this by accident but maybe many of you already know this.You can add a hyperlink into your post v...
Re-use main Detail view with multiple slices
It is a fairly common scenario to make a dashboard view that includes sub-views of various slices of the same ...
Add Events to the App-USER's Calendar Using Dynamic New-Draft Event Links
AppSheet can use a Google Calendar as a data source, but the app-owner is always the ‘Meeting Organizer’, or o...
Using Automation to (Mass Update Values) from One Table to Another - WITH THE PUSH OF A BUTTON
Use this "hack" to run an update action on a set of rows using Automation with the push of a buttonTLDRThe mai...
AppSheet Gallery on Desktop
Just in case no one knows this.The URL for the AppSheet GalleryI always make an App launcher to prevent my use...
🥇A MUST FOLLOW Youtube channel of AppSheet
I don't know if everybody knows, but, @MultiTech ´s channel is GOLD. He does a live transmission every Friday ...
Generate a website from your app
Based upon some messing around with html templates as well as fully understanding the requirements for Start e...
[BEST PRACTICES] Updating Apps With Offline Users
How can I manage updating an AppSheet app that's deployed if I've got offline users? How can I make sure that ...
