SENDMAIL

Trigger emails with the SENDMAIL function. It can be used to send notifications when data is updated in the report.

Syntax

SENDMAIL(recipients, subject, header)

Arguments

recipients - List of email IDs.

subject - Subject of the email.

header - Email content.

Example

Data input dropdowns have an On Change Formula section where you can specify the actions to be triggered when a user selects an option. In this example, an email notification is automatically triggered when the TaxRate field is updated.

Using SENDMAIL to trigger notifications

In this example, the email notification captures the data updates in the TaxRate field.

Email notification triggered when data inputs are updated