Change the default set, Number of undos allowed. The more is allowed the more memory is used (0-100)
I did not know this setting is available now. This is for those who did not know like me. Go to Manage pane, 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
How to create a multi-user unique key across time and place
I’m throwing this out there for some validation. I searched the community for an answer but didn’t quite find ...
API Errors
If you are working with the AppSheet API we may get Error messages that we don’t understand. For Example: Erro...
Quick Sample App ; custom share button to replace appsheet default one
Recently discussed and found posts from those who wish to have more control over the “share” function of Appsh...
Creating Desktop Shortcuts
Did you know you can create Chrome desktop shortcuts to AppSheet apps on your Mac? (Highlighting this tip from...
How to zoom an image in form view by using XY column type
In form view it is not possible to zoom an image with column Type “Image” or “Show”. This trick uses column ty...
Language Translate
Most of the time, it’s best to remove custom formulas or expressions from your app data source to help optimiz...
Create Reports, Downloadable as PDF or CSV & Viewable as Web Page Using Google Sheet's 'Publish' Feature
From Google Sheet menu File>Publish to the web Select a single sheet, or leave ‘entire document’ selected to c...
Hack to make versatile ref-like actions
Postscript: When I began writing this, I didn’t fully understand the similarities and differences between the ...
Converting text to unique lists for use as tags
If you put a “list” into the “Valid if” part of an Enum or Enumlist column, the content of that list can then ...
Lock down your formulas with type-converters (DATE(), CONCATENATE(), etc.)
I’d like to share what I think is an excellent tip from @MultiTech_Visions that came in response to a problem ...
Community anniversary
I saw this cake icon on one of my DMs today, apparently it is the anniversary of when I joined this community ...
Hide inline action from table view, but make it available on detail view after selecting line item out of table view
When we set action to view as “inline”, it will kill the values of that field in case of “table view”. Let me ...
Finding "countersink" and other special characters
AppSheet uses a countersink icon ( ⌵ ) for dropdown menus: Recently, I wanted to add an explanation about how ...
How do you train your app users?
I’m interested in learning how you train users on the apps you create for them? Do you do 1:1 trainings? Inclu...
Search within page on this community
This post pertains to an earlier discussion about the difficulty of searching within individual pages on this ...
Stable version during prototype development
I use txt file stored in cloud for keeping the history of version numbers that looks stable. This make the res...
Avoid nesting function if possible
This may be useful. I’ve often urgently copied functions from somewhere for my own uses like NOT(CONTEXT(“View...
Voice Recognition to assist typing and data entry
Some of my clients who have been using my Appsheet app for years actually did not know this is available on th...
How to find LATITUDE AND LONGITUDE for Google SHEET
Hi guys, if you are using GSHEET for your data, i would like to advise you that there is an App to add: https:...
Quickly and easily generate Tutorial contents and place on Appsheet app as materials for guide users
My clients ask for “user manual” for app I newly created , but my quick answer is it will not help as people w...
Hiding Fields in Certain Views with CONTEXT()
In order to keep my forms as streamlined as possible, I frequently want to automatically population and hide f...
Using Formatting Icons as Labels or Indicators for Units on the Right of Column Values
Formatting Icons can be used as a right-side labels, or indicators of units for column values. Create an Actio...
Best Practice Recommendations: 'Choice Overload Impedes User Decision-Making'
“As the number of choices increases, so does the effort required to collect information and make good decision...
Updated doc: Math Expressions
Feedback welcome! help.appsheet.com Math Expressions Calculate numeric values from other numeric values.
Sync slow? Your GSheet might be the problem!
If your Google spreadsheet simply holds your data and you can do all of the calculations you need to do withou...
Total hours, minutes, and seconds from Duration
New help docs for recently-added functions: help.appsheet.com TOTALHOURS() Count of hours in Duration help.app...
To, CC & BCC in workflows and reports
Just to clarify the behavour of this after an experiment I’ve just done: Recipients in: To = Can only see them...
Make many views do the work of one
I’m continuing to work on a flashcard app with a view I call “D to W” (definition to word). “D to W” appears t...
Property Info using Google Apps Script and Melissa API
This is an example for all those interested in fetching Property data from Melissa API. I have only used this ...
