BEHAVIOR | AppSheet Help Center

Controlling the Behavior of Offline Data

AppSheet apps can be used on mobile devices that are not connected with a network -- here's how it works.

Written by Santiago Uribe Montoya
Updated over a week ago

Behavior: The Essentials

You can control how users interact with your app and how your app interacts with the data.

Written by Santiago Uribe Montoya
Updated over a week ago

Actions

Actions: The Essentials

Learn how to use actions to modify data and navigation in your app.

Written by Santiago Uribe Montoya
Updated over a week ago

Bulk Select

When you need to select more than one record at a time in your application

Written by Jennifer Cadence
Updated over a week ago

System Actions

These automatically created actions can be shown or hidden: here's how to customize them.

Written by Santiago Uribe Montoya
Updated over a week ago

Dynamic inputs for data change actions

<BETA Feature> Data-Change actions can have dynamic inputs whose values are assigned at runtime by the user or by another invoking action

Written by Praveen Seshadri
Updated over a week ago

View Events

View actions can run when certain events happen and help you create custom navigation.

Written by Santiago Uribe Montoya
Updated over a week ago

Export This View to a CSV File

Downloads the rows in the specified view to a CSV file.

Written by Santiago Uribe Montoya
Updated over a week ago

Import a CSV File for This View

Uploads the rows in a CSV file to the specified view.

Written by Santiago Uribe Montoya
Updated over a week ago

Configuring the CSV Locale

How to configure the CSV locale

Written by Santiago Uribe Montoya
Updated over a week ago

Editing Multiple Rows Using CSV Export and Import

You can edit multiple rows using CSV Export and CSV Import

Written by Santiago Uribe Montoya
Updated over a week ago

Troubleshooting CSV Export

If the CSV Export data action fails, the following tips may help you resolve the problem.

Written by Santiago Uribe Montoya
Updated over a week ago

Troubleshooting CSV Import

Resolving problems with CSV Import

Written by Santiago Uribe Montoya
Updated over a week ago

Workflow: Introduction

Workflow and Reports: The Essentials

Define automated app behaviors with Workflow and Reports.

Written by Santiago Uribe Montoya
Updated over a week ago

Workflow

Send Email, SMS, or Notifications on Add, Update, or Delete.

Written by Santiago Uribe Montoya
Updated over a week ago

Before and After Values

You can see the value of a column both Before and After it was updated.

Written by Santiago Uribe Montoya
Updated over a week ago

Report Scheduling and Retry

Understanding Report scheduling and retry.

Written by Santiago Uribe Montoya
Updated over a week ago

Reports

Generate reports and take actions on a schedule that you specify.

Written by Santiago Uribe Montoya
Updated over a week ago

Time Zones

A comprehensive list of time zones for Reports.

Written by Santiago Uribe Montoya
Updated over a week ago

Improving Workflow and Report Performance

Tips for measuring and improving Workflow and Report performance.

Written by Santiago Uribe Montoya
Updated over a week ago

Workflow: Sending Email

Sending Email from a Bot, Workflow Rule or Scheduled Report

A Bot, Workflow Rule can send email when data changes. A Scheduled Report can send email on a schedule you specify.

Written by Santiago Uribe Montoya
Updated over a week ago

Email Templates

Controlling the content and format of email messages with templates.

Written by Santiago Uribe Montoya
Updated over a week ago

Google Docs Email Templates

Using Google Docs email templates.

Written by Santiago Uribe Montoya
Updated over a week ago

Microsoft Word Email Templates

Using Microsoft Word email templates.

Written by Santiago Uribe Montoya
Updated over a week ago

Microsoft Excel Email Templates

Using Microsoft Excel email templates.

Written by Santiago Uribe Montoya
Updated over a week ago

Adding a Calendar (.ics) Attachment to an Email

You can add a .ics Calendar attachment to a workflow email message

Written by Praveen Seshadri
Updated over a week ago

CSV Email Templates

Using CSV email templates

Written by Santiago Uribe Montoya
Updated over a week ago

HTML Email Templates

Using HTML email templates

Written by Santiago Uribe Montoya
Updated over a week ago

JSON Email Templates

Using JSON email templates

Written by Santiago Uribe Montoya
Updated over a week ago

XML Email Templates

Using XML email templates

Written by Santiago Uribe Montoya
Updated over a week ago

Template Variables

Using variables in your workflow templates.

Written by Santiago Uribe Montoya
Updated over a week ago

Template CONCATENATE and TEXT Expressions

Using CONCATENATE() and TEXT() expressions in a template.

P

Written by Philip Garrett
Updated over a week ago

Template Image, Thumbnail, Drawing, and Signature Display

Displaying images, thumbnails, drawings, and signatures in templates

Written by Santiago Uribe Montoya
Updated over a week ago

Template Address, LatLong, and XY Display

Displaying Address, LatLong, and XY values in templates

Written by Santiago Uribe Montoya
Updated over a week ago

Template Start Expressions

Using Start expressions in your workflow templates.

Written by Santiago Uribe Montoya
Updated over a week ago

Template If Expressions

Using If expressions in your workflow templates.

Written by Santiago Uribe Montoya
Updated over a week ago

Sample Email Templates

Sample email templates

Written by Santiago Uribe Montoya
Updated over a week ago

Email Attachment File Archiving

You can archive email attachment files.

Written by Santiago Uribe Montoya
Updated over a week ago

Email Attachment File Archiving to Microsoft SharePoint

Archiving your Email attachments to Microsoft SharePoint

Written by Santiago Uribe Montoya
Updated over a week ago

Email Other Attachments

Adding Other Attachments to your workflow email.

Written by Santiago Uribe Montoya
Updated over a week ago

Email "Opt Out" and Unsubscribe

Consider email "Opt Out" and Unsubscribe

Written by Santiago Uribe Montoya
Updated over a week ago

Troubleshooting Workflow Emails

Resolving problems with workflow emails.

Written by Santiago Uribe Montoya
Updated over a week ago

Troubleshooting Email PDF Attachments

Resolving problems with PDF attachments.

Written by Santiago Uribe Montoya
Updated over a week ago

Troubleshooting Custom Fonts

Resolving problems with custom fonts in templates.

Written by Santiago Uribe Montoya
Updated over a week ago

Workflow: Create and Save a File

Creating and Saving a File from a Bot, Workflow Rule or Scheduled Report

A Bot or Workflow Rule can create and save a file when data changes. A Scheduled Report can create and save a file on a specified schedule.

Written by Santiago Uribe Montoya
Updated over a week ago

Uploading .txt Template Files to Google Drive

The "Convert uploaded files to Google Docs editor format" Google Drive option will prevent .txt template files from uploading correctly.

Written by Santiago Uribe Montoya
Updated over a week ago

Save File Archiving

Where Save Files are Archived

Written by Santiago Uribe Montoya
Updated over a week ago

Troubleshooting Create and Save a File

Resolving problems with workflow action Save File.

Written by Santiago Uribe Montoya
Updated over a week ago

Workflow: Sending SMS

Sending SMS from a Bot, Workflow Rule or Scheduled Report

A Bot or Workflow Rule can send an SMS when data changes. A Scheduled Report can send an SMS on a schedule you specify.

Written by Santiago Uribe Montoya
Updated over a week ago

Troubleshooting SMS

You can use Audit History to troubleshoot SMS workflow problems.

Written by Santiago Uribe Montoya
Updated over a week ago

Workflow: Sending Notifications

Sending Notifications from a Bot, Workflow Rule or Scheduled Report

A Bot, Workflow Rule can send a push notification when data changes. A Scheduled Report can send a push notification on a specified schedule

Written by Santiago Uribe Montoya
Updated over a week ago

Troubleshooting Notifications

You can use Audit History to troubleshoot Notification workflow problems.

Written by Santiago Uribe Montoya
Updated over a week ago

Workflow: Changing Data

Changing Data from a Bot, Workflow Rule or Scheduled Report

How to change data in your app on a schedule or when some event happens.

Written by Santiago Uribe Montoya
Updated over a week ago

Troubleshooting Changing Data

How to figure out what's going on with workflow issues.

Written by Santiago Uribe Montoya
Updated over a week ago

Workflow: Invoking Cloud Services

Introduction to Webhooks

How to post to web services and social media.

Written by Santiago Uribe Montoya
Updated over a week ago

Invoking Webhooks from a Bot, Workflow Rule or Scheduled Report

Webhooks allow you to invoke a remote web service to perform an action by sending an HTTP request message to that web service.

Written by Santiago Uribe Montoya
Updated over a week ago

Invoking the AppSheet API from a Webhook

How to invoke the AppSheet API from a webhook.

Written by Santiago Uribe Montoya
Updated over a week ago

Webhook Templates

Controlling the content and format of the webhook body with a template.

Written by Santiago Uribe Montoya
Updated over a week ago

CSV Webhook Templates

Using CSV webhook templates

Written by Santiago Uribe Montoya
Updated over a week ago

Form URL Encoded Webhook Templates

Using Form URL Encoded webhook templates

Written by Santiago Uribe Montoya
Updated over a week ago

HTML Webhook Templates

Using HTML webhook templates

Written by Santiago Uribe Montoya
Updated over a week ago

JSON Webhook Templates

Using JSON webhook templates

Written by Santiago Uribe Montoya
Updated over a week ago

XML Webhook Templates

Using XML webhook templates

Written by Santiago Uribe Montoya
Updated over a week ago

Webhook Image Width

Controlling the image width in Webhook Image URLs

Written by Santiago Uribe Montoya
Updated over a week ago

Troubleshooting Webhooks

How to figure out what's going wrong with your Webhook.

Written by Santiago Uribe Montoya
Updated over a week ago

Integrate with IFTTT

How to integrate your app with a service that lets you connect events and actions.

Written by Santiago Uribe Montoya
Updated over a week ago

Integrate with PHP

How to integrate your app with a PHP service you create.

Written by Santiago Uribe Montoya
Updated over a week ago

Integrate with Pushpad

How to integrate your app with a service that lets you send push notifications to your website or web app.

Written by Santiago Uribe Montoya
Updated over a week ago

Integrate with Zapier

How to get your app to work with a service that allows non-technical users to connect two services' actions together.

Written by Santiago Uribe Montoya
Updated over a week ago

Advanced Topics

Printing Your Data

How to print out data that's been collected in your app.

Written by Santiago Uribe Montoya
Updated over a week ago

Workflow Approvals with Parent Child relationships

Concepts for a Parent Child Workflow Approval App

Written by Ty Alevizos
Updated over a week ago

Trigger Scheduled Reports on Specific Dates

A type of Scheduled Action, Scheduled Reports are a great way to automate whatever materials you need to send out regularly.

Written by Santiago Uribe Montoya
Updated over a week ago

Offline & Sync

Sync: Between the App and the Backend

Learn how the local copy of your data is kept in sync with the backend spreadsheet.

Written by Santiago Uribe Montoya
Updated over a week ago

Offline & Sync: The Essentials

Learn how to control your app's offline behavior.

Written by Santiago Uribe Montoya
Updated over a week ago

Where is My Data Cached?

Learn more about where and how your data is cached and what options you have.

Written by Santiago Uribe Montoya
Updated over a week ago

Can I have my app update automatically?

The AppSheet Editor does provide automatic updates.

Written by Santiago Uribe Montoya
Updated over a week ago

Automatic Updates

Learn how automatic updates work and why they're useful.

Written by Santiago Uribe Montoya
Updated over a week ago

Miscellaneous

Workflow and reports: Important Notification - Effective May 10th, 2021

With the general availability launch of AppSheet Automation, workflow and reports are changing.

L

Written by Liz Lynch
Updated over a week ago