Blockquote vs. UL in HTML
This tiny tip is for folks who use HTML in their apps to improve the UX. If you happen to be unaware of how to...
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
How to Dynamically Create Smart Areas/Boundaries on a Map
Hi Everyone, I have created a sample app that demonstrates how app creators can create apps that lets users cr...
Create heat map table chart using table views
This tip is for creating heat map table charts using table views in AppSheet. There are multiple articles avai...
Optimizing SVG "interface" images
This post is an addendum to my "Using SVG 'interface' images" tip which you can find here:https://www.googlecl...
Using SVG "interface" images
This tip is a workaround to solve a problem for which a new feature has been requested. The feature requests (...
Share: Appsheet learning materials from basic to advanced 98 pages
Hello everyone, I'm Hoa, but you might also know me as Hoa Data. I’ve been working with AppSheet for over 3 ye...
Why Do Some Actions in AppSheet Execute One by One While Others Run in Batch?
When working with grouped actions or actions that execute on a set of rows, you may notice that sometimes rows...
FREE Chrome Extension that enhances the Expression Assistant [AppSheet Toolbox/QREW Tools]
Hi AppSheet Community As someone who is in the App Editor 24/7, I frequently catch myself trying to remember t...
Exciting Update: AppSheet Introduces "Allow App Embedding" Feature!
Hello AppSheet Community,I'm thrilled to announce that AppSheet has launched the "Allow App Embedding" featur...
Action in Form View
Can we use Action Buttons in Form Views? The official answer is: No. Here is an example. But I found a way how...
It shows "smallest" size when click in image
When we click in image, it show smallest size first then we have to click in the "+" button.I think it's bette...
Add multiple rows from one table to another using a form & action instead of one by one with a form
Friends, I’m going to share an intermediate tip (if we want to rate it by difficulty level; neither too hard n...
Chrome Extension: Automatically Open Images in a New Window on AppSheet
Hello everyone! I came up with an idea to make working with images in AppSheet more convenient, and with the ...
Connet Appsheet with thermal printer
Appsheet with thermal printer - Print directly from appsheet to thermal printer, press print immediately, no n...
Python script to export data relationships from your AppSheet app
I recently needed to inventory the relationships in my app to plan a migration of my data source from Google S...
Use the GCP Integration Connectors as a data source for AppSheet
Connect AppSheet to SAP, Snowflake, ServiceNow and more! Check here for a list of supported connectors. Main c...
GCP Architecture Diagramming Tool
Hi everyone,I see that the GCP configuration diagramming tool has been released.https://cloud.google.com/blog/...
Add a column without disruption when using spreadsheet data source
The single most important thing is to avoid putting anything in any data (non-header) cell of the new column: ...
FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()
Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW...
Convert Number into Text using AppScript
Learn how to convert numbers into text dynamically in AppSheet.This is useful for contracts, invoices, and aut...
Add accordion effect in the detail view
At times the detail view of a record has multiple fields and as such scrolling down an entire record can be a ...
How to check the total row count in the app/device
It seems that this trick to read the quantity of rows in the device has not posted.. so here you are - Open t...
Nested Action Loops
I built this functionality today for a client, it seemed very share-worthy, especially since I wasn’t quite su...
IMAGE EDITING! Rotate, Crop, Resize, Mirror, Etc- Using FileStack & URL Parameters
Disclaimer: Free signup at https://www.filestack.com/ is required in order for each developer to have their ow...
How to delete blank rows in Google Sheets
I have an app that uses parent and child records with IsPartOf turned on. When I delete a parent record, it on...
Add a custom search feature
Create a Search table Add a Search table based on your preferred data source. This is a table that will contro...
Manual Recovery - Excel File for Getting Your Data Back
This week I had one app fail with critical data that I needed. The user went through the manual recovery steps...
Use Google Gemini AI API with AppSheet apps to get insights from images uploaded in the app
This tip is the next in sequence to the tip below. Integrate AppSheet with Google Gemini AI API using... - Goo...
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...
How to find the Index() position of an item from a list
Sometimes when working with lists, you find yourself needing to know at what position an item sits in a list. ...
| User | Likes Count |
|---|---|
| 26 | |
| 20 | |
| 12 | |
| 8 | |
| 7 |
