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...
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
Alternatives to LOOKUP(MAX(SELECT(
Continuing the discussion from New INPUT() function — binding dynamic inputs to a data change action: New INPU...
Need to Assign Empty String to a numeric column?
There has been a long standing head-scratcher, that when you assign “” (the empty string) or " " (Space) to a ...
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...
Office Equipment Manager
This ‘Office Equipment Manager’ app is designed for an office or facility manager to help keep track of office...
Multi Select in Map View
We cannot do bulk select in map view Bulk Select Multiselect for Map View Feature Requests We can do Bulk Sele...
Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table
Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it...
Import data from CSV
I conducted quick testing for New Action of “Import CSV file” as it seems to be functional right now. I save t...
Extraer #hashtags de cualquier texto y formatearlos
Para esta tarea necesitamos 3 columnas: La primera, física, contenedora de texto. Summary La primera columna d...
Action: Add a Row to a Table
Actions are manual ways of interacting with your data, allowing app users to visit a URL, start a phone call, ...
How to embed a Sample App into the Community
If you’ve got a sample app that you wish for people to see/use in the community… Example: Manual Sorting Sampl...
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...
REF column type on UserSettings()
I wanted to add this little trick since I didn’t find anything about it Search results for 'ref column on user...
How to calculate duty hours in one day with one click
This sample app shows how you can calculate cumulative duty hours with one click. You can find this sample fro...
Images for country flag - API
This is just for the purpose of sharing a tips and tricks to decorate your app where you do have master table/...
Making rows of views visible for short time
Hi just want to share this trick where in the view the data of the particular row will be visible only for a s...
AnTuTu Benchmark (Performance)
If you have a heavy App, on PC the app may run fast, but on old phones it may be very slow. The AnTuTu Benchma...
SOLVED! Webhook API: Appsheet to Smartsheet - Row Key Not Found:
Hi! I’ve been a lurker in the community and learning a lot from other’s questions. I’m happy to report that my...
[Bar Shape Text Button] Alternative usage of quick edit for detail view with enum/button
I posted a feature request before to get the new feature, “text button” to fire the action etc. While I wait f...
Trigger Workflow With A Simple Action Button
*This tip will let you trigger a workflow without having to double back and clear the trigger column. Let’s cr...
XY Column Type
If you want to customize the base layer of your map view, consider ‘XY’ column types. When the column type is ...
URL to call Cloud Serach
This is a simple trick (can be set up in 10 seconds) If we have a Google Workspace Business Standard plan or h...
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...
Guide: Twilio WhatsApp Message API WebHook with Appsheet Bot
Here is the guide on setup your webhook with Twilio REST API URL: https://api.twilio.com/2010-04-01/Accounts/#...
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(...
Datetime field - better to split to two fields
My app users claimed he could not pick a date for 2019 for datetime field. After investigating the case and ch...
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...
Trigger Actions Directly in Email
Info below provided as-is, you may need to tweak and adjust things to suit your situation and please take note...
