Embedded app view emails, leverage dynamic email in Gmail, that enables users to interact directly with your app in an email. Instead of clicking a link in the email to access the app in a separate browser tab or window. For example, in our sample employee app, if an employee requests an item that needs approval, an automation bot can send an email to a manager to request the approval. The manager can then submit the approval directly within the email instead of navigating to the app to do the same thing. There are some things about embedded app view emails to consider. To view embedded app view email content, the recipient must be an app user. If the content in the embedded app view email becomes outdated, the recipient is instructed to refresh the content. Embedded app view emails are interactive for a fixed period, currently 30 days. After this period, the dynamic portion of the email will no longer render, and users will have to navigate to the app to edit the data. If you want recipients who are outside your domain to receive embedded app few emails, enable the option in your app to require user consent. This can be done in the security options tab in the AppSheet editor. Let's now review how we can create embedded app view emails for your app. We'll use a sample facilities inspection app to walk through the process of creating an embedded app view email. The sample app enables inspectors to report on the status of the facilities within the building. To create an embedded app view email for your app, create an automation bot. Our sample app has an automation bot named Inspection Passed. Next, create an event that will trigger the bot. In our sample app, the bot is triggered by an event that checks when a new row with a status of inspection passed is added to the inspections table. Then create a process that is executed when the bot is triggered. Add a step to the process that runs a task, set the task category to send an email. Configure the task. Set the email type to embedded app view. Set the name of the table that contains the facility inspection data, Inspections. Set the email recipients, email subject, and email body. The configuration in our sample app sends the embedded app view email to the facilities inspector and the inspector's Manager, who are both users of the app. Set the view to be displayed in the embedded app view email. For this task, we use the apps inspections detailed view that displays the columns of an individual row from the inspections table or an individual inspection. Click Save. For embedded app view emails, you can configure two types of views. Detail view. The detail view displays the details of a table row in the app and in the email. To enable an app user to update the values of columns in the Detail view, add one or more quick edit columns to the view. Our sample app includes the Manager Approval quick edit column in the app's inspections detailed view. Quick edit is an AppSheet feature that lets you mark specific columns to be editable directly from an app's Detail view. Form view. The form view is used in an embedded app view email to capture input from the app user. All columns in the form view are editable in the email and are validated when the user submits the form. With the facility inspector role, add a new inspection entry in the app. To add an inspection entry, we use the app preview in the AppSheet editor. The new passed inspection entry triggers the bot that sends the embedded app view email to the recipients that are configured in the task. When an app user who is a manager receives the email, they can click "Yes" or "No" in the email to approve or reject the inspection. Clicking yes or no in the email, saves the data in the form to the apps table and populates the manager approval date and time column in the sheet used by the app. The date and time are then displayed in the email. Some current limitations of embedded app view emails are, they are supported by the Gmail client only. If another client is used to access the email, the recipient must navigate to the app to edit the contents. Only the detail and form view types are supported. Some AppSheet column types such as change, content, price, progress, show, and signature are not supported as editable fields in the embedded app view email. If you forward an embedded app view email, the dynamic portion of the email will no longer render, and users will have to click a link to the app to view and edit the data. Currently, embedded app view emails are interactive for 30 days. After 30 days, the dynamic portion of the email will no longer render and users will have to click a link to navigate to the app to view and edit the data. For a complete list of limitations, read the documentation on the AppSheet website.
