META POST: URL Parameters for other Google Services!
I just saw a great tip about creating Google Voice Links by @Peter and it got me thinking; It’s time for anoth...
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
Show PDF Thumbnails when using Folder as a Table
We can add a Google Drive folder as a data source. See this Post. I thought it would be cool to have the PDF’s...
Feature: Capture Photos
Need to capture photos in your app? Receiving an error? Give the following a try: What is photo capturing? Pho...
Publish a sample app without putting it on your portfolio page
I would like to avoid clutter on my portfolio page. Currently, I have just one app on it – one that I have bee...
Did you know....that there IS a pop-up Form available using the INPUT() function?
Based on a post by @Joachim_Mund … Help needed: in an action, how to ask the user to enter some text via input...
Features: Bulk Select vs. Data: execute an action on a set of rows
In this weeks Feature Friday we released the top features of 2019. Two of the items included are often assumed...
Make the AppSheet folder easy to find
A very simple tips. Many of you may be using Google Drive with the default gray folder. However, we can make i...
SVG launch image
Here’s the right size for bg and logo, which has fit perfectly on all screen resolutions so far: drive.google....
Different Valid_If for Adds and Edits
I’m posting this here to help anyone with this problem but I’ll make a Feature Request about it. You have made...
Integromat: OCR, Push Notification, Geolocation, and more
I want to share a very cool web service to do things you cannot do with AppSheet. Here is a litte Introduce. H...
Quick editor performance hack, remove the emulator
I’m sure many of you have noticed that the emulator tries to dynamically change as you make changes to views a...
Animated gifs
This is not an original tip – just recycling a good idea shared with us by @tsuji_koichi: Feature: Video Embed...
Chained Dereference Expressions e.g. [refid].[manager].[email address]
Double references work now! Is this new? This is great for security filters! Edited to add the correct termino...
How to create an automated gSheet backup within your app
Dear valuable members of the AppSheet Community, I would like to share and explain, how it’s possible to creat...
Feature: Gallery View
Are you in need of a gallery view in your app? Receiving an error? Give the following a try: What is a gallery...
Quick Referenceable AppSheet Guides [Video]
If you are looking for quick referenceable guides to help with your AppSheet Development. Watch our AppSheet B...
URL encoding issue workaround
Hope this tip may be of some help! I was having an issue when generating QR Codes through external services li...
How to create a Bulleted List from an EnumList
Have you ever wanted to show data in your app in bullets? Maybe you thought about using an Enumlist… …but how ...
Maintaining Unique Entries
To prevent a user entering a duplicate value (e.g. to maintain a unique list) I’ve be using this Valid If expr...
Automatically create parent and child records one click
I was running into a problem where I wanted my users to be able to add multiple days off for employees by just...
Auto Refresh / Automatic Update
Under Behavior > Offline/Sync we can enable Automatic updates. If you want to update the App more often, you c...
Making an app Public in your portfolio
If you want to make an App public in your portfolio. 1 Open the App 2 > Manage 3> Teamwork 4> Make this app a ...
Card view as alterntive to Deck View type
Deck view currently shows only single line of text strings when we push texts to primary or secondary. In case...
Appsheet style "State Management System" to hold the value of "variable" and consume for actions and worflow
These tips and tricks could be reused in various places and purposes within Appsheet by twisting a trick a bit...
Google Calendar to display events for longer periods than default set
Im not sure if this is officially documented or mentioned before in this community place, but I noticed that w...
Add event to Google Calendar not from iCal Files, but from URLs
AppSheet is natively support to generate the iCal files out of BOT jobs to sent the ical file to recipient to ...
Make sure images load in advance
AppSheet is very good about loading images in advance so that they appear immediately when needed. I found, ho...
How to filtering Ref values with a virtual column
Hi! This work well in some kind of status follow up. This is a helpful tip for those that needs to filter REF ...
Put format rule conditions in virtual columns
Through trial and error, I’ve come to the conclusion that it’s often better to put format rule conditions in v...
