Google Sheets UniqueId Apps Script
Here’s a tip on creating unique ID’s directly in Google sheets with Apps script: The code works by scanning yo...
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
Add any number of rows from any row within a table
Definitely a frequently-asked question: how do I add some number of rows to a table automatically? It’s possib...
Send emails
Greetings i have data entry App, which had appointments dates etc, I have a column named "Assigned To" i would...
Searching the whole App
If you like to know where in the App you are using a column, you can use the App Documentation. In this you ca...
Install MySQL on Always Free GCE and use it from AppSheet
For production, we should use Cloud SQL. However, if we just want to verify the integration with MySQL, we may...
Here() = “0.000000, 0.000000”
Problem: On my Android phone the expression HERE() was “0.000000, 0.000000”. Even though in the Android settin...
How to start using an app on your phone
This post is for beginners.The AppSheet platform lets you make an app in a computer browser. The interface loo...
Efficient AppSheet Trick: Speed Up Column Ordering
Hello everyone, today I'd like to share a helpful trick for speeding up your use of AppSheet.One thing I reall...
Learn how to open a file generated in Appsheet
How can I open a file that I created in my automation using appsheet only?I see that some new users are having...
Use Yes/No instead of Enum with two buttons
Here's a view where I stopped using an Enum column in favor of a Yes/No column: It looks like an Enum button d...
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....
Drawing: Control size by initial value
A Drawing field might look too big on mobile devices. You can control the size by using an initial value like:...
Dropdown List Exclutive
I’m trying to make a dependent dropdown list, exclude items when selected for other fields (other dropdowns). ...
Table with heat map
Hi, I'm creating a table where I need to represent the counta distinct (because is text) of a dimension and th...
Cálculo digito verificador RUT (DNI) Chile / Calculation of verification digit RUT (DNI) Chile
soy nuevo en AppSheet, quisiera dejar mi primer aporte a la comunidad, como resolver el cálculo y la verificac...
Rows Total / sub Total
“Grouping” function of Appsheet will display the sum, average etc by the designated group / set of rows by def...
Youtube embed link made easy with Appscript
My needWell, It turned out that I needed one app where I could add youtube links and watch them inside the App...
Export to Google Slides from AppSheet
Building presentations can be a time consuming process. There are many cases where the slides we need are simp...
Sample App: Multiple (and optional) dependent dropdown filters
I created a sample app to demonstrate setting up multiple search filters to narrow down the possibilities in a...
ChatGPT prompt: Repeating pattern in long expression
Here's a way of using ChatGPT that doesn't require much "intelligence" (even ChatGPT 3.5 can do it easily) but...
ChatGPT prompt: Correcting open and closed parentheses issue
Here's how I got help with an expression that had mismatched open and closed parentheses:https://chat.openai.c...
Appsheet assisted with OpenAI ChatGPT
Hi everyone,I'd like to use this post to share information and discuss the possibilities of using ChatGPT with...
Digitizing Shipping Documents with Google Docs
AppSheet Workflows can be used to automatically send notifications, change data, or generate documents. Below ...
How to Display 24Hrs Format
Hi all, As many know, Appsheet do not have support for 24Hr formats. In the forum there are many work arounds,...
How to control the Action Name and the Confirmation Button
Usually the Confirmation Button is the same as the Action Name or the Action’s Display name. By grouping the A...
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...
Email validation
If you use column type email, the only validation seems to be: It has to contain exactly one "@".TestTest.com ...
How To Show a Custom Valid If Error Message
You’ve been working long and hard to get your Valid If formula correct, and finally it’s doing what it’s suppo...
Make the fields only editable through the action"
Have testing with try and error to find out a way to get the required functionality to “make the fields only e...
Progress Bar Chart ; new static image chart type in place!
Some people may say this is not bit deal, but for me, it is big! I introduced to the community before how to c...
