Manual Sorting (Move Items ↑↓ w/Buttons) || Bonus: Sequential Numbering
Hey everyoneThis has been on my list of things to do for awhile now, finally getting around to it. (^_^)In thi...
Forum Posts
New action: App update/Force sync
There are sometimes where the change the users are making through an action is so important that we need to ma...
Using a return value that is an array of objects to populate table
The return value of a call to an App Script returns an array of objects in the following format:[{"a":1,"b":2,...
OpenAI & AppSheet #2: Create Dynamic Starters for Continued Conversations in Your ChatGPT Interface
Hello AppSheet community! I'm excited to share the second video in my ongoing series that teaches you how to c...
ChatGPT in AppSheet | How to create a continued conversation with OpenAi in AppSheet
With the popularity of ChatGPT, you might find that it is often down due to server overload. If you're like me...
New "Table properties" option for GDoc template: "Pin header row(s)".
I just discovered a new feature. There is a new option in a table's properties in GDocs, called "Pin header ro...
Link to an external web site
This tip explains a couple of workarounds for problems that I hope AppSheet can address. So, here’s hoping thi...
Dynamically Create X Number of Child Records from Parent EnumList with Only 2 Actions!
Normally a parent record is created first (e.g. Orders), then child records are added one at a time (e.g. Line...
BOT Monitor - Monitor BOTs within App and get notified about BOT errors
This Tip is inspired from the post BOT Early Warning System by @1minManager and the help i received from @dbau...
Use 'Call a process' and 'Return values' steps in automations
The AppSheet Help documentation explaining the Call a process and Return values step types in automations is m...
Initiate calls from Google Voice
This is a simple one - initiate phone calls in Google Voice on your desktop or mobile device using the followi...
Delete child records when parent is deleted (alternative to "Is a part of?")
Child records are connected to the parent record via a column of type Ref.When you enable Is a part of?, all c...
FAQ: add a set of rows
When a row is added to a table, add a set of rows to another table. Try the sample app! This example uses thre...
Trigger Appsheet Actions from Android Phone Homescreen Shortcuts and show response as toast & more..
Hi all,I came across this beautiful app HTTP Shortcuts by Roland. I must say its an amazingly useful app. I am...
Video Files on Appsheet - Upload file from App then view on App (No third party services)
To film video natively on the app and save the video files to the cloud storage straight-away is one of the aw...
Integrar Google agenda e Google contatos com o Appsheet usando GAS
Integrar Google agenda e Google contatos com o Appsheet usando GASOlá a todosSeguem dois scripts do Google App...
Bypass Security Filter ; Mystery solved
It was my long running mystery, "how and when we use “Bypass Security Filter” in workflow settings, but now th...
Open map on current location HERE() and adjust zoom level
There is no way to jump to the current location in a map, like we have in google maps. I found a workaround, u...
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 ...
Sample App: Invoicing and Employee expenses, Report Generator
I made this Sample App as a playground for my Part 3 post (check the first reply) but it doesn't mean that you...
Clickable Image with Hyperlink in PDF
In Google Doc Template we cannot apply a Hyperlink to an Image. I mean - we can. But when you create a PDF wit...
Create clickable links to images in Google sheet
Summary This post describes how to save a clickable link in a Google sheet that will open an image captured th...
Add Events to the App-USER's Calendar Using Dynamic New-Draft Event Links
AppSheet can use a Google Calendar as a data source, but the app-owner is always the ‘Meeting Organizer’, or o...
Using Automation to (Mass Update Values) from One Table to Another - WITH THE PUSH OF A BUTTON
Use this "hack" to run an update action on a set of rows using Automation with the push of a buttonTLDRThe mai...
Generate a website from your app
Based upon some messing around with html templates as well as fully understanding the requirements for Start e...
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 ...
"Run"ing a Scheduled Bot from the editor, with user-dependent Security Filters
I just discovered, or perhaps re-discovered after forgetting, that when you manually "Run" a Scheduled Bot fro...
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...
APPS SCRIPT: Custom Confirmation Page + Add-Row When User Clicks URL
This script will add a new row to a table, and display a custom confirmation page to the user. The confirmatio...
Generating Sequential Numbering Using App Script Tasks
There always seems to be a ton of questions asking how to generate sequential numbering in the community. I th...