Open map on current location HERE() and adjust zoom level
There is no way to jump to the current location in a map, like we have in google maps. I found a workaround, u...
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
Hide the Address / LatLong / XY row in a maps's deck view
When we click on a pin in a map view on a small screen, the deck view opens up. To change what you see on this...
WhatsApp for Communication
Hi, Try this when you want your client to use Whatsapp for the communications. Objective: “Button” for WhatsAp...
Creating a calendar of events in Appsheet that puts them on Google Calendars automatically
Hello all. Often I come here to ask questions, but today I thought I'd share something I came up with that may...
Fix for expression giving 0% or missing decimal part
Trying to divide two numbers to get a percentage but always getting 0? Trying to divide two numbers but losing...
Video Files on Appsheet - Upload file from App then view on App (No third party services)
To film video natively on the app and save the video files to the cloud storage straight-away is one of the aw...
Do you want to print something from Appsheet app? Then have a look
I wonder how Appsheet user currently printing out docs from the app, but basically we send the email to the lo...
In-app purchases
The community has periodic questions, and sometimes detailed discussions with links to many other resources, r...
Integrate AppSheet with Google Gemini AI API using Google Apps Script
Multiple AI models are evolving. In the Google family, there are mainly "Gemini" and "Vertex" AI models. @Stef...
Bulk Select Multiselect Select All
We can do Bulk Select in Table, Deck and Gallery View. We can even navigate to a view that’s already in Bulk S...
Building a work around to Automation: A framework for executing long-running scripts
Hey AppSheet Community, I recently ran into a frustrating issue with AppSheet's "Call a Script" feature, where...
Copy parent record together with child records ; Action Only, No API, No workflow
After introducing a trick how to copy the related child records along with parent record through the post of C...
Issue or bug with link to generated files on google drive (solved)
On the way create an action to an exported file on google drive I found an issue, maybe a bug.I made this setu...
_THISROW_BEFORE is providing current value
HI,I have tried [_THISROW_BEFORE].[column]It is not working as expected. Eg:Column: StatusStep1: Status = Draf...
Rows Total / sub Total
“Grouping” function of Appsheet will display the sum, average etc by the designated group / set of rows by def...
start menu
Hello friendsI present to those who are just starting out in the appsheet some design possibilities for the st...
Dynamically Create X Number of Child Records from Parent EnumList with Only 2 Actions!
Normally a parent record is created first (e.g. Orders), then child records are added one at a time (e.g. Line...
How to comment your code or keep old expressions without executing them
I'm working on an old, large, undocumented, app that I've been asked to improve and evolve with some new funct...
Radial Gauge / "Meter" - Inline Dynamic Icon - How to create?
Dear community, On various occasions, we wish to have some sort of KPI so that the user can get the better exp...
How to download images and files in Appsheet
Is it possible to download a file or image from Appsheet?YES! I wanted to download the file or image with just...
Handy tip for pulling data from UsersTable/CurrentUsersSlice
I've been doing this to the point I consider it to be reliable.So many of you have express the need for global...
Change appearance of headings or "display names"
Currently, AppSheet does not allow us to use format rules to change the appearance of the headings in detail v...
How to control or rename uploaded files in a [file] column
(*NOTE: Only applicable for Google users (GSheet/GDrive))As you all know, when a file column is used in your a...
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...
automation didn't trigger
i have many process to modify the table, i create the action that trigger using other bot name is "MENU SOLD" ...
Reference Dereference doesnt work
Hi,i have the problem, that i cant work with referenced tables into the "autocompute" field.While testing my E...
Quick Sync and Security Filters expressions compatibility
You may have experienced using the Quick Sync feature and seeing it disabled when saving your changes in the a...
Google Sheets UniqueId Apps Script
Here’s a tip on creating unique ID’s directly in Google sheets with Apps script: The code works by scanning yo...
Action button "ish" texts or Text button "ish" button icon?
To put a little different taste and flavour to detail view, this can be additional UI and component as action ...
Slideshow mode in Detail views in Desktop
Hi,The slideshow mode fr Detail views does work in my preview Tablet and Mobile. Yet it doesn't work on deskto...
