[Updated] Supabase mets AppSheet
Most of you rely on Spreadsheets to feed AppSheet apps with data, the heart of any AppSheet app. Now, at some ...
Forum Posts
FAQ: Add a number of rows
Add an arbitrary number of rows to a table based on a column value of type Number. Try the sample app! For thi...
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...
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...
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 ...
FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()
Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW...
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...
Using SVG "interface" images
This tip is a workaround to solve a problem for which a new feature has been requested. The feature requests (...
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...
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...
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...
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...
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...
FAQ: add row per value in EnumList
Add one row per value in an EnumList column list. Try the sample app! For this example, the table from which t...
How to delete blank rows in Google Sheets
I have an app that uses parent and child records with IsPartOf turned on. When I delete a parent record, it on...
GIF file - now animation is preserved
This may not be a tips and tricks, but to share what we found. When we uploaded GIF file image through AppShee...
Quick Update System - How to update records in your app with a push of a button
“How can I update a parent record when a child record is changed?”“How can I mark all the line items in an inv...
Column formula value missing after action
Hi All, Face with some challenge with column formula and action. See belowDriver value missing from source aft...
Add any number of rows from any row within a table
Definitely a frequently-asked question: how do I add some number of rows to a table automatically? It’s possib...
Efficient AppSheet Trick: Speed Up Column Ordering
Hello everyone, today I'd like to share a helpful trick for speeding up your use of AppSheet.One thing I reall...
Use Yes/No instead of Enum with two buttons
Here's a view where I stopped using an Enum column in favor of a Yes/No column: It looks like an Enum button d...
Apps Script - Google Groups - List all groups and users + Add/Remove User
Hi guys, here is my lastest script. It adds/removes users from google groups. Feel free to use it as you wish....
Rows Total / sub Total
“Grouping” function of Appsheet will display the sum, average etc by the designated group / set of rows by def...
Digitizing Shipping Documents with Google Docs
AppSheet Workflows can be used to automatically send notifications, change data, or generate documents. Below ...
Difference between [_THISROW].[_THIS] and [_THIS] in Form View
I found this recently while filling a form in Appsheet. Thought of sharing it with the community.[_THISROW].[_...
Feature: Video Embedding
Are you in need of embedding videos in your app? Receiving an error? Give the following a try: What is video e...
Use Enum/EnumList (Base Type: REF) to De-Reference Data & Reduce Reverse-Reference Clutter
Hey Everyone. We all know the power of references inside an AppSheet app, but there’s also some overhead assoc...
Show
Olá, pessoal.Eu não sei se isso já foi publicado no fórum, mas é um recurso de produtividade para inserção de ...