Appsheet Editor ; Dropdown selection with keyboard
When we are on the dropdown selection, such as data type etc, hit the first character, such as a, c, i, etc on...
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
Colorful Avatar - Initials Placeholder Profile Image
All, wanted to share this simple way to bring an immersive experience to your app users without placing too ma...
Interactive Dashboard
When building Dashboards, make sure you try enabling ‘Interactive’ mode - if your views are built from similar...
INTRODUCING: Script Nuggets!
SCRIPT NUGGETS Script Editor and Save at room temperature for 35 milliseconds. Ingredient Purpose clearSheetFo...
Quickly referencing records together from within a dashboard. Sample App
Wasn’t very sure how to describe this one, see GIF below. This is functionality that I just created similarly ...
Sharing text AND IMAGES through Google sheets
If you are storing the data for your app in Google sheets, you are probably aware that you can, if you choose ...
How to create a [Cancel Button] for quick-edits
Being able to modify a column’s value outside of the form is extremely helpful in speeding up certain data ent...
Convert (Distance ÷ Speed) into Duration
concatenate( right("000" & floor([Time_Remaining]), 3), ":", right("00" & number(([Time_Remaining] - floor([Ti...
Delete app AND files
Because it is a well-designed no-code platform, AppSheet is relatively easy to learn. If you’re like me, thoug...
Working with table view (Q&A)
In this post I’d like to collate some information about how to work with table view. First of all, here’s what...
Animated gif issue and workaround
This tip is an extension of my earlier tip on how to add animated gifs to your apps: Animated gifs Tips & Tric...
Add comments inside SVG in formula
Just figured out you can put comments inside data:image… SVGs. Just be sure to add the comments between “>” an...
TinyPNG – Compress PNG images while preserving transparency
Found this awesome little site today. The compression is fantastic. For most of my pngs it compressed about 60...
Display a random error message when invalid value is entered
Invalid Error Messages USUALLY tell the user Why the data is wrong, or suggest a correct input. This Tip is mo...
Automatic GPS Location Logging
Including Initial Values and ensuring column values cannot be editable is an effective way to securely log dat...
SAMPLE APP (Update): Group any table view by different columns without leaving the view
Update to US States Sample App Added in line actions to change the current view’s grouping, without leaving th...
SAMPLE APP: Countdown Timer Using Youtube Video & URL Parameters for Start Time
There have been a lot of requests for a built-in timer/ stopwatch feature: Timers cant wait I have a task mana...
Barcode Generating Api
hey everyone Many times I am trying to use barcode API before this, I am using QR code. but somehow we also ne...
Randomize sort order every 3 hours
I’m building an educational app to help students memorize vocabulary. For this app, I’d like the “cards” to be...
Introducing A New Resource: In-App Guides
Hey everyone. Over the past few months I’ve been working on building a system to deliver a new type of resourc...
Quick Tips : Reset Grouping on list type view
Once the user select the header/column name on table view, for example, then the list is sorted by asc/dec, bu...
Map Point Highlighted
By Using the KML Map Layer, I was able to highlight the Map Point. This may be useful in cases where the map d...
Create Custom Home View or Landing Page
Appsheet “About” page and view is currently not really “customisable” for the moment, but some may want to gen...
Simple Captcha!
Hi everyone! I have noticed that captcha feature is still not available in appsheet so i created a simple app ...
Revisiting 'Converting text to unique lists for use as tags'
Over a year ago I wrote a ‘Tips & Tricks’ post about converting text to unique lists that can be used as tags ...
Device Independent TimeCapture
At times we find that the app needs to capture the time input by the user ( typically timesheet apps) but sinc...
Automatically show buttons or views AFTER updates applied
I’m sure others already know about this but if it has been posted about I didn’t find it. Even so, it is proba...
Saving a Workflow PDF in any folder in Google Drive
We can define the Folder, where a PDF is saved. As described here (under " Folder Name"), this folder is alway...
Dynamic Icons via Google Image Chart
https://developers.google.com/chart/infographics/docs/dynamic_icons#frame_style_constants With those Dynamic I...
