Made my clever form autofill also work during edits
I originally wrote this to ask how to make the solution work during edits but in the process of explaining I f...
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
Virtual Column_Valid, Expired,Expiring
Hi everyoneI ask myself how to do this and if it is the best solution. In a virtual column I would like you to...
Express DURATION values in Days (ie in automation Wait/Pause)
Sharing this nugget because I can't find it referenced anywhere in AppSheet Help or this Community and thought...
App Versions History Logging
Thought of sharing something that i am following while editing the apps.Screen Recording
ChatGPT prompt: Prettify this
If you have a long expression that you're having trouble making sense of because it isn't properly formatted, ...
Can't reset column after row copy? Try this one
A workaround is to create a column with a number type ex: [updater] then make an invisible action with this fo...
Manage app user access with AWS Cognito and Google Apps Script
If you're working to Control user access using AWS Cognito in your apps, that can be greatly facilitated by ut...
Google Next '24
Google Next '24 will be held next month. https://cloud.withgoogle.com/next/ AppSheet sessions have also been a...
AppSheet + Google Cloud DocAI form processing template
Hi everyone, I did some testing with AppSheet and connecting via API to DocumentAI services, for example for f...
Dashboards with dynamic text overlay on SVG images
This effort is fully inspired by various pioneering techie tips shared by @Jonathon in on SVGs and then those ...
Mobile app "cannot be run from the currently installed app"
I had a situation where my app worked correctly in browser, but failed to start in Appsheet on either iOS or A...
Create and use virtual "show" columns for text, URL's, video etc
This is a simple series of steps to create virtual “show” -type columns. There’s some posts on this from awhil...
Hot-Linking References | How To Move Records With A Push Button
What do I do if I need to move a bunch of records to the same parent reference - but not all at once?What if I...
FAQ: How do I do something automatically the first time someone uses my app?
How do I setup/register a new app user automatically? How can I do something automatically the first time a us...
Use Google Cloud Generative AI Image Models in AppSheet (as seen in Next 23 Developer Keynote)
Hi all, Here is a simple guide to use Google Cloud Visual Question Answering Vertex AI models in AppSheet. Unt...
Two ways to shorten URL in-app
Dear Appsheet community,Sometimes you want to shorten URLs, which is soooooo useful if you are generating QR C...
Using QuickChart in your apps
@tsuji_koichi has shared several useful posts about how to use QuickChart (https://quickchart.io) to augment A...
DIM (Dynamic Indicator Maker) SVG Images
DIM (Dynamic Indicator Maker) Hey everyone! I created a new tool that creates fancy SVG based indicators that ...
Using INPUT() for "just in time" calculation and display
This post is a follow-up to "Using INPUT() to update another table using a value from this row":https://www.go...
Unusual behaviour with Unique IDs
Hey All!Something I discovered a little while ago that may be of interest to someone at some point.You might a...
Batch Registration of AppSheet IPs to Cloud SQL Connection
When using Cloud SQL, we need to register the AppSheet server IP to the Connection.There are 45 of them! help....
Final value how initial value
Good day, I'm trying to make the final value of the "final balance" column the suggested the initial balance" ...
Get data from "simple" APIs by using "Return Value" option in AppSheet
This tip is just to share a working example of "receiving" or getting data by using "GET" verb from an API usi...
CRAZY CALENDAR HACK: Add Events Directly to a Timeslot, Pre-Fill Date/Time
Hold on to your apps, this one is gonna get a little weird. The default calendar view doesn’t provide a way to...
How to solve server cache issue?
How can I resolve cache-related issues that are affecting the performance and user experience of my "apktoly" ...
GDE Office Hours Recap [Scaling AppSheet Apps]
Hey Folks,As I mentioned a couple weeks ago, I just kicked off a weekly office hours at 11 AM CST on Wednesday...
New AppSheet App for Enhanced Gmail Management and AI Draft Replies
Hey HEY AppSheet Community! I'm thrilled to share something I've been working on that I believe will revolutio...
Dynamic Progress Bar with SVG - Sample App
This post is just an inspiration from Dynamic SVG graphics by @Jonathon DIM (Dynamic Indicator Maker) by @Rich...
How to ROUND to whatever interval you want.
ROUND only rounds to the "ones" decimal place.Or to describe it another way, it rounds the "tenths" spot up or...
FAQ: Rounding DateTime, Duration, and Time values
Round DateTime value to nearest 5 minutes Round Duration value to nearest 5 minutes Round Time value to neares...
| User | Likes Count |
|---|---|
| 26 | |
| 20 | |
| 12 | |
| 8 | |
| 8 |
