Looping with Actions (Sample App BUILD Video)
There have been many posts about this topic, I thought I would throw one out there showing the creation of a s...
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
Snapshot variable for template
We have been working on bugs on template expression, < specifically, which has been addressed now. Thank you s...
How to Show Inline View In Table View
Hi guys @tsuji_koichi @Swoopy @Steve I had been working for a long time on copying Sample Order Capture App. I...
Troubleshooting image/file load issues
A small little debugging tool… help.appsheet.com Images or files that do not load What to do when the app won'...
Feature: Download CSVs of Specified Views
You and your team can now download CSV files from specified views within your application any time you need. T...
Restrict Views for Clients with Full View for Dev/Admin
I was going to ask how to do this, but I got it acting the way I want, so I thought I would share. BLUF: I am ...
New button in Google Sheet "Tools" menu!
Anyone else see this yet? Open in AppSheet. Pretty cool!
BY ACTION ONLY - Update rows in other table using the value in this table and row
There are few posts and threads, questioning how to “Update rows in other table using the value in this table ...
Make hyperlink text wrap properly
First, let me show you an image to illustrate the problem that this workaround addresses: The second line is f...
Executing a DeepLink action from an Email Silently
Hello Everyone, Anyone interested with executing a deeplink action from the inside of an workflow email body w...
Data Organization for Teams
I published a new article about data organization for teams. It is available in the AppSheet help docs. Check ...
Do you want to print something from Appsheet app? Then have a look
I wonder how Appsheet user currently printing out docs from the app, but basically we send the email to the lo...
Tabs in Detail Views
To make your Detail Views have tabs, similar to a how a Form view can have them, follow these steps: Either cr...
Account authentication and password management best practices | Google Cloud
I found a good article on the GCP Blog. Google Cloud Blog Account authentication and password management best ...
CONCATENATING Dates
To maintain your desired Date Formatting when concatenating dates, remember to enclose each date with TEXT() e...
Share own experiences with Community ; Re run OCRTEXT() on the form
I have been seeing bunch of buggy behaivior which is annoying, but I take it a positive side effects which we ...
Compute work time
Given a start date & time (DateTime column) and a number of work hours (Hours column, type Decimal), calculate...
Print from your apps
Using the Beta Zapier integration, it’s possible to connect your apps to the Google Cloud Print network, allow...
How to indent
I’m sure that this little technique of mine is frowned upon by AppSheet. I don’t think it’s part of Google’s “...
Google Calendar data source: Reduce sync time
If you use Google Calendar as a Data Source in your app, the standard setting is: It will read all data 90 day...
Extract lines from multi-line text
This app shows how to extract lines from multi-line text using the SPLIT and INDEX functions. https://www.apps...
Creating JSON data string using Google Sheet formula
If you want to create an adaptive JSON data string for a table, use the following formula ="{" & char(34) & JO...
JSON Template Generator: Google Sheet for Creating Webhook Templates
Sometimes you have to map a LOT of columns from one table to another and create a really big JSON template. I ...
FYI - You can edit native Excel files directly in Google Sheets
For those that didn’t know, you can edit your Excel templates directly in Google Sheets. This might not seem i...
Map Overlay KML Action
We cannot use Overlay Actions in Map Views. But we can use a KMZ file as the “Optional Url for KML File” with ...
Manage App Documentation on GitHub
This is not a perfect method, but it may be better than nothing. The approach is simple. Just save the App Doc...
Google Data Studio - Dashboard - Embed Appsheet App
I created data viewer app for clients and shared as sample with the community before. (CORVID data) I created ...
Handling multiple time zones
The column type “ChangeTimeStamp” records the date and time a change occurred to another column according to t...
Button shaped image placeholder with dynamic controls
It looks nice took to throw additional flavour to App ui to get some row to stand out. ClickMinded – 2 Mar 20 ...
Showing Street view instead of map view
If you want to show the Street view, you can do that if you have a LatLong field already. Create an URL column...
