How to Prevent Duplicate Records
A very common type of validation you’ll want to add to your app is the ability to restrict people from enterin...
Forum Posts
When to use [_thisrow]
A very common question, here’s a short video in an attempt to answer this question. (I’m not satisfied with th...
Target Workday Calculator
Hello, I made this calculator to answer a requirement in an app of mine. I'd like to share it since I think it...
Google Developer Expert Office Hours
Hey AppSheet Community!My name is Landan Quartemont. I am a recent addition to the Google Developer Expert Pro...
How to apply a custom file name to multiple images uploaded in the app
The goal User provides some information in the app User uploads a photo AppSheet applies some logic to create ...
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...
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...
FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()
Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW...
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...
ChatGPT prompt: Prettify this
If you have a long expression that you're having trouble making sense of because it isn't properly formatted, ...
Part 3: Pixel perfect reports with Skia (AppSheet's PDF generator)
Well, it's about time, isn't it? Some months ago I told you I'd make a final part 3 talking abour tips to get...
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...
How to generate direct image URLs
TEXT([Image]) Put the express in a virtual column with “URL” type. If you need to store the link itself, you m...
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...
How to set a default value where original entry is null?
In this use case, I have a pre-populated data source which includes "null" or blank columns intended for later...
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...
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 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...
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...
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...
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" ...
Using INPUT() to update another table using a value from this row
Update regarding new syntax.I have not had time to update the images and text in this post to reflect the new ...
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...
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...
SAMPLE APP: Font Awesome Icon Library
AppSheet uses icons from Font Awesome for format rules, actions, views, etc. But these images aren’t available...
Guardar varias imagenes en un solo archivo
Buen día es posible guardar varias imágenes o documentos en un solo campo o registro?? que se necesita hacer g...
Decimal to base 36
Good morning,I was trying to generate a sequence of 36 base number for my purchase orders and came up with thi...
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...