Special characters in PDF Workflow Template
I want to share some testing how special characters and emojis will look in PDF using Google Doc template. It ...
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
Use of SHIFT+MOUSE SCROLL To navigate horizontal
There are ways to navigate from left to right in the editor columns view: using the horizontal scroll bar. usi...
Expense Management
1. App Purpose? Track business expenses 2. Unique Features? Protected view for a single specified user to appr...
App use consent (privacy and compliance) in other languages
It’s not possbile to translate the message, the users see when they open an App first time. App use consent --...
Pick a random row from a table
To pick a random row of data from a table, the ANY() function will not suffice. Here’s a simple pattern to do ...
Table View - Grouping - How to close the listed items even we have single grouping criteria
Tips for table view grouping. I’m not perfectly sure when we lost the function, which was available before. It...
Reports and UserEmail()
Not come across this before so I thought I’d share it. When a Report runs and it’s set to ForEachRowInTable, a...
Gantt Chart with Awesome Table
Further to previous post, I pushed functionality to visualize the Appsheet table data, where we have start/end...
Sample App : Child table with multiple parents. Show different inline views for each parent
Here is a common scenario, where you may have 2 main data tables, then a single “join” table that is a child o...
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...
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...
