Generate a website from your app
Based upon some messing around with html templates as well as fully understanding the requirements for Start e...
Forum Posts
[BEST PRACTICES] Updating Apps With Offline Users
How can I manage updating an AppSheet app that's deployed if I've got offline users? How can I make sure that ...
Tip to ALWAYS AUTOMATICALLY include The LATEST UPDATED Google Sheet Charts in Email PDF Report
We always desire to add the charts with the latest updated data from the app in the email PDF reports created ...
Viewing URL from Google Sheets as Image – A Tip
I stumbled across this in the last couple of days. I was having a problem displaying a URL from Google Sheets ...
Identifying and removing invalid filename characters
I don't find anywhere in the forum or AppSheet reference documentation a clear, comprehensive list of invalid ...
Do While Loop using Bots
You can create a simple Do While loop using Bots. I made a public sample of parts of my current app so you can...
Copy parent along with various children and grand children
Dear Community, A lot have been done about duplicating records, for use cases such as Quotes and invoices for ...
Generate Google Doc output
Several excellent posts on these forums around the subject of Google AppScript integration with appsheet. Ther...
SQL Views. What you can and can't do with them in Appsheet
CAN load any view in as a read-only table.CAN edit values in a view based on a single table (as long as that b...
Click Table View row item, but do nothing (not open the detail view)
Desktop view (Text box) Questions In that post I describe a “hack” of a solution using the confirmation popup ...
Copy Row along with child records
It should have been recognized that the coping row including the child table/rows are currently not supported ...
Appsheet app and twillo chatbot
There is an example how to link up between appsheet app and twillo chatbot. ( in order to call the spreadsheet...
Workflow pagination, headers and footers
Hey team, As of now, AppSheet does not officially support pagination for workflow pdf reports. This means that...
Doubles the number of cells in Sheet.🤩
Hi everyone,The maximum number of cells in Google Sheet will be extended from 5 million to 10 million.This is ...
Get app user's real local time offset
Hello,This is a very very useful, simple and accurate method to determine, the current offset of the user's de...
How close is your spreadsheet to the 5m cell Google Sheet limit?
Google Sheet allows you to have 5 Million Cells. This Add On shows you how many Cells your Sheet has. It even ...
2-Factor Authentication with AppSheet (a.k.a. 2FA)
Hello everyone, Here is a quick demo and a public sample app on how 2FA can ‘in a way’ be utilized with an App...
Enum ordering - a lesson learnt
After several hours of staring at this, taking the dog out for a walk to clear my head, and coming back to it,...
Google AdminDirectory list all users data with thumbnail (ADVANCED!)
I finally managed to do something I've wanted to do for a while:Get a list of all our google domain users data...
How to easily execute arbitrary, dynamic js code on your AppSheet data at runtime
Considerations:This is not a js tutorial. This is just to present the idea as briefly as possible. In future, ...
SAVE a TON of SYNC time WHEN CREATING MULTIPLE ROWS (From: 120sec to only 5sec with ONE SINGLE TIP)
Guys, Im so happy right now, I just drop a sync time from 120sec to less than 5sec on automation (Actually 120...
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(...
Spreadsheet formatting tips
The format of a cell in a spreadsheet used as a data source for an app can affect how AppSheet uses the cell’s...
Toggle Button 1) Toggle btw 2 values 2) Toggle to multiple values and back to 1st one
This is Enum data type, but always present single option. Set this filed as quickly editable on detail view. I...
Feature: Capture Photos
Need to capture photos in your app? Receiving an error? Give the following a try: What is photo capturing? Pho...
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...
Quick Referenceable AppSheet Guides [Video]
If you are looking for quick referenceable guides to help with your AppSheet Development. Watch our AppSheet B...
Auto Refresh / Automatic Update
Under Behavior > Offline/Sync we can enable Automatic updates. If you want to update the App more often, you c...
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...