In this Quick Start, you'll build your first automation using an AppSheet database. The automation sends an email notification to the assignee when a new task is added directly in the AppSheet database.
To create your first automation using an AppSheet databases, perform the following steps:
- Sign in to AppSheet.
- Open the Tasks App app in the app editor.
You created the Tasks App app when completing the Quick start: Build your first app using an AppSheet database. - In the navigation pane of the app editor, click Automation .
The Bots pane is displayed. - Click + in the top header of the Bots pane.
- In the Add a new bot dialog, click Create a new bot.
A new empty bot is created and displayed in the center pane of the app editor. - Edit the name of the bot.
- Position your cursor over the New Bot in the left navigation pane.
- Select More > Rename.
- Rename the bot to Task complete and press Enter.
- In the new bot flow in the center pane, click Configure event.
- For Event name, enter Task complete and click Create a custom event.
The Settings pane opens in the right side of the app editor.You could also select the Tasks column Task is changed suggestion to automatically configure a portion of the event. But for the purposes of this tutorial you'll learn how to configure the event manually. For more information, see Suggestions in the app editor. -
In the right pane, configure the event settings as follows:
Field Setting Event source Select AppSheet database in the drop-down. Table Select Tasks in the drop-down. Data change type Do the following:
- Select Updates.
- Deselect Adds and Deletes.
Columns to watch for update Open the drop-down menu and do the following:
- Select Status.
- Deselect Task.
- Click Select 1 column(s).
Condition Enter a condition value using the Expression Assistant:
- Click in the Condition field.
The Expression Assistant is displayed. - Enter [Status] = "Complete" in the expression text box.
- Click Save.
The Settings pane appear as follows:
- In the bot flow in the center pane, click + Add a step.
- For Step name, enter Email approver and click Create a custom step.
The Email approver step is added, it is set to Run a task by default, and the configuration settings are displayed in the right pane. - In the right pane, configure the task, as follows:
- Leave the task type set to Send an email.
- For Email Type, click Custom template.
Additional fields are displayed. - In the Table name drop-down, select Tasks (if it is not already selected).
- In the To field, click Add and in the field that is displayed enter your email address (for testing).
- In the Email Subject field, enter: Task complete
- Leave the Email Body set to the default.
The Settings pane appears as follows:
- Click Save to save the app.
-
The following warning message is displayed:
You can ignore this message for now. All test messages will be sent to you as the app owner, so you don't need to deploy the app in order to test the automation.
Next, you'll test your automation.
-
To test your automation:
-
In the navigation pane of the app editor, click Data .
The Data pane is displayed. -
Click Tasks in the Data pane.
-
In the table navigation bar, click View data source.
The My Project Tracker is opened in the AppSheet database editor in a new browser tab. The Tasks table is selected by default. -
In the Write script row, set the Status column to Complete.
-
Check your email for a message titled Task complete.
-
Congratulations! You have created your first AppSheet automation by using an AppSheet database.
What's next? You can access more quick starts to learn about other AppSheet features.