Adjust column width in table views
Check out the below tip from Kirk_Masden. That’s better than mine. (I posted this topic because I didn’t see h...
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
Using a PDF for your form
So I ran into a problem a few months ago, and I’ve been fighting with it ever since. Then a meteor fell out of...
Auto re-open only a number of times
Let’s say you want the user to add only 3 images. But you also want to speed it up using auto re-open in your ...
Public Applications
Publicly accessible applications (that don’t contain sensitive data and don’t require user sign-in) can be cre...
Google Calendar: Get rid of Hangouts & Meet
When you use Google Calendar as a data source and add an entry via your AppSheet App, a Google Hangouts / Meet...
CSV Export returns blank value for invalid columns
This isn’t anywhere in the documentation, so I thought I would report it for anyone who runs into a similar is...
Manupulating Array value (List in Appsheet) using LOOP actions
Being inspired by @steve s LOOP actions tips and tricks, to add arbitrary number of childs records, I came up ...
Key column: Let's scam that rascal!
Had a little problem recently (10 minuts ago) with key columns. They ask you for a unique data, but though in ...
Login for external companies
Our clients, who I want to be able to have secure access our app, are solicitors from various firms. If I’ve u...
Listing column names and data types
Hi there, If you want to get the table schema including VC, what method do you use? I have copied the header r...
1) Imitated text button shaped action UI 2) To show your process (workflow) is in process now) by visually appealing way
One of the most desired features I have been waiting to be introduced by Appsheet is to get the button shaped ...
Randomly change background image
Lorem Picsum Lorem Picsum Lorem Ipsum... but for photos I found this site. Get the url like “https://picsum.ph...
[_THISROW_BEFORE] / [_THISROW_AFTER] Template Generator
AppSheet can automatically create email templates with just a single click, and all the column names are added...
Loading Screen Animations
In the UX > Brand section of the editor, the loading screen of each can be customized so that whenever the app...
Double Dereference workaround without virtual columns
Hey Guys, Not sure if anyone has looked into this yet but I recently used a workaround for accessing a double ...
Show overlay actions in dashboards
I just realized that we have a new feature that is just awesome. We now can use the overlay Actions in Dashboa...
Sending Email with PDF from Salesforce Update using Automation
Hi there, I don’t know if I can call this a Tips, but I will share what I want to achieve with GA’d Automation...
Now what was the name of that action . . .?
If you have lots of actions in your app it can be hard to remember what you called each one. Here’s a little t...
Rendering of HTML in gmail client
I had a go at trying to beautify emails sent out from my app and I discovered that most of the formatting I ha...
Set Initial Value of TIME column to nearest 15 minute interval
This one took me a minute to figure out so I figured I’d share here to save someone else the time. I needed a ...
IMAGE EDITING! Rotate, Crop, Resize, Mirror, Etc- Using FileStack & URL Parameters
Disclaimer: Free signup at https://www.filestack.com/ is required in order for each developer to have their ow...
Time average
I give you my expression to calcutate an average time on several days. the [time] column has a duration type. ...
Feature: Calendar View
Are you in need of a calendar in your app? Receiving an error? Give the following a try: Where does the calend...
Display a "Waiting for sync . . ." message
AppSheet allows us to combine the computing power of Google Sheets and other spreadsheets with that of AppShee...
Auto-Fill a Sheet with All Table/Column Names from Your App
Have you ever wanted a list of all Tables and Column Names in your app, displayed IN your app (not just in the...
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...
How to do an [April Fool's Gag] in your app
It just occurred to me that April 1st is coming up! Something must be done in commemoration (^_^) Here’s a sim...
References between tables - (sample app)
(This tutorial product tour has been retired, but the app used for it is available here to reference: Facility...
Add rows to another table WITH parameterized input
This pattern comes up more and more, so I thought I’d build a simple example. We already know that you can cop...
Dynamically Create URL to Google Image Search Results Based on Column Values
I was looking for an easy way to help users find images to upload for one of my apps and found THIS BLOG that ...
