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 ...
Forum Posts
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...
Language Translate
Most of the time, it’s best to remove custom formulas or expressions from your app data source to help optimiz...
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 ...
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...
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...
Updated doc: Math Expressions
Feedback welcome! help.appsheet.com Math Expressions Calculate numeric values from other numeric values.
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...
New doc: IN()
Finally!!! help.appsheet.com IN() Is item in list?
Adding vertical space between items in detail view
Postscript: The method described in this post works but there’s a much, much easier method. For that, please s...
New & freshened docs: CONTAINS(), FIND()
New (finally!): help.appsheet.com CONTAINS() Does text contain fragment? Freshened: help.appsheet.com FIND() P...
New Expressions :-)
If you are still not aware, pls. checkout https://help.appsheet.com/en/articles/3483429-intersect help.appshee...
SVG Sparklines
Hy there, I needed some kind of sparkline for an application and decided to use SVG image to get it. I don’t k...
UNIQUE() (recently-added function)
In case you haven’t noticed it yet… help.appsheet.com UNIQUE() Unique items in list
Extractdates()
Ever work with dates in expressions? Looking for an easier way to calculate them? Take a look at this powerful...
Deep Links LINKTO___( ) YouTube Playlist
Hey everyone, Here at QREW Tech a lot of our clients we train in AppSheet have trouble grasping the concept of...
Feature: Time Tracking
Are you in need of adding time tracking in your app? Receiving an error? Give the following a try: What is tim...
How to get "randbetween" numbers that change only once per hour
I’ve made an app for language learners and I’ve set it up to display one of 123 “inspirational” quotes in the ...
Marking transactions settled in the order they were created
So here’s a tricky one. I have a table which records sales transactions. If the transaction type is Credit, th...
Retrieving Domain from Email
I was making an app which required partitioning based on the domain of the user email and initially struggled ...
Tips for editing expressions more comfortably
I have three little tips regarding editing expressions that I’d like to share today. You can adjust the size o...
Directional quotes anywhere you want them
In formulas (expressions), AppSheet doesn’t distinguish between directional quotes (left and right different) ...
At most one true value
This app has a yes/no column called Status. It demonstrates how to make it so at most one row in the table has...