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 ...
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
Another text overlay display on an image
As @tsuji_koichi already published, I think the trick of displaying text overlay on an image is very popular. ...
Convenient column Add in View and Slice
Hi everyone,Adding columns using Column order, etc., is problematic when adding large numbers of columns becau...
Google Groups management through AppSheet
I use google groups to manage external users access to my website. The website allows those users to request t...
Solved : - Google Script and Appsheet integration
Hi friends, recently I was stuck with integrating Google Script (operating on my spreadsheet) and AppSheet. I ...
How to get External Image url on to table at time of first save
I while back I wrote my first Appsheets which needed to use the external image path for imported images.My use...
Managing CRUD of data tables with AppSheet
I was troubled.What is the best way to give user permissions to each table.And I was able to do it with a very...
Let's have web conference on Appsheet!
I just created tv conference module within Appsheet to provide additional experiences to my clients and App us...
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...
Change view data source without loosing columns selection
Case: you need to add a row filter condition to a view built with direct read to a table.Problem: if you chang...
Formation en français
Bonjour à tous, Pour ceux qui commencent sur Appsheet, voici une formation en français ! Fiche d'application :...
Pseudo Side Navigation Application
Hi, my name is Hayato Okutani.This time, I couldn't wait to make a sidenav, so I made this piece.Please take a...
Create risk analysis matrix or any other matrix grid with card views
Some apps have risks or some such other data that can be better shown in a matrix or grid format. An example p...
Scheduled chart report via Telegram Bot API and Quickchart API
What's better than an API service? Well, two of them unitedLately I've playing with the Quickchart API. It's a...
Using list expressions to parse a small set of data stored as a single text string
I made a little template app to show how I am parsing data to give users feedback regarding data they have typ...
Workflow example added to appsheet help system
Hello all, We’ve added a walk-through help article and companion app to showcase workflow approval processes, ...
Step by step, sending a notification to the telegram group with the telegram bot (with Action)
Creating a Telegram Robot Type @Botfather in Telegram search. Botfather is considered the father of all robots...
User Customizable Menus and Navigation Bar
Sample App: Customizable Menus/Navigation If your app has many different views/sections or your app’s home scr...
Spreadsheet to allow for AppSheet Expression testing
One of the frustrations I have with AppSheet is that when I'm writing an expression, I can not test it unless ...
Math
Hi
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...
How to add a checkbox to a table view
The question of how to add a checkbox to a table view has come up before: Quick edit check box on table view? ...
Host KML files on Google Drive
If you want to use a KML map layer as described here you can host the kml file on Google Drive. Just right-cli...
Texto explicativo/comentarios en formulación
Hola!!! ¿Es posible escribir texto en las formulas cuya única utilidad sea explicar la estructura, pero que no...
Fórmula para dividir
Hola, tengo que dividir dos valores y multiplicarlo por 100. Los valores para dividir estan en columnas virtua...
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, ...
Resource planner - Recurring events - Timeline independent (Work in progress)
This is a live document that will expand over time. For now it will most likely contain some faults! I would a...
Alternatives to LOOKUP(MAX(SELECT(
Continuing the discussion from New INPUT() function — binding dynamic inputs to a data change action: New INPU...
