Push notifications are a direct mechanism to alert app users on Android and iOS devices.

Send a notification to one or more recipients by adding the Send a notification task to a bot.

Configure the Send a notification task by setting the properties described in the following tables. When you are done, save the task by selecting one of the following:

  • Save - Save the task

  • Save & verify data - Save the task and verify the data defined.

  • Save & notify users - Save the task and notify users.

After you save the task, you can reuse it in other bots.

See also How AppSheet processes notifications.

Property

Description

Default (if applicable)

Task name

Name of the task. It must be unique within your app.

Table name

Table referenced by the task. Select an existing table in the list.

Click View definition to view the structure of the selected table.

See Tables: The Essentials for more information about adding tables.

To

List of email recipients.

Click Add to add an email address or an expression using the Expression Assistant. Repeat to add additional email recipients.

See Adding email recipients for more information.

Use default content?

Toggle to indicate whether you want to use the default email content or provide customized content.

If enabled, the task uses default content. If disabled, customize the content using the additional properties displayed, as described below.

Enabled

If you disable the Use default content? property, customize the content using the additional properties displayed, as described below.

Property

Description

Default (if applicable)

Title

Title of the notification.

Specify text and variables.

Example: '<<EmployeeName>> please pickup package from <<CustomerName>>'.

Meaningful title



Body

Body of the message.

Specify text and variables.

Example:

<<[FirstName]>> <<[LastName]>> your order for <<[Quantity] * [Price]>> shipped on <<TODAY()>> and will arrive on <<TODAY() + 3>>.

By default, contains the following built-in variables:

<<_ROWKEY>>

<<_UPDATEMODE>>

<<_USERNAME>>

<<_NOW>>

DeepLink

DeepLink to include in the notification. You can use the DeepLink to link to specific application data, including:

  • Your AppSheet application

  • An entire View within your application

  • A filtered View within your application

  • A specific row within a View within your application

  • A form with pre-filled values

  • A custom DeepLink you specify using an expression

Enter a link or an expression using the Expression Assistant.

DeepLink to AppSheet application

How AppSheet processes notifications

You control who receives a notification by specifying the email address of the recipients in the To property when configuring the Send a notification task (above).

AppSheet uses Notification Device Tokens to convert each email address in the To property into the appropriate Device Tokens for the user's mobile devices. If the user has more than one device, the notification is sent to each device that the user has logged in from.


AppSheet handles Notification Device Tokens slightly differently for White Label applications (which are rare) versus non-White Label applications.

Typically, the notification recipient must be an authenticated user who has logged in to at least one AppSheet application using the email address specified in the To property. The application that the user logged in to need not be the application sending the notification.

White Label applications work slightly differently. When a user logs in to a White Label application, the Notification Device Token that is creates by the login contains the AppId of the White Label application. This enables AppSheet to track which White Label applications each user has logged in to and to send notifications appropriately.

For example, assume you have two White Label applications called WhiteA and WhiteB. Assume you have two users User1@gmail.com and User2@gmail.com. Assume that User1 has only logged in to application WhiteA and that User2 has only logged in to application WhiteB. A notification that originates from application WhiteA might specify both User1 and User2 in the To property, but the notification will only be sent to User1 because only that user has logged in to the White Label application. No notification will be sent to User2 because that user has not logged in to the White Label application.

AppSheet sends notifications by performing the following tasks:

  1. Translates the user email address you specify in the To property into an AppSheet User Id. That AppSheet User Id will only exist if the user has logged in to at least one AppSheet application that requires user authentication using the user email address you specify in the To property. The AppSheet application that the user logged in to need not be the AppSheet application sending the notification.

  2. Translates the AppSheet User Id into a list of one or more Google Firebase Cloud Messaging Device Tokens. If the user has a mobile device and has logged in to at least one AppSheet application from that device, then AppSheet will have a unique Device Token registered for the device. AppSheet will send the notification to all of the recipient's registered Device Tokens.

  3. If AppSheet cannot find an AppSheet User Id for the user email address you specify in the To property or cannot find at least one Device Token for the AppSheet User Id, then the bot entry in the Audit History will report the following warning:

    "Warning: No notification sent to 'someuser@somesite.com' because no Notification Device Token is present for this user."

Did this answer your question?