APPS SCRIPT: Download Gmails to GSheet, using Gmail Filters/Labels
This Apps Script will monitor your Gmail for new emails that match a certain label, and: Add a New Row to GShe...
Forum Posts
Here() = “0.000000, 0.000000”
Problem: On my Android phone the expression HERE() was “0.000000, 0.000000”. Even though in the Android settin...
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....
Find names of inline actions
This post is no longer valid, in part because the interface no longer works in this way but more importantly b...
Delete app images or files in an app record from Google Drive itself when you delete the record from the app
There are many posts in the community about wanting to delete the image files also from the Google drive when ...
Discord server anyone?
Hey everyone. Awhile ago I put together a discord server with the intention of creating a hangout spot for app...
Non-English AppSheet Content
Hi All, Trying something a little different today. I know for many of you, English is not your first language ...
GEO-FENCING TRIGGERS: Send Webhooks to Add/Edit Rows or Trigger Actions Based on Location
Want to add a row or trigger an action when a user enters/exits a certain geographical area? App-creators can ...
Quickly and continuously take pictures on mobile phone
This is a well and broadly known tricks, to take photo on mobile device continuously with the least actions by...
Get the Google Drive File IDs automatically and manupulate for bits and pieces
Borrowing the complete code (Google App Script) from the web, like stackoverflow, such as stackoverflow.com Go...
How to use AppSheet with AutoCAD (or other CAD software)
Hello! I’ve been using AppSheet in an engineering company that needs to prepare documentation (Sheets) with lo...
Import Handwritten List App
Hi Everyone. I created a sample app that will capture a handwritten list and then import each item as a record...
Sample App - for those who are beginner to intermediate (Dashboard, Map, Chart etc)
Just created sample app for those who are new to Appsheet and/or on intermediate level to share some of the tr...
To manually build URL for sample apps
Recently, the changes could have been made and introduced by AppSheet to construct the URL to reach out to the...
Text Validation using List Subtraction and an EnumList of Allowed Values
Text validation in AppSheet can be a little challenging. There’s no RegEx, and you have to nest 26 SUBSTITUTE(...
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...
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...
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 ...
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...
Support support
AppSheet’s support interface has changed. I looked for an announcement of the change in this community but I e...
Enum / Enumlist base type ref improvement
I just noticed an improvement. In case we set the column type to Enum or Enumlist, with base type ref, we HAD ...
Keyboard shortcuts in browser
If you use an app in a browser, you have at least two keyboard shortcuts at your disposal: (I’m a Mac user. No...
WEEKNUM() Discrepancy | Depends on your Locale
While troubleshooting an issue with WEEKNUM(), I came across a curious fact that I thought I would share. The ...
Do you want to print something from Appsheet app? Then have a look
I wonder how Appsheet user currently printing out docs from the app, but basically we send the email to the lo...
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...
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...
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...
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...
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...
INTRODUCING: Script Nuggets!
SCRIPT NUGGETS Script Editor and Save at room temperature for 35 milliseconds. Ingredient Purpose clearSheetFo...