I give you my expression to calcutate an average time on several days. the [time] column has a duration type. ...
Are you in need of a calendar in your app? Receiving an error? Give the following a try: Where does the calend...
AppSheet allows us to combine the computing power of Google Sheets and other spreadsheets with that of AppShee...
Have you ever wanted a list of all Tables and Column Names in your app, displayed IN your app (not just in the...
Sequential number is not officially supported with AppSheet, but this easy tricks could help some particular b...
It just occurred to me that April 1st is coming up! Something must be done in commemoration (^_^) Here’s a sim...
(This tutorial product tour has been retired, but the app used for it is available here to reference: Facility...
This pattern comes up more and more, so I thought I’d build a simple example. We already know that you can cop...
I was looking for an easy way to help users find images to upload for one of my apps and found THIS BLOG that ...
As we read here, If Expressions Can Conditionally Format a Field. Example But sometimes we need expressions be...
I want to share some testing how special characters and emojis will look in PDF using Google Doc template. It ...
There are ways to navigate from left to right in the editor columns view: using the horizontal scroll bar. usi...
1. App Purpose? Track business expenses 2. Unique Features? Protected view for a single specified user to appr...
It’s not possbile to translate the message, the users see when they open an App first time. App use consent --...
To pick a random row of data from a table, the ANY() function will not suffice. Here’s a simple pattern to do ...
Tips for table view grouping. I’m not perfectly sure when we lost the function, which was available before. It...
Not come across this before so I thought I’d share it. When a Report runs and it’s set to ForEachRowInTable, a...
To put a little different taste and flavour to detail view, this can be additional UI and component as action ...
This quick tip allow you to display thumbnail (or image) in Appsheet view for the screenshot being captured fr...
Further to previous post, I pushed functionality to visualize the Appsheet table data, where we have start/end...
Here is a common scenario, where you may have 2 main data tables, then a single “join” table that is a child o...
When we are on the dropdown selection, such as data type etc, hit the first character, such as a, c, i, etc on...
All, wanted to share this simple way to bring an immersive experience to your app users without placing too ma...
When building Dashboards, make sure you try enabling ‘Interactive’ mode - if your views are built from similar...
SCRIPT NUGGETS Script Editor and Save at room temperature for 35 milliseconds. Ingredient Purpose clearSheetFo...
Wasn’t very sure how to describe this one, see GIF below. This is functionality that I just created similarly ...
If you are storing the data for your app in Google sheets, you are probably aware that you can, if you choose ...
Being able to modify a column’s value outside of the form is extremely helpful in speeding up certain data ent...
concatenate( right("000" & floor([Time_Remaining]), 3), ":", right("00" & number(([Time_Remaining] - floor([Ti...
User | Likes Count |
---|---|
28 | |
22 | |
19 | |
16 | |
12 |