Reset on Edit
The ‘Reset on Edit’ setting is a great way to automatically set ‘Last Edited Date/Time’, ‘Last Edited By’, or ...
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
Link to an external web site
This tip explains a couple of workarounds for problems that I hope AppSheet can address. So, here’s hoping thi...
TRANSLATIONS LOCALIZE UX (LANGUAGE)
https://www.appsheet.com//templates/?appGuidString=bb10110f-fc36-4e9b-aea7-d741d32acf1c
Open File/Image with external browser without looking up cache
I posted this https://community.appsheet.com/t/expression-to-construct-url-to-reach-to-your-files-by-ignoring-...
BOT Monitor - Monitor BOTs within App and get notified about BOT errors
This Tip is inspired from the post BOT Early Warning System by @1minManager and the help i received from @dbau...
Initiate calls from Google Voice
This is a simple one - initiate phone calls in Google Voice on your desktop or mobile device using the followi...
New AppSheet book by Koichi, Suvrutt and Takuya
Major kudos to @Koichi_Tsuji , @Suvrutt_Gurjar and @takuya_miyai for their excellent book on AppSheet developm...
Slow apps and speed problems solved!
Hi,I have had problems with slow apps etc for a long time. I have broken them up and removed slow expression e...
Delete child records when parent is deleted (alternative to "Is a part of?")
Child records are connected to the parent record via a column of type Ref.When you enable Is a part of?, all c...
Many-to-Many Relationships
AppSheet by default supports One-to-many relationships: One record (say an Order) that has many related record...
Integration with Google Chat - How? Actually it was ultra easy
Appsheet should naturally get tied with G Suite services and product as the time goes by, which is basically “...
Here is a solution for large Android font sizes breaking apps
I've been struggling with my table views breaking when users with poor vision have enlarged their Android syst...
AppSheet was added to Service Health in GCP.
Maybe I just missed the release notes, but AppSheet's status was added to GCP's Service Health. https://status...
FAQ: add a set of rows
When a row is added to a table, add a set of rows to another table. Try the sample app! This example uses thre...
Show Hide (Toggle) Icon Overlay
This thread is refering to my own previous post of ; - Collapsible Icons overlay Feature Requests I wish to ha...
Expand/Collapse Button Groups
As an app grows in functionality, action buttons can proliferate in some tables' detail views. Here's a techni...
Barcode Scanning Check-In Station
A popular scenario for using the barcode scanner is to check-in people (visitors, guests, students, etc.). A s...
Trigger Appsheet Actions from Android Phone Homescreen Shortcuts and show response as toast & more..
Hi all,I came across this beautiful app HTTP Shortcuts by Roland. I must say its an amazingly useful app. I am...
API GET using Google Sheets function
As is known, AppSheet still doesn't have its own feature or function to make API calls in order to return cont...
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...
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...
