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
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 ...
Create clickable links to images in Google sheet
Summary This post describes how to save a clickable link in a Google sheet that will open an image captured th...
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...
Microsoft Teams - With Appsheet Embedded as Tab
Pretty neat, in MS Teams you can simply add a tab, choose website, and then drop in the Appsheet browser link…...
🥇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 ...
Next ’22 AppSheet session playlist
I have created a playlist of AppSheet sessions scheduled for Google Next '22.Since it's a festival called Next...
Tip to ALWAYS AUTOMATICALLY include The LATEST UPDATED Google Sheet Charts in Email PDF Report
We always desire to add the charts with the latest updated data from the app in the email PDF reports created ...
New doc: EOWEEK()
For the recently-added function: help.appsheet.com EOWEEK() Date of last day of a week from Date or DateTime
Viewing URL from Google Sheets as Image – A Tip
I stumbled across this in the last couple of days. I was having a problem displaying a URL from Google Sheets ...
Row Selected Action: LINKTOROW() vs **auto**
In Deck, Table, Gallery we can select the Row Selected Event Action.In Card we can select the On Click Action....
"Run"ing a Scheduled Bot from the editor, with user-dependent Security Filters
I just discovered, or perhaps re-discovered after forgetting, that when you manually "Run" a Scheduled Bot fro...
Identifying and removing invalid filename characters
I don't find anywhere in the forum or AppSheet reference documentation a clear, comprehensive list of invalid ...
Do While Loop using Bots
You can create a simple Do While loop using Bots. I made a public sample of parts of my current app so you can...
