1.860 / 5.000 I WANT TO CREATE A PRINTING TEMPLATE FOR A LIST IN GOOGLE DOCS OF A LIST OF MEMBERS
I WANT TO CREATE A PRINTING TEMPLATE FOR A LIST IN GOOGLE DOCS OF A LIST OF MEMBERS - CANDIDATES FOR MINISTERI...
Forum Posts
Serial Numbers, If You Must
Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two ...
Serial/Secuential Numbers
Create SERIAL NUMBERS with appsheet it's possible!When a friend @jaichith ask me for help with this situation....
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...
Custom Row Number to generate sequential number , using spreadsheet function
Sequential number is not officially supported with AppSheet, but this easy tricks could help some particular b...
Creating Google Maps Plus Codes from Lat Long value in AppSheet
Hello Everyone, I haven't shared any tips&tricks for a very long time in AppSheet Community, so here is a bran...
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 ...
Playing around with EnumList
I just placed an app to my portfolio. https://www.appsheet.com/samples/Sample-App?appGuidString=0f0936ef-60ba-...
ChatGPT and AppSheet for Beginners, Building, Troubleshooting, Expressions, and Erros.
I'm sure this won't make Google happy, but I built a GPT called AppSheet Helper for any beginners who might ne...
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 truly get "Last Month"
In the article for the MONTH() expression, it states you can use MONTH(TODAY())-1 to get the integer value for...
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...
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...
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...
Open Google Maps or Waze Direction Action Button
If anyone would like to create a Google Maps and Waze direction action button, You may do it using, following ...
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...
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...
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, ...
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...
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...
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...